Start a conversation

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