Export form responses to CSV or Excel
Exports are on every plan. Open a form's Responses page, press Export CSV or Export XLSX, and the file downloads straight away. Below: what the file holds, then what each tab on the page shows.
Last updated
Export to CSV or Excel
- Open the form from your dashboard and choose Responses at the top. The page has five tabs: Summary, Insights, Responses, Partial and Spam.
- Press Export CSV or Export XLSX, top right. You get every response, oldest first, in one file named after the form and today's date.
- To export only some, filter first: answer filters on the Summary and Responses tabs apply to the export too. Or check rows on the Responses tab and choose Export selected (CSV) or XLSX; Select all takes every response that matches. Filtering a spirit wear order form by color gives the printer a count for each size, and filtering a lunch order form by date gives the kitchen its list. The same works for a leave request form filtered by type of leave for payroll, or a photo contest entry form filtered by category for each judge.
- Open the file in Excel, Numbers or Google Sheets.
Both formats hold the same columns. One export takes up to 250,000 responses. Responses held in the Spam tab are left out, and partial responses have their own export on the Partial tab: Export partial responses (CSV). For a spreadsheet that updates itself, connect Google Sheets in the Workflows tab instead.
What the file contains
- One row per response. The first column,
submitted_at, is the time it arrived, in UTC. Thenip_hashanduser_agent, unless the form is in anonymous mode. - One column per question, in the form's order, headed with the question's title. Choices show their labels, several picks read "A | B", an "Other" answer reads "Other: …", a grid reads "Row: Column", and names and addresses are written out in full. Phone numbers are in international format, such as +15551234567, so the numbers on an emergency contact information form can be dialed from any country. Dates read 2026-09-22 and times 14:30, as the person entered them.
- Columns built for analysis: after the question columns, one 1 or 0 column per checkbox option (blank when the question was not answered) and one column per grid row, so you can count and pivot without splitting text.
- Everything captured with the response:
response_id, each hidden field ashidden:name, each calculated value asvar:name, the ending reached, what each consent box said and when it was agreed to, and for a signature, how and when it was made. - Files and signatures appear as links. They open only for someone signed in to your account, so a forwarded spreadsheet does not expose the files.
Some templates are built around these columns. An event vendor application gives each market date its own 1 or 0 column, so you can count vendors per day. An academic conference registration form keeps badge name, organization and job title apart for printing badges. An address collection form writes the whole address in one cell for envelope labels, and a property condition report gives each room item its own column, so move-in and move-out line up.
A fundraiser order form has a seller column to sort by for prizes, a party RSVP form gives each guest's meal its own column, and a picture release form keeps the exact wording each parent agreed to, with the time. Add limit and account number columns to a customer credit application export and it becomes your credit register. Order and finance forms work the same way: a retailer order form gives each SKU its own column for the pick list, and a check requisition form puts each amount and code in its own column for the books.
When you change the form, the next export follows the form as it is now. A renamed question gets its new title as the header. A new question gets a column in its place. Answers to a deleted question are kept, in a column at the end marked "(deleted question)".
The CSV is UTF-8, so accents and other alphabets open correctly in Excel. A cell that starts with =, +, - or @ gets a leading apostrophe, so a spreadsheet shows it as text instead of running it as a formula.
Answer summaries
The Summary tab gives every question a chart and a count, in the order of the form. Choice questions get bars, ratings get distributions, and an NPS question gets its score worked out for you, with promoters, passives and detractors. Summaries are free on every plan, with no time limit.
Written answers are listed, and a question with 5 or more of them also gets keyword themes. Press Summarize with AI on that question to have AI group the answers instead: nothing goes to AI until you press it, and then up to 300 of that question's written answers do. It suits evaluation forms such as a conference evaluation form, a lesson observation template or a course evaluation form, and the open answers on an anonymous suggestion form.
The Responses tab
The Responses tab has one row per response, with search and filters. Open a row to read the whole response. From there you can:
- Download PDF of that response, on every plan. Response PDFs covers one PDF, many in one file, and PDFs attached to emails.
- Reply to the person in Your reply, when the form asked for their email. Their answer comes back to the same thread. See replying from a response.
- Delete this response, which removes its answers and uploaded files for good.
Your responses are yours to take elsewhere, on every plan. The limits that do apply are in the fair use policy.
Visits, starts and completions
The Insights tab counts views, starts and completions, the completion rate and the median time to finish, and breaks visits down by source, device and country. The free plan shows the last 7 days. PulseFormCreator Pro shows the full history.
If the form is set to anonymous mode, Insights still counts visits, but has no sources, devices or countries, because we do not record them. Choose anonymous mode when candid answers matter more to you than knowing where people came from.
Drop-off and partial responses
Drop-off insights show how far people get through the form and which question they leave on. Partial responses keep the answers of people who start and do not finish, in the Partial tab. Free shows the last 7 days of them and Pro shows all of them; drop-off insights are a Pro feature.
They differ in one way. Drop-off is worked out from the visits every form records, whatever its plan. Partial responses are kept only once you turn on Collect partial responses in Settings, under Responses, and cannot be recovered for anyone who answered before that. They are never counted in your summary. On Pro, a workflow can send them to your tools and email a reminder. The comparison with Tally sets both against Tally's versions.
Once you know where people leave, the fix is usually in the logic: skip the question for the people it does not apply to. On Pro, Win back unfinished forms can also email people who stopped halfway, with a link that brings back their answers.
The Spam tab
Submissions caught by the spam checks are kept in the Spam tab instead of being thrown away. Each one says why it was caught: the hidden field was filled, it was submitted too fast, it duplicated an earlier response, or AI flagged it on a form with AI triage on. Spam is not counted, summarized, exported or sent to integrations.
If one is real, press Not spam. It moves back into your responses and runs, once, whatever was held back: triage, People, notifications and workflows.
Did this answer your question?
If it did not, tell us what was missing and we will fix the article.