Product tutorial

How to use Sheet2Forms

Follow this workflow to turn spreadsheet rows into public Google Form submissions without sign-in while keeping control over mapping, dry runs, progress, and errors.

Excel file preparation screen placeholder
1

Prepare your spreadsheet

Use a .xlsx, .xls, or .csv file. Make sure the first sheet has a clear header row, no blank columns inside the table, and one data row per submission.

Sheet2Forms Excel import screen placeholder
2

Open Sheet2Forms

Start the app and click Select Excel File. The app reads the first sheet, detects the columns, and shows a preview of the first 5 rows.

Google Form URL input screen placeholder
3

Paste the Google Form link

Paste a Google Form URL from docs.google.com/forms or forms.gle, then continue to question mapping.

Column mapping screen placeholder
4

Map columns to questions

Click Auto-map Columns to read the form questions and match them to Excel columns, or use Add Mapping manually. Supported types: short answer, paragraph, radio, checkbox, dropdown, date, and time.

Dry run settings screen placeholder
5

Configure and dry run

Set the delay between submissions, start row, max rows, browser visibility, stop on first error, and screenshot on failure. Run Dry Run 1 Row first to confirm the mapping.

Progress and logs screen placeholder
6

Run and monitor progress

Click Run All to process the selected rows. Watch total, current row, success, failed, and logs; use Cancel when you need to stop, then resume with Start from row. Export Logs to keep the run result.

Before you run automation

Ready to stop copy-pasting rows into Google Forms?

Use Sheet2Forms for repetitive admin workflows where the data already lives in a spreadsheet.

Only submit forms you own or are explicitly allowed to fill.
For radio, checkbox, and dropdown fields, make spreadsheet values match the form options. For checkboxes, separate multiple options with commas.
Make sure Google Chrome or Microsoft Edge is installed. Dates can use formats like 01/07/2026 or 2026-07-01; times can use 08:30, 08.30, 0830, or 08h30.
/-en/-id/tutorial-en/tutorial-id/account-en/account-id