Import & Export

Export a table (or query result)

1. Open the table (or run the query).
2. Choose Export and pick a format:
   • CSV — for spreadsheets and other tools
   • JSON — for scripts and APIs
   • SQL — INSERT statements you can replay elsewhere
   • XLSX — a real Excel file
3. Pick where to save.

Exports stream: rows are written page by page, so exporting a million-row table won't eat your RAM. Values are never mangled — and cells that could be interpreted as spreadsheet formulas are quoted safely in CSV, so a malicious =CMD(...) value in your data can't execute in Excel.

Import a CSV

The import wizard walks you through it:

1. Right-click a table → Import CSV and pick the file.
2. The wizard sniffs the format — delimiter (comma/semicolon/tab) and whether row 1 is a header — and shows a preview. Adjust if it guessed wrong.
3. Map columns: each CSV column → a table column. Skip the ones you don't want.
4. Values are coerced to the column types (text "42" into an integer column, etc.).
5. Confirm. The import runs through the same staged-commit path as manual edits — you'll see what's about to happen before it happens, and safe mode applies.