Skip to main content
Export your response data to analyze in spreadsheets, statistical software, or other tools. Download complete datasets or filtered subsets in various formats.

Why Export?

Export your data to:
  • Analyze in Excel, Google Sheets, or SPSS
  • Create custom visualizations
  • Archive for records
  • Share with stakeholders
  • Combine with other data sources

Export Options

File Formats

FormatBest For
CSVUniversal compatibility, spreadsheets
Excel (XLSX)Direct use in Microsoft Excel

Data Scope

Choose what to export:
  • All responses: Complete dataset
  • Filtered responses: Only responses matching current filters
  • Completed only: Exclude incomplete responses

How to Export

1

Go to Responses Tab

Navigate to the Responses section of your study.
2

Apply Filters (Optional)

Filter to the subset of data you want to export.
3

Click Export

Find and click the Export button.
4

Choose Options

Select:
  • File format
  • Which responses to include
  • Which fields to export
5

Download

Generate and download your file.

What’s Included in Exports

Standard Export Fields

FieldDescription
Response IDUnique identifier for each response
StatusCompleted, screened out, etc.
Start timeWhen participant began
End timeWhen participant finished
DurationTotal time spent
PanelWhich panel the participant belongs to

Question Data

For each question:
  • Question text or identifier
  • Participant’s answer
  • For multiple choice: selected option(s)
  • For scales: numeric value
  • For open-ended: full text response

Media Response Data

For video/audio questions:
  • Transcript text
  • Recording duration
  • Quality indicators
  • Link to media (if applicable)

Quality Metrics

If included:
  • Overall quality score
  • Specific quality flags
  • Time-per-question data

Working with Exported Data

Opening CSV Files

In Excel:
  1. Open Excel
  2. File → Open
  3. Select your CSV file
  4. Follow the import wizard (choose comma delimiter)
In Google Sheets:
  1. Open Google Sheets
  2. File → Import
  3. Upload your CSV
  4. Select import settings

Data Cleaning Tips

After export, you may need to:
  • Remove test responses (if not already filtered)
  • Handle missing values
  • Check for formatting issues
  • Validate data types

Analyzing in External Tools

Excel/Sheets: Pivot tables, charts, basic statistics SPSS/Stata: Advanced statistical analysis R/Python: Custom analysis and visualization Tableau/PowerBI: Interactive dashboards

Export Best Practices

Export frequently. Create regular backups of your data, especially for ongoing studies.
Document your exports. Note the date, filters applied, and purpose for each export.
Check row counts. Verify the exported row count matches your expected number of responses.
Review a sample. Spot-check a few rows to ensure data looks correct.

Handling Large Exports

For studies with many responses:
  • Export may take longer to generate
  • Consider exporting in batches if available
  • Large files may need to be opened in specialized tools

Export and Privacy

Data Handling

When exporting:
  • Files contain participant data
  • Handle according to your privacy policies
  • Secure storage and sharing
  • Delete files when no longer needed

What’s NOT Included

Exports typically exclude:
  • Raw media files (video/audio recordings)
  • System metadata
  • Account information
Media files (videos, audio recordings) are not included in standard exports. Transcripts are typically included.

Scheduled Exports

If available, you may set up:
  • Automatic daily/weekly exports
  • Email delivery of exports
  • Integration with cloud storage

Common Export Scenarios

  1. Filter: Status = Completed
  2. Filter: Quality = High
  3. Click Export
  4. Download filtered data
  1. Filter: Panel = [Your Panel]
  2. Optionally add: Status = Completed
  3. Export the filtered view
  1. Clear all filters (show all responses)
  2. Export without filtering
  3. Save file with date in filename
  1. Select the format your tool prefers (usually CSV)
  2. Export the data
  3. Import into your tool following its documentation

Troubleshooting Exports

Export Not Downloading

  • Check your browser’s download settings
  • Try a different browser
  • Ensure pop-ups aren’t blocked
  • Check your internet connection

File Won’t Open

  • Verify file downloaded completely
  • Check file format matches expected
  • Try opening in a different application
  • Re-export if file appears corrupted

Data Looks Wrong

  • Check character encoding (UTF-8 recommended)
  • Verify delimiter settings when importing
  • Look for any transformation that occurred
  • Compare row count with expected

Next Steps