Airtable to Google Form: Turn a Base or Table of Questions Into a Quiz
Teachers and trainers often keep a question bank in Airtable — a base with a question field, option fields, and an answer field. But Airtable is not a quiz engine, and Google Forms cannot read an Airtable base directly. What bridges them is a fixed-column spreadsheet: export the Airtable table to CSV, reshape it into one row per question, then convert it into Form fields — with the question, options, and answer key carried over exactly as written and no AI inventing questions. This guide covers the deterministic path from Airtable to a Google Form.
Why Airtable is not directly importable
Airtable stores rows, not Form fields. Google Forms consumes a structured spreadsheet with named columns. So the bridge is: Airtable → CSV export → fixed columns → Form columns → import. The CSV is what turns your base into data Forms reliably recognizes.
The fixed-column layout Forms understand
One row is one question. Map your Airtable fields into this layout so each question becomes a Form item with its original options and answer key intact.
| Column | What goes in it |
|---|---|
| question | The question text from your Airtable field |
| option 1 … option 6 | Answer choices (leave unused blank) |
| correct answer | The correct option number (1–6) |
| points | Points for that question (optional) |
| image | One public image URL for the question (optional) |
Once the CSV is shaped into this sheet and converted into Form columns, every Airtable row becomes a question with its original options and answer key intact.
Airtable to Google Form in 5 steps
Export the Airtable view
From the view that holds your questions, choose CSV export. One row per question with a question field, option fields, and an answer field.
Map into fixed columns
Rename or arrange the CSV so each row has question text, options (option 1–6), and the correct answer. Only column names change; content stays.
Convert to Form columns
The shaped sheet is turned into the columns Forms reads — question, options, answer key, and points.
Import and grade
Load the file into the Form, then enable Settings > Quizzes with the answer key filled. Submissions grade themselves.
Keep Airtable as your base
Edit questions in Airtable anytime, re-export the CSV, and reconvert — the Form updates from the same bridge.
Diagrams travel too
Questions that depend on a figure can keep an image URL column, so the diagram moves into the Form alongside the text. A geometry or chart question loses nothing in the conversion.
Frequently asked questions
Can I move questions from Airtable into a Google Form?
Yes. Export the Airtable view or table as CSV, reshape it into a fixed-column spreadsheet (one row per question), then convert that sheet into Google Form fields. The question text, options, and answer key from Airtable are carried over exactly — nothing is invented.
Do I need to rewrite the questions by hand?
No. The columns you already use in Airtable (a question column, option columns, an answer column) are mapped into the fixed layout. You only rename columns if they differ; the content stays as written.
How is this different from an AI quiz maker?
AI quiz makers generate questions from a prompt and may change the answer key. Here Airtable is the source of truth — only the rows you already have are converted. No AI is used to create content, so a graded quiz stays accurate.
What if my Airtable base has attachments or long text?
Long-text question fields carry over as the question stem. For diagrams, keep one image URL column so the picture travels into the Form alongside the text.
Can I keep editing in Airtable afterward?
Yes. Airtable remains your authoring base. Whenever you add or change questions there, re-export the CSV and reconvert — the Form updates from the same fixed-column bridge.
Turn your Airtable base into a quiz
Stop copy-pasting rows from Airtable into the form editor by hand, and stop letting an AI rewrite your questions. If the questions are already in your base, send them as-is — from Airtable to Google Form, with the answer key intact.
Try ExamParser →