Convert a tab-separated table to SQL INSERTs
Prepare a reviewable seed script from a tab-separated inventory file.
- Read tab-delimited rows as a table
TSV to CSV
- Write INSERT statements for the destination table
CSV to SQL
Run both steps
What to check in the example
With the default stock table, the script inserts three records. Locate C21 and verify the column order before running anything in a database.
Download the source exampleWorking with your own file
This workflow only writes a script. Review the SQL dialect, identifiers, types and quoting in your target database.