DevOpsPadDownload

Export query results to CSV

Click Export CSV in the Results header to save the current result. DevOpsPad opens a save dialog with the file name devopspad-results.csv, writes the file, and confirms with “Results exported to CSV”.

The export contains every fetched row in the order the query returned them. Filter results… and column sorting do not affect it.

Export a result

  1. Run the query. Export CSV is disabled until there is a result.
  2. Click Export CSV.
  3. Choose a location and file name in the save dialog, then save.

File format

  • The first line is the column names.
  • Every field is wrapped in double quotes; quotes inside values are doubled.
  • Lines end with CRLF (\r\n).
  • NULL becomes an empty field.
  • Objects and arrays, such as MongoDB documents or Kubernetes objects, are written as JSON text.
  • The file is written with owner-only permissions (0600) on macOS and Linux.
"id","customer","total","created_at"
"1048","Olivia Rhye","249.00","2026-10-01T14:52:00Z"

Formula injection protection

A cell starting with =, +, -, @, a tab or a carriage return can be interpreted as a formula when the CSV is opened in a spreadsheet. DevOpsPad prefixes those values with an apostrophe ('), so =HYPERLINK(...) arrives as text. Negative numbers such as -5 are prefixed too; remove the apostrophe in your spreadsheet if you need them as numbers.

Limits

  • At most the rows the query fetched: 500 rows or documents, and no more than the 8 MiB preview budget. See Why results stop at 500 rows.
  • The CSV itself is limited to 20 MB.
  • Exported data is no longer protected by DevOpsPad. Treat the file like any other copy of production data.

Frequently asked questions

Why does a value in my CSV start with an apostrophe?

Values beginning with =, +, -, @, a tab or a carriage return get a leading apostrophe so spreadsheet apps treat them as text instead of formulas.

How do I export more than 500 rows?

DevOpsPad exports what the query fetched, which is at most 500 rows. Split the export with WHERE or LIMIT and OFFSET ranges, or use the database's own export tools for large data sets.