Excel to Google Forms
Convert Excel to Google Forms
Upload a .xlsx spreadsheet and Formswrite reads the structure - column headers, Q&A rows, data-validation dropdowns, and answer-key columns - then builds a ready-to-edit Google Form. No CSV conversion, no copy-paste, no add-on to install.
How it works?

Turn an Excel file into a Google Form in three steps. The spreadsheet structure does the heavy lifting - Formswrite reads it so you do not have to rebuild questions by hand.
Step 1
Upload your .xlsx file
Drop your Excel workbook directly into Formswrite. No export step - the .xlsx file uploads as-is and Formswrite detects whether your data is laid out as Q&A rows, column-header labels, or a quiz export.
Step 2
AI reads the spreadsheet structure
The converter scans column headers, row data, data-validation lists, and any answer-key column. Formula cells are evaluated to their current value. Merged cells are unwrapped so the section title becomes a form section header.
Step 3
Review and export to Google Forms
Check the extracted questions in the Formswrite preview, make any edits, then export to Google Forms as a live, editable form in your Drive. The free Formswrite form is always available without an export.
What survives an Excel to Google Form conversion
Excel and Google Forms are fundamentally different data models. Here is exactly which spreadsheet elements convert cleanly and which ones need a quick review after the conversion.
| Excel element | Result in Google Forms |
|---|---|
| .xlsx uploaded directly | No CSV conversion needed |
| Column headers as question labels | Detected and mapped automatically |
| Question rows with option columns | Multiple choice field with all options |
| Answer-key column | Correct answer pre-marked in form |
| Data-validation dropdown lists | Dropdown question type |
| Formula cells (=SUM, =IF, etc.) | Evaluated value used, formula ignored |
| Merged cells spanning columns | Section title extracted, cells unmerged for form |
| Charts and embedded images | Skipped - form fields only |
| Multi-sheet workbooks | First sheet converted; others available on request |
Before and after
How a three-row quiz sheet becomes live Google Form fields.
Row 1 (headers): Question | A | B | C | D | Answer
Row 2: What is 7 x 8? | 54 | 56 | 64 | 48 | B
Row 3: Water boils at ... | 90 C | 100 C | 110 C | 120 C | B
Row 4: Name three continents. | (blank) | (blank) | (blank) | (blank) | open
Q1 Multiple choice - 4 options, correct answer 56 pre-marked
Q2 Multiple choice - 4 options, correct answer 100 C pre-marked
Q3 Paragraph - open long-answer field
Every kind of Excel spreadsheet
Question-and-answer rows
A spreadsheet where each row is one question and adjacent columns hold the answer choices is the cleanest input. Formswrite reads the row structure and maps every option into a multiple-choice or checkbox field automatically.
Q&A rows- Row-per-question layout detected
- Answer options read from columns B-E
- Column headers used as field labels
- Question numbering preserved
- No retyping or copy-paste
Column-header-as-label sheets
In survey exports and data-collection templates, each column header is the question label and the rows below are responses. Formswrite detects this pattern and turns every header into a form field.
Header-as-label- Column headers become question text
- Data type inferred per column
- Text columns become short-answer fields
- Dropdown lists extracted from data validation
- Works with .xlsx directly - no CSV step
Structured quiz exports
Teachers often build quizzes in Excel with a question column, an answer-key column, and one column per option. Formswrite reads that structure and marks the correct answer when the answer-key column is present.
Quiz export- Answer-key column detected
- Correct answer pre-marked
- Multiple choice and checkbox types supported
- Point values read when present
- Multi-sheet workbooks handled
The most reliable input is a spreadsheet where the structure mirrors a form - one question per row, options in columns, a header row with labels. The further a sheet drifts from that model (dashboards, financial reports, pivot tables), the more manual review the result will need.
Frequently asked questions
How do I convert an Excel file to a Google Form?
Upload your .xlsx file to Formswrite. The AI reads the spreadsheet structure - column headers, Q&A rows, data-validation dropdowns, and any answer-key column - then builds a ready-to-edit form. Review the questions, then export to Google Forms in your Drive, or keep the free Formswrite form. There is no CSV conversion step and nothing to install.
Do I need to save the Excel file as CSV first?
No. Formswrite reads .xlsx files directly. You upload the workbook as-is, and the converter handles the file parsing internally. Saving to CSV first can strip data-validation lists and merged-cell context, so uploading the original .xlsx usually gives a cleaner result.
What happens to formula cells in my spreadsheet?
Formula cells are evaluated to their current calculated value, and that value is used in the form. The formula itself is not visible or transferable to Google Forms since forms do not execute spreadsheet logic. If a formula cell holds a question text or an option label, the displayed value is what appears in the form.
How does Formswrite handle merged cells?
Merged cells that span a row are typically section or group headers. Formswrite extracts the text from the merged region and uses it as a form section title. The individual cells beneath are then read as questions within that section. Complex merged regions are flagged for a quick review.
Is there a free way to convert Excel to a Google Form?
You can start for free. The native Formswrite form and the flashcard export are free, so you can upload your Excel file and see the extracted questions at no cost. Exporting the result to Google Forms is available on a paid plan.
Which spreadsheet layouts work best?
A question-per-row layout with options in adjacent columns converts most cleanly. Column-header-as-label sheets (one column per field, headers as labels) also work well. Quiz exports with a dedicated answer-key column are detected automatically. Charts, pivot tables, and heavily formatted dashboards are not form-like structures and will not convert meaningfully.
Related conversions
Simple, Transparent Pricing
Start for free. Upgrade anytime.
Yearly
✨ Save 70%
Payment will be processed in USD, EUR, SGD, BRL, JPY, or INR.
Free
Get started free with 5 forms
Free
No credit card required.
5 Formswrite Forms
AI Builder (Fred AI)
10 AI questions per month
Browse Question Bank
Best Value
Pro
Unlimited everything, no limits
$49.99
/yearCancel anytime.
Everything in Free, plus:
Unlimited conversions
All 25+ export formats
Unlimited AI questions
Unlimited AI Lesson Plans
Unlimited AI Rubrics
Unlimited AI Worksheets
Flashcards
Presentation Decks
AI Video Lessons
Audio Lessons
Comics
Podcasts
Formswrite Play (Gamify Quizzes)
YouTube Video to Quiz
Bulk convert
Priority support
Lifetime
Pay once, use forever
$149
one-timeOne-time payment. No recurring fees.
Everything in Pro
Flashcards
Presentation Decks
AI Video Lessons
Audio Lessons
Comics
Podcasts
Formswrite Play (Gamify Quizzes)
YouTube Video to Quiz
One-time payment
Lifetime access to all features
All future updates included
Priority support forever