Export Data

Export query results and table data as CSV, JSON, or NDJSON.

After running a query, you can export the results to a file on your computer with one click. 1DevTool supports three export formats: CSV, JSON, and NDJSON. Everything is saved locally — no data is uploaded anywhere.

Exporting Query Results

  1. Run any query in the query editor. The results appear in the grid below.
  2. In the results toolbar (the row of buttons above the grid), click the Export button. It shows a small download arrow icon.
  3. A dialog appears asking you to choose a format and a destination folder.
  4. Choose your format (see below), pick where to save the file, and click Export.

The file is saved immediately. 1DevTool opens the destination folder in Finder (Mac) or Explorer (Windows) so you can find it right away.

Export Formats

CSV — Comma-Separated Values Best for opening in spreadsheet apps like Excel, Google Sheets, or Numbers. The first row contains column headers. Each subsequent row is one record. Values with commas or line breaks are automatically quoted.

JSON — JavaScript Object Notation Exports results as a JSON array of objects. Each object in the array is one row, with column names as keys. Example:

json
[
  { "id": 1, "name": "Alice", "email": "[email protected]" },
  { "id": 2, "name": "Bob", "email": "[email protected]" }
]

Best for importing data into another application or for use in scripts.

NDJSON — Newline-Delimited JSON Similar to JSON, but each row is written as a separate JSON object on its own line, with no surrounding array. Example:

{"id":1,"name":"Alice","email":"[email protected]"} {"id":2,"name":"Bob","email":"[email protected]"}

Best for large datasets because the file is written and read line by line without loading the entire thing into memory at once.

Tip: Use NDJSON format when exporting large datasets — it streams line by line and works with tools like jq and BigQuery.

Exporting a Full Table Without Writing a Query

You do not need to write SELECT * FROM my_table just to export an entire table. Right-click the table name in the schema browser sidebar and choose "Export table" from the context menu. The same format dialog appears. Pick your format and destination, and 1DevTool exports every row in the table for you.

This works for any table size — 1DevTool streams the data out in batches rather than loading everything into memory at once, so large tables export reliably without running out of memory.