Turn a spreadsheet into SQL
Export a sheet as CSV, check the rows, and turn them into INSERT statements.
Step 1
Export the sheet as CSV
Save the spreadsheet as CSV first so the row and column boundaries are explicit. This also gives you a plain-text artifact you can inspect and version if needed.
Step 2
Optionally sanity-check the rows in a table
Open the CSV in CSV Viewer if you want a quick visual pass before generating SQL. It is a good way to catch broken delimiters, shifted columns, or obvious quoting issues from the export.
Review in CSV Viewer →Step 3
Profile the dataset for nulls and duplicates
Use Data Explorer when you need more than a quick glance. It helps surface sparse columns, duplicate-heavy fields, and suspicious distributions before those problems turn into bad inserts.
Profile in Data Explorer →Step 4
Generate INSERT statements
Paste the cleaned CSV into CSV to SQL and generate the INSERT statements for your target table. Review the output for column order and quoting, then run it in your database tooling.
Convert with CSV to SQL →