Exporting Data

Export query results to CSV, JSON, Parquet, or clipboard.

Export Formats

dbxlite supports exporting to:

  • CSV - Universal spreadsheet format
  • JSON - For web applications and APIs
  • Parquet - Efficient columnar format for analytics
  • Clipboard - Paste directly into other applications

Using the Export Button

After running a query, click the export button in the results panel toolbar. Select your desired format and the file will download automatically.

Exporting via SQL

You can also use DuckDB's COPY command to export data:

-- Export to CSV
COPY (SELECT * FROM my_table) TO 'export.csv' (HEADER, DELIMITER ',');

-- Export to Parquet
COPY (SELECT * FROM my_table) TO 'export.parquet' (FORMAT PARQUET);

-- Export to JSON
COPY (SELECT * FROM my_table) TO 'export.json' (FORMAT JSON);

Copy to Clipboard

Select rows in the results grid and use Ctrl/Cmd+C to copy them to your clipboard. Data is copied in a tab-separated format that pastes nicely into spreadsheets.

Large Exports

For large datasets, Parquet is recommended as it compresses efficiently and maintains type information. CSV exports may be slow for millions of rows.