Google Sheets to Google Form: Step-by-Step Guide
Dvir Atias
Jun 06, 2025
Google Sheets to Google Form: Step-by-Step Guide
To convert Google Sheets to a Google Form, you have three routes: copy questions manually into Google Forms, run a short Apps Script that builds the form from your sheet headers, or paste your content into Formswrite for a one-click conversion. The fastest method takes under two minutes and requires no code.
Google does not include a built-in "convert sheet to form" button, which is why so many people end up retyping questions by hand. This guide covers all three methods clearly so you can pick the one that fits your situation.
Why convert Google Sheets to Google Form?
Google Sheets is great for organizing existing data. Google Forms is built to collect new data. When your questions, answer options, or survey items already live in a spreadsheet, converting that sheet into a form lets you:
- Standardize responses and avoid free-text variation
- Send a form link instead of sharing a spreadsheet
- Automatically funnel new responses back into Sheets
- Reuse the same question set across multiple forms
Three methods compared
| Method | Speed | Requires code? | Best for |
|---|---|---|---|
| Manual copy-paste | Slow | No | A handful of questions |
| Apps Script | Medium | Yes (short) | Developers comfortable with JS |
| Formswrite | Fast | No | Any document, any size |
Method 1: Manual copy-paste
If you only have a few questions, copying manually is the most straightforward path.
Step 1: Open your Google Sheet
Identify the column that holds your questions and the columns (if any) that hold answer options. Tidy up any merged cells or extra formatting before you start.
Step 2: Open Google Forms
Go to forms.google.com and create a blank form. Give it a title.
Step 3: Add each question by hand
For each row in your sheet, click "Add question" in the form, paste the question text, choose the question type (multiple choice, short answer, checkboxes, etc.), and paste the answer options one by one.
Step 4: Adjust settings and share
Set the form to collect email addresses if needed, enable quiz mode for graded responses, and click "Send" to distribute the link.
Downside: For sheets with more than ten questions, this gets tedious and error-prone. One of the automated methods below is a better choice.
Method 2: Apps Script (automated, no third-party tool)
Google Apps Script lets you write a short JavaScript function that reads your sheet and builds a form automatically.
Step 1: Prepare your sheet
Put question text in column A. If you have multiple-choice options, put them in columns B, C, D, and so on - one option per column in the same row as its question.
Step 2: Open Apps Script
In Google Sheets, click Extensions, then Apps Script. This opens the script editor.
Step 3: Paste and run the script
Replace any existing code with the following:
jsfunction createFormFromSheet() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = sheet.getDataRange().getValues();
var form = FormApp.create('Form from ' + sheet.getName());
data.forEach(function(row) {
var question = row[0];
if (!question) return;
var options = row.slice(1).filter(Boolean);
if (options.length > 0) {
var item = form.addMultipleChoiceItem();
item.setTitle(question);
item.setChoiceValues(options);
} else {
form.addTextItem().setTitle(question);
}
});
Logger.log('Form URL: ' + form.getEditUrl());
}
Click the save icon, then click Run. Authorize the script when prompted. The form URL appears in the Logs panel.
Step 4: Review the generated form
Open the URL from the logs. Check that question types are correct and adjust any items that need a different type (e.g., paragraph instead of short answer).
Downside: You need to grant the script access to your Google account, and the script only creates basic question types. Quiz answer keys, section logic, and descriptions require extra code.
Method 3: Formswrite (fastest, no code)
Formswrite converts documents - Google Docs, Word files, PDFs, plain text - into a Google Form in one click. The fastest workflow for Google Sheets content is a two-step handoff: copy your sheet content into a Google Doc, then convert.
Step 1: Copy your sheet content into a Google Doc
Select your questions (and answer options) in the sheet, paste them into a new Google Doc. Format each question on its own line with options listed underneath - numbered or bulleted both work. This takes about 30 seconds for a typical survey.
Step 2: Share the Doc so Formswrite can read it
In the Doc, click Share and set access to "Anyone with the link can view." Copy the link.
Step 3: Open Formswrite and paste the link
Go to formswrite.com and paste your Doc link into the input field.
Step 4: Click Convert
Formswrite reads the document, detects question types, and builds a complete Google Form. Multiple choice, checkboxes, short answer, paragraph, and quiz answer keys all carry over automatically.
Step 5: Review and publish
You get a standard Google Form you can preview, edit, and style. When it looks right, copy the form link and share it to start collecting responses.
Advantage over manual: No retyping, no errors on large question sets. Formswrite also exports the same questions to 40+ other platforms - Moodle, Canvas, Kahoot, Quizizz, and more - if you ever need to reuse the content elsewhere.
Which method should you use?
- 5 questions or fewer: manual copy-paste is fine.
- You are comfortable with JavaScript and want no third-party tool: use Apps Script.
- You have a long sheet, want no code, or need quiz answer keys: use Formswrite. There is a free plan to try it.
Can I link a Google Form back to an existing Google Sheet?
Yes - this is a separate operation (and a common point of confusion). After your form exists, open it in Google Forms, click Responses at the top, then click the Sheets icon to link the form to any Google Sheet. Every new submission will add a row automatically.
This is different from converting a sheet into a form. Linking syncs responses; converting builds the form structure from your data.
For a full walkthrough of working with documents and forms, see the Google Doc to Google Form guide or the PDF to Google Form guide.
FAQ: Google Sheets to Google Form
Can I convert Google Sheets directly into a Google Form?
Google does not have a built-in convert button. Your options are: copy questions by hand, run an Apps Script that builds the form from your sheet headers, or copy the sheet content into a Google Doc and use Formswrite to convert it in one click.
Is there a free way to convert Google Sheets to Google Forms?
Yes. The manual copy-paste method is free and requires no tools. The Apps Script method is also free. Formswrite has a free plan that lets you try the conversion at no cost.
How do I use Apps Script to create a Google Form from a sheet?
In Google Sheets, click Extensions, then Apps Script. Write a script that reads your sheet rows and calls FormApp.create() to build the form. Run the function and authorize it. The form URL appears in the script logs. This requires basic JavaScript knowledge.
What is the difference between linking a Google Form to Sheets and converting Sheets to a Form?
Linking connects a form's response output to a spreadsheet so each submission adds a row. Converting goes the other direction - it reads the questions already in your sheet and builds the form structure. These are two separate operations.
Do I need to install a plugin or extension to convert Google Sheets to a Google Form?
No. Formswrite is a website, not a browser extension or Google Workspace add-on. You do not install anything. Just visit formswrite.com, paste your document link, and click Convert.
Can I include quiz answer keys when converting from Google Sheets?
Yes. If you mark correct answers in your source document before converting with Formswrite, it carries the answer key into the Google Form so the quiz grades automatically.
Does the converted form support multiple choice, checkboxes, and short answer questions?
Yes. Formswrite detects question types from the structure of your document - lists become multiple choice or checkbox questions, and standalone lines become short answer or paragraph questions. You can adjust any type after conversion.
Can I reuse my Google Sheets questions on other quiz platforms?
Yes. Formswrite can export the same question set to Moodle, Canvas, Kahoot, Quizizz, Blooket, Gimkit, and 40+ other platforms. Export to most third-party platforms requires a paid plan.
Turn your spreadsheet into a form
Convert an Excel sheet or Google Sheet of questions into a Google Form.
Convert a spreadsheet →Or go straight to a converter: Google Docs to Forms, PDF to Google Form, Word to Google Form, Google Forms Quiz Generator