Once a form is published and begins collecting data, you can export its data as a CSV file from Form Center. A CSV will not be generated if there is no data to export.
To export data, access Form Center, and click on the export CSV button for your form:
Note: Only notebook Owners or designated Account Administrators have access to the Form Center and, therefore, are the only ones who can export data.
A CSV file will be generated and you will receive a download link by email once the data export is complete.
CSV Export
The data contained in the CSV export is organized in a data table, where each row represents data from an individual form. The columns of the table are organized as follows:
Metadata columns
- Entry: Url link to ELN form entry
- Notebook: Name of the notebook where form entry is saved
- Created: Date and time of form entry creation
- Last Edit: Date and time of form entry last edit
- User: email of the notebook user who made the last edit
Data Columns
- The remaining columns of your CSV export will depend on your form fields and labels. Each custom field is represented by a single column
- For Checkbox Group or Select fields, multiple selections will be represented within the same cell and delineated with a “|” character (ie. “Option 1 | Option 2 | Option 3”)