Start a conversation

Export data formats

Export data formats

Study data

Study data is exported into a wide format. All data for one record (subject/sample) will be presented in one row. The study data export file contains the following columns:

  • Record ID

  • Institute Abbreviation

  • Randomization Id (in case randomization is used)

  • Randomization Group (in case randomization is used)

  • Randomized On (in case randomization is used)

  • Record Creation date

These columns followed by the study variables with rows containing the actual study data. Here is an example:

Reports data

Reports data is exported into a long format. Each report and survey per each record will be exported on a separate row. Please note that each report is exported as a separate file in CSV and SPSS and as a separate tab in Excel.

Report export file contains the following columns:

  • Record Id

  • Report creating date

  • Report Name Custom

  • Report Parent

These columns are followed by the report variables with rows containing the actual report data. Here is an example:

Surveys data

Surveys data is exported into a long format. Each survey per each record will be exported on a separate row. Please note that each survey is exported as a separate file in CSV and SPSS and as a separate tab in Excel.

Survey export file contains the following columns:

  • Survey Instance Id

  • Castor Record Id

  • Survey creation date

  • Survey sent date

  • Survey Progress

  • Survey Completed On

  • Survey Parent

  • Survey Package Name

  • Survey Package Id

These columns are followed by the survey variables with rows containing the actual survey data. Here is an example:

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Castor Support Team

  2. Posted
  3. Updated