Import / Export

Load a CSV, JSON, Excel, or SQLly Export file into a table - or export out - through a script-first wizard.

A guided wizard for moving tabular data in and out of a table. Import from a CSV (or any delimited file), JSON, Excel workbook (.xlsx/.xls), a .sqllyexport file, or straight from the clipboard - or export a table out. Like every write path, it is script-first: the load is prepared for you to review before it runs.

• Parse options - delimiter chips (comma, semicolon, tab, pipe), a header-row checkbox, a sheet picker for workbooks, and automatic text-encoding detection with an honest report of anything it had to replace.
• Mapping and types - rename or skip columns in order, set a null token, and override per-column types; otherwise SQLly infers types by sampling up to a thousand values per column and picking the most specific one they all accept.
• Create or target - load into an existing table, or tick Create new table and review the proposed columns, typed in the target engine's own DDL (NVARCHAR vs TEXT vs VARCHAR, UNIQUEIDENTIFIER vs UUID, and so on).
• Live preview - the first fifty mapped rows render in the real result grid, and rows that would fail their column type are counted and excluded with a visible note rather than silently dropped.

Script Import to Editor emits batched INSERT statements (or, on SQL Server against an existing table, an optional BULK INSERT), and Script Export SELECT writes the query whose results you then save as CSV, JSON, or XLSX.

SQLly