JSON to Google Form: Turn Exported Question Data Into a Quiz
Teams already have questions in data: an LMS export, a quiz app backup, a script that generates items. Google Forms cannot read JSON directly. What you need is a fixed-column spreadsheet built by mapping your JSON fields into named columns, then converted into Form fields — with the question text, options, and answer key carried over exactly as your data holds them and no AI inventing questions. This guide covers the deterministic path from JSON to a Google Form.
Why JSON is not directly importable
JSON is structured data, not a spreadsheet. Google Forms consumes a structured spreadsheet with named columns. So the bridge is: JSON → field mapping → fixed columns (CSV/XLSX) → Form columns → import. Mapping is what turns your keys (for example prompt, choices, key) into the columns Forms reliably recognizes.
The fixed-column layout Forms understand
One row is one question. This layout reshapes each JSON object into the fields Forms import.
| Column | What goes in it |
|---|---|
| question | The question text from your data |
| 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 your JSON is shaped into this sheet and converted into Form columns, every row becomes a question with its original options and answer key intact.
JSON to Google Form in 5 steps
Export your questions
Pull the questions from your LMS, quiz app, or script as JSON. Keep the fields you already have — question, options, and the answer marker.
Map the fields
Your JSON keys are mapped to the fixed columns. Custom field names are aligned to question, options, and correct answer without rewriting the values.
Arrange into fixed columns
One row per question: question text, options (option 1–6), correct answer, and points.
Convert to Form columns
The 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.
Missing fields stay blank, not invented
If a question in your JSON has no points or no image, that column is left empty rather than filled with a guess. The conversion is deterministic — only the values already in your data travel into the Form.
Frequently asked questions
Can I really turn a JSON file of questions into a Google Form?
Yes. A JSON export of questions is mapped field-by-field into a fixed-column spreadsheet (question, options, answer key, points), which is then converted into Form fields. The values already in your JSON are carried over exactly — nothing is invented.
Does the tool rewrite or guess missing fields?
No. The conversion is deterministic: each JSON field is mapped to a column. If a field is absent in your data, the column is simply left blank rather than fabricated. No AI generates new questions or changes the answer key.
What JSON shapes work?
Most question exports work: an array of objects with a question string, an options array, and a correct-answer marker. Custom field names are mapped to the fixed columns during import.
How is this different from an AI quiz maker?
AI quiz makers take a prompt and generate questions. Here the source is your own data file, and only the values in it are converted. No AI is used to create content.
Put your data online
Stop hand-retyping an export, and stop letting an AI rewrite your exam. If the questions are already in your JSON, send them as-is — from JSON to Google Form, with the answer key intact.
Try ExamParser →