Import & Export
Export
Export a query result or a table's loaded rows from the Export ▾ menu in the results/browse footer.
| Format | Notes |
|---|---|
| CSV | RFC-escaped; available on all editions |
| JSON | Array of objects; NULL → null — Pro |
| SQL | INSERT statements — Pro |
| XLSX | Excel workbook (numbers typed) — Pro |
Files are written to your Downloads folder with a timestamped name; the path is shown in the status bar.
!!! note "Free edition" Free exports CSV only. Pro/Premium unlock JSON, SQL and XLSX.
Import (CSV)
In a table's browse view, click Import CSV (Pro) and pick a file. The client:
- Reads the file locally (nothing is uploaded).
- Matches CSV header columns to the table's columns (case-insensitive).
- Inserts matched columns in batches within a single transaction.
- Reports the number of rows inserted and any ignored columns.
Empty cells are inserted as NULL. The CSV must have a header row.
!!! tip
Column matching is by name — reorder or rename CSV headers to control the
mapping. Unmatched CSV columns are ignored; table columns not present in the
CSV take their default/NULL.