Export Google Form to CSV: Questions, Options and Responses

Updated November 11, 2026 · ~8 min read

"export google form to csv" sounds simple, and for responses it is: open the Responses tab, click the Sheets icon, download as CSV. But that file contains only what people answered. If you want the questions, options and answer key — the quiz itself — Google Forms has no CSV export at all. This guide separates the two jobs and shows how to get a clean CSV for either, with the column layout and the encoding traps that usually cause trouble.

Two different CSVs: The response CSV (native, one row per submission) and the question-bank CSV (one row per question, with options and the answer key). Google Forms only gives you the first one.

Export Google Form responses to CSV (the native way)

Open the form → Responses tab.
Click the green Google Sheets icon to create a linked response sheet.
In Sheets: File → Download → Comma-separated values (.csv).

Or use Responses → More → Download responses (.csv) where available. You get one row per submission, with a Timestamp column and one column per question. That is it — no answer key, no points, no question types, no image URLs.

Export Google Form questions to CSV (what native cannot do)

To export google form questions to csv, you need the form definition: number, type, stem, options, correct answer, points, difficulty and image URL. Google Forms does not expose this as a CSV, which is why searches for "convert google form to csv file" end up on third-party converters.

A clean question-bank CSV uses one fixed row per question:

Number,Type,Stem,Option A,Option B,Option C,Option D,Option E,Answer,Marks,Difficulty,Image URL
1,Single choice,"Which planet is closest to the Sun?","Mercury","Venus","Earth","Mars","",A,1,Easy,""
2,True/False,"The Earth is flat.","True","False","","","",False,1,Easy,""

With this shape you can edit the whole quiz in a spreadsheet, diff two versions, keep it in version control, or re-import it into Moodle (GIFT/QTI), Canvas, Quizizz, Kahoot or Google Forms again.

How to convert a Google Form to a CSV file in 5 steps

CSV pitfalls: encoding, commas and line breaks

Excel shows garbled characters. Save/open as UTF-8 with BOM if your Excel double-clicks the file and mangles accented or non-Latin text.
Columns shift. A comma inside a question or a choice must be quoted. Proper CSV escaping quotes any field containing a comma, a double quote, or a newline, and doubles internal quotes.
Multi-line questions break rows. Keep line breaks inside quoted fields, otherwise one question becomes several rows.
Leading zeros vanish. IDs like 0012 get converted to numbers by Excel. Import them as text.
Blank options. Leave unused Option columns empty rather than removing them, so the column count stays fixed.

When to use CSV vs Excel vs Google Sheets

CSV is the interchange format: plain, portable, diffable, no lock-in. Use it for migration and backups. If you want formulas, formatting and grading in a workbook, use Google Form to Excel Automatically. If you want a live sheet that updates as responses arrive, see Link Google Form to Google Sheets.

Decide which CSV

Responses (submissions) or question bank (structure) — they are different files.

For responses

Responses tab → linked Sheet → File → Download → CSV.

For the question bank

Parse the form into Number/Type/Stem/Option A–E/Answer/Marks/Difficulty/Image URL.

Verify the encoding

UTF-8, quoted fields for commas and newlines, fixed column count.

Reuse it

Edit in a spreadsheet, back it up, or re-import into any LMS or form builder.

Frequently asked questions

How do I export a Google Form to CSV?

For responses: open the Responses tab, create the linked Google Sheet, then File > Download > Comma-separated values (.csv). For the questions and answer key, Google Forms has no CSV export; you need a converter that outputs the question structure as fixed columns.

Can you export Google Form questions to CSV?

Not natively. Google Forms stores questions as form objects and only exports submitted answers. A structured converter reads the questions, options, correct answers and points, then writes one CSV row per question.

What columns should a Google Form CSV have?

For a question bank: Number, Type, Stem, Option A–E, Answer, Marks, Difficulty and Image URL. Keeping a fixed schema means you can re-import the file into Google Forms, Moodle, Canvas, Quizizz or Kahoot without re-typing.

Why does my CSV open with garbled characters in Excel?

The file is UTF-8 but Excel guessed a different code page. Export UTF-8 with BOM, or use Data > From Text/CSV and set the encoding explicitly to UTF-8.

Is a CSV export better than a PDF or Word copy?

For data, yes. CSV is portable and diffable and keeps the answer key as a field. For a printable handout use PDF, and for an editable document use Word. See the related guides below.

Google Form converters

ExamParser has a dedicated page for each export format. Use the one that matches the file you need — Word for an editable document, PDF for a fixed archive copy, CSV for raw data, Excel for a working spreadsheet, and Google Sheets for a live linked sheet.

GGoogle Form to Word(.docx) GGoogle Form to PDF GGoogle Form to CSV GGoogle Form to Excel GGoogle Form to Google Sheets

Related guides

Export your Google Form to a clean CSV

Stop rebuilding question banks by hand from the response sheet. Get a fixed-schema CSV with questions, options and the answer key intact — UTF-8, properly quoted, no AI rewriting.

Open the Google Form to Word converter →