Skip to content
FormsGen

Export Google Forms Responses to Excel

The one-off CSV download and the live linked spreadsheet, when to use each, and the response counts at which Google stops keeping up.

There are two ways out of Google Forms and into a spreadsheet, and picking the wrong one is why people end up redoing this every week. One gives you a file. The other gives you a spreadsheet that keeps filling itself in.

The download is a snapshot. Whatever has arrived by the moment you click is in the file, and nothing after it. That is what you want for an archive, or to hand a dataset to someone who will never touch the form.

The linked spreadsheet is live. Every new submission appears as a new row, and anything you build on top of it — a chart, a pivot table, a conditional format that turns a cell red — keeps working as the answers come in. That is what you want for anything ongoing, and it is worth setting up before the responses start rather than after.

The shortcut, if you are on an iPhone

The FormsGen app does this in two taps. Its responses screen has CSV and Excel buttons at the top, alongside a shortcut into the linked Google Sheet, so the whole sequence below collapses into one. Everything on this page still applies if you are at a desk, or on Android, or would simply rather not install anything — which is why the guide comes first and the app comes second.

Why it helps

A snapshot and a live sheet are not interchangeable

The CSV download freezes the responses at the moment you click. The linked spreadsheet keeps growing. Choosing wrongly is what turns this into a weekly chore.

Excel does not need to be involved until the end

Filter, sort and pivot inside Google Sheets, where the data is already live, and download the .xlsx once you actually need a file to send. Downloading first means every change has to be redone by hand later.

Google publishes the point at which this breaks

Past 10,000 responses the per-question and individual views disappear from Forms, and the CSV can no longer be sorted by timestamp. Past 50,000 the summary goes. Past 100,000 responses stop syncing to Sheets altogether. Worth knowing before you build a process on top of it.

How to do it

  1. 1

    Open the form and go to the Responses tab

    Everything below starts here. If the tab shows no responses yet, both routes still work; you will simply get an empty file or an empty sheet.

  2. 2

    For a one-off file: More, then Download responses (.csv)

    The More menu sits at the top of the Responses tab. You get a single CSV, which Excel, Numbers and LibreOffice all open. This is a snapshot and will never update.

  3. 3

    For anything ongoing: Link to Sheets

    At the top right of the Responses tab, click Link to Sheets, then choose Create a new spreadsheet. New submissions land as new rows from that moment on. If you would rather send them into a sheet that already exists, use Select destination for responses and pick Select existing spreadsheet.

  4. 4

    In the spreadsheet: File, then Download, then Microsoft Excel (.xlsx)

    Do this last, once the sheet is arranged the way you want it. The same menu also offers PDF, OpenDocument and CSV, and File then Email as attachment will send the file without downloading it first.

Questions people ask

Does the downloaded CSV update when new responses come in?
No. It is a snapshot of the moment you downloaded it. Only the linked spreadsheet keeps updating.
My CSV opens as one long column in Excel. Why?
Excel splits CSV files on the separator your regional settings expect, and several European locales expect a semicolon rather than a comma. Import the file through Data then From Text/CSV and set the delimiter to comma, instead of double-clicking it.
What happens when a form gets very large?
Google documents three thresholds. Past 10,000 responses, the per-question and individual views stop being available in Forms and the CSV cannot be sorted by timestamp. Past 50,000, the response summary is unavailable. Past 100,000, responses stop syncing to the linked spreadsheet.
Can I make the export happen automatically every week?
Not with Google Forms on its own. The linked spreadsheet is the closest thing to automatic, since it updates itself. Anything beyond that means Apps Script or a third-party tool.
Does the FormsGen app export to Excel?
Yes. Its responses screen exports to CSV and to Excel, and opens the linked Google Sheet, without leaving the app. Reading and exporting responses is part of the paid plan; creating and sharing forms is free.

Two taps instead of four steps

Get it on the App Store

Related tools

Google Forms to PDF

A PDF of the responses and a PDF of the blank form are two different jobs. Both routes, with the one that Google does not document flagged as such.

Google Forms to Google Docs

There is no native export from Forms to Docs. Three things people mean by the question, and what actually works for each.