--- title: "Google Sheet to Google Form With an Answer Key | Formswrite Blog" description: "Turn a Google Sheet question bank into a self-grading Google Form quiz: the column layout, the answer column, and how to set points and feedback afterwards." canonical: https://formswrite.com/blog/google-sheet-to-google-form-answer-key last-updated: 2026-10-08 --- # Google Sheet to Google Form With an Answer Key In short To turn a Google Sheet into a self-grading Google Form quiz, give the sheet a question column, option columns and a correct-answer column, download it as .xlsx or .csv, and upload it to a converter that reads the layout. The correct-answer column becomes the answer key, so the form can mark responses as soon as students submit. ## Set up the sheet Use the first tab and one row per question. A layout that converts cleanly looks like this: | Question | Option 1 | Option 2 | Option 3 | Option 4 | Correct answer | | --- | --- | --- | --- | --- | --- | | What is the capital of France? | Madrid | Paris | Rome | Berlin | Paris | | The Earth orbits the Sun. | True | False | | | True | | Briefly explain photosynthesis. | | | | | | The correct answer can be written as the option text, as in the example above, which is the layout the [Google Sheets to Google Form converter](/convert/google-sheets-to-google-form) shows in its own sample. A row with no options and no answer becomes a short answer question, and it is not auto-graded. Two small habits save time later. First, type the answer exactly as it appears in the option cell, because a typo such as "Pairs" means the key does not match any option. Second, keep the answer column last, so nobody mistakes it for an option. ## Convert it step by step 1. In Google Sheets, open File, then Download, and choose Microsoft Excel (.xlsx) or Comma-separated values (.csv). The .xlsx file keeps more, as explained in our comparison of [XLSX and CSV for quiz import](/blog/xlsx-or-csv-for-google-forms-import). 2. Open the [Google Sheets to Google Form converter](/convert/google-sheets-to-google-form) and upload the file. 3. Check the preview. Each row should show as a question, with its options and the correct answer marked. 4. Fix anything that looks wrong in the editor, then export to Google Forms. The form lands in your Drive. 5. Open the form in Google Forms and confirm that the quiz setting is on, which is covered below. If your sheet has several tabs, only the first is processed. Copy the tab you want to the front, or follow our guide to splitting a [workbook with multiple sheets into separate forms](/blog/excel-workbook-multiple-sheets-to-google-forms). ## What to finish inside Google Forms The converter builds the questions and the key. A few quiz settings live in Google Forms itself and are worth a minute of your time: - **Quiz mode.** In Settings, under Quizzes, the option to make the form a quiz should be on. The question importer turns quiz mode on when it detects an answer key, but look to be sure. - **Points.** Each question has a point value you can change. Questions default to a standard value, so raise the weight of the ones that matter more. - **Release of scores.** You decide whether students see their score immediately or after you review. Our guide on [where the answer key lives in Google Forms](/blog/where-to-find-answer-key-in-google-forms) explains the options. - **Feedback.** Add a short explanation to questions students often miss. It shows when they see the results. The [answer key tool](/tools/answer-key-for-google-form) is useful if you already have a form and only need to add or correct the key. ## The alternatives, and why you might skip them You can build a form from a sheet with Apps Script. It is free and flexible, but you write and maintain code, and the script has to handle question types, shuffling and the answer key itself. That is a fair choice for a developer who builds many forms. For a teacher with one question bank, uploading a file is faster. You can also copy and paste each question by hand. This works for ten questions and becomes painful at fifty. ## Free and paid Uploading the file and previewing the extracted questions is free. The free plan lets you keep five Formswrite Forms a month, and a Formswrite form is a self-contained quiz page you can share with students. Exporting to Google Forms is a paid feature. Respondents to a Formswrite form do not need a Google account. [Convert your Google Sheet](/convert/google-sheets-to-google-form) ## Check before you send it to students Take the quiz yourself with a few deliberately wrong answers. Confirm that the score appears the way you want, and that open-ended rows are waiting for manual marking rather than silently scoring zero. It takes two minutes and it catches the most common mistake, which is a typo in the answer column. ## FAQ Can I convert a Google Sheet to a Google Form without code? Yes. Download the sheet as .xlsx or .csv, upload it to a converter such as Formswrite, review the preview and export. No Apps Script or add-on is needed. Does the answer key transfer automatically? Yes, when the sheet has a correct-answer column. The converter reads it and sets the answer key in the form. Rows without an answer, such as open-ended questions, are left for manual marking. What happens to formulas in my sheet? The converter reads the calculated value of each formula cell, not the formula. A cell that shows Paris because of a lookup is read as the text Paris. Can I use options written in a single cell? The converter page says options in one comma-separated cell are split into separate choices. Separate columns are the least ambiguous layout, especially when an option itself contains a comma. Do students need a Google account to answer? That depends on the form settings in Google Forms. A Formswrite form hosted on Formswrite does not require respondents to have a Google account.