Exporting Data to CSV
Export your survey response data to a CSV file
Export your Zigpoll survey response data to a CSV file for analysis in Excel, Google Sheets, or other tools.
Where to export from
Account or survey Dashboard, or Export CSV in a survey's ⋯ menu
Export to CSV
Every participant who answered a survey, with their answers to it.
Emailed
Table
Export to CSV
The table you built, with all columns or only the ones you've selected.
Emailed
Participants
Export to CSV
Participant details. Turn on Include Responses to add their answers.
Emailed
Answers
Download CSV
The answers listed on the page, one row per answer, with your current filter and search applied.
Downloads right away
Table is the page that used to be called Reports. You'll find it in the sidebar, or choose View Table from a survey's ⋯ menu.
Manual Export
Open your Zigpoll dashboard (the account dashboard, a survey's dashboard, or the Table page).
Click the Export to CSV button.
Choose the survey (on the account dashboard) and the Date Range.
Check the address under Send To: and click Email CSV.
You can also download a full export file for a single survey from the survey's Settings → General → Manage sub-tab via Download JSON. That file holds the survey's questions and settings for importing into another account. It contains no responses.
When your export arrives
Emailed exports come from support@zigpoll.com with the subject [Zigpoll] Your CSV Export is Complete. Large exports can take up to an hour. You can run one export at a time. While one is running, the export window shows its progress.
By default the email contains a download link, which expires after 7 days. To get the file attached instead, go to Settings → Data Export and set Export Type to Include as attachment. Attachments are limited to 20MB, so keep links on for large exports.
If Google Sheets is connected, the export window also has Save to Sheets. It puts the export in a new Google Sheet and emails you the link.
My CSV export never arrived
Wait up to an hour. Large accounts take longer.
Check spam for mail from
support@zigpoll.com.Check the Send To: address in the export window. The export goes only to that address.
Check the file size. If you set Export Type to Include as attachment, a large file may not fit in an email. Switch back to Send a download link and export again.
Try a different address. If it still doesn't arrive, contact support@zigpoll.com.
My export says "No Results Found"
The CSV holds a single No Results Found row when nobody answered the selected survey in the date range you chose. Pick a wider date range, or check that you selected the right survey. The Table page shows "No results found." for the same reason.
How rows are organized
In the dashboard, Table, and Participants exports, each row is one session of one participant, not one person. If someone comes back to a survey later, or answers it on a different page, their answers land on a second row with the same Id. Group or de-duplicate by Id to count people.
That's why your row count may not match the counts on your dashboard:
One person can have several rows.
Answers on your dashboard counts every question answered, so it is usually much higher than the row count.
Only answers given inside the Date Range are included, so a row can be missing answers given before the range starts.
The Answers page's Download CSV is different. It has one row per answer.
How answers appear in the CSV
Each question gets its own column, named
Slide: <question text> | Id: <question ID>.A multi-select answer sits in one cell, with the choices separated by commas, for example
Red, Blue. To use a different separator, go to Settings → Data Export and change Delimiter.Metadata appears in
Survey Metadata: <key>columns.If long numbers such as order IDs turn into scientific notation in Excel, turn on Disable Excel Formatting under Settings → Data Export.
Export without personal data
The Table page lets you choose columns:
Open Table and select your survey and date range.
Use the column picker to untick the columns you don't want, such as email addresses, IP address, or customer IDs.
Click Export to CSV, choose Include selected columns only, and click Email CSV.
Your column choices are remembered in your browser. Scheduled exports have the same option: see Automations. The dashboard and Participants exports always include every column.
Automated Exports
To receive regular exports on a schedule, use Scheduled Exports in the sidebar. You can email a CSV, update a Google Sheet, or post JSON to your own endpoint, daily, weekly, or monthly. For more details, see Automations.
Last updated

