Exports — destinations, formats and options

Exports — destinations, formats and optionsPaths and parameters, multi-sheet workbooks, scheduling, size limits and every export option. Open Export from the Export ribbon tab. Sources: the active grid table, the current query result, a selected/specified cell range (e.g. C1R1:C5R20, with optional "first row as header"), or a table read from a connection. Destinations: Excel (.xlsx) as a browser download; a FLAT FILE written to a drive path (CSV, TXT, or XLSX — the destination used by scheduled exports); a DATA-FORMAT file — JSON, NDJSON (one object per line) or Parquet (columnar, typed and compressed) — written to a drive path or a cloud storage connection; or a database table in DuckDB (local), PostgreSQL, BigQuery or Oracle (overwrite or append).

What this page covers

Export destinations & formats
Paths, file names & parameters
Multi-sheet Excel workbooks (multiple objects)
Scheduling & editing exports
File size limits (Settings → Export)
PDF reports — data story and AI explanation boxes

Settings and controls documented

Sheet to export
SQL
Range
Key columns
Column types
Rows per statement
Attempts
Before the export
After the export
Sheet
Start cell
File connection
File name
Destination
Folder (drive path)
Date & time format
Time zone
Empty cells
NaN / Infinity
Round to decimals
Partition by columns
Max rows per file
If the file exists
Checksum sidecar
Document shape
Indent (spaces)
Rows property name
Compression
Level
Row group size
Format version
Column type overrides
Delimiter
Encoding
Line endings
Restore default limits
Save target values
Save with functions (re-evaluated on load)

Full page

The full page — procedures and the explanation of every setting — is available to signed-in users.

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.