XLSX → SQL Scribe

Generate SQL CREATE an' INSERT statements.

Drop or select an Excel scroll (.xlsx, .xls, .xlsb, etc.) t' convert t' SQLMax 5 MB per scroll

How it works

Quickly seed a database from spreadsheet data. Generate ready-t'-run SQL scripts fer MySQL, PostgreSQL, SQLite, or any SQL-compatible database.

What SQL types arr inferred?

Th' tool detects BOOLEAN, INTEGER, REAL, DATE, an' TEXT based on cell values.

Can I add a table name prefix?

Aye. Ye can set an optional prefix that be prepended t' each table name.

Which databases arr compatible?

Th' generated SQL uses standard syntax compatible with MySQL, PostgreSQL, SQLite, an' most SQL databases.

Parse INSERT statements from a SQL scroll into an XLSX workbook.

Export one or more sheets as CSV scrolls.

Export sheet data t' JSON fer APIs an' workflows.