We are here for you! πŸ‘‹

How to export data

Learn how to export the data you collect with Studypages Data to different formats like CSV, TSV and Excel.

Last updated

February 18, 2025

new

Prerequisites for this guide:

‍

‍

To access the export functionality, go to Studypages Data Web, login and click on Export Data from the left menu:

‍

Export files

Data on Studypages Data can be export to CSV, TSV and Excel. Each form you create on Studypages Data generates a single file. The export file includes a table with one entry per line and each field, or form question, on a separate column.

‍

Choice fields

Choice fields on Studypages Data are used for fields with limited options, for example 'What is your blood type?'. Each option on a choice field is made up of a label (e.g. A, B, AB or O) and a coded value (e.g. 1, 2, 3, 4).

When exporting data you can choose for the output table to display the labels of choice fields or their respective coded values. Choosing coded values will generate columns per each choice and display a 1 or a 0 if the choice was selected or not, respectively.

‍

Additional data

The first columns on the export data correspond to automatic fields that that the Studypages Data platform generates to facilitate your analysis:

  • Identifier: Unique ID of an entry
  • Responder: Name of the user that created that entry
  • Case Identifier: On Longitudinal studies, entries can be associated to a case. The case identifier is a unique ID the platform generates for ID.
  • Case label: User generated label for that case.
  • Creation: Timestamp when the entry was created.

Prerequisites for this guide:

‍

‍

To access the export functionality, go to Studypages Data Web, login and click on Export Data from the left menu:

‍

Export files

Data on Studypages Data can be export to CSV, TSV and Excel. Each form you create on Studypages Data generates a single file. The export file includes a table with one entry per line and each field, or form question, on a separate column.

‍

Choice fields

Choice fields on Studypages Data are used for fields with limited options, for example 'What is your blood type?'. Each option on a choice field is made up of a label (e.g. A, B, AB or O) and a coded value (e.g. 1, 2, 3, 4).

When exporting data you can choose for the output table to display the labels of choice fields or their respective coded values. Choosing coded values will generate columns per each choice and display a 1 or a 0 if the choice was selected or not, respectively.

‍

Additional data

The first columns on the export data correspond to automatic fields that that the Studypages Data platform generates to facilitate your analysis:

  • Identifier: Unique ID of an entry
  • Responder: Name of the user that created that entry
  • Case Identifier: On Longitudinal studies, entries can be associated to a case. The case identifier is a unique ID the platform generates for ID.
  • Case label: User generated label for that case.
  • Creation: Timestamp when the entry was created.

Still need help? We are standing by and ready to help.