How to Export SQL Query Results to CSV

Why Export SQL to CSV?

CSV is the lowest-friction hand-off from a database to analysts, spreadsheets, and other systems. Almost every BI tool, Excel, and ETL pipeline can ingest it. Exporting a query—not an entire dump—keeps files focused and shareable.

Pick an Export Path

Server-side exports are fastest. Client tools are easier when you lack filesystem permissions.

Step-by-Step: PostgreSQL

COPY TO is the standard high-speed export.

COPY (
  SELECT order_id, email, amount, created_at
  FROM orders
  WHERE created_at >= DATE '2026-01-01'
) TO '/tmp/orders_2026.csv'
WITH (FORMAT csv, HEADER true, ENCODING 'UTF8');

\copy (SELECT order_id, email, amount FROM orders) TO 'orders.csv' WITH (FORMAT csv, HEADER true)

Step-by-Step: MySQL

INTO OUTFILE writes on the server. Client-side export avoids FILE privilege issues.

SELECT order_id, email, amount
INTO OUTFILE '/var/lib/mysql-files/orders.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM orders;

mysql -u user -p -B -e "SELECT order_id, email, amount FROM app.orders" \
  | sed 's/\t/,/g' > orders.csv

Step-by-Step: SQL Server and SQLite

GUI and CLI paths cover most day-to-day needs.

sqlite3 -header -csv my.db "SELECT * FROM orders;" > orders.csv

Make the CSV Excel-Safe

Database exports often open wrong in Excel without a little care.

• Use UTF-8; add a BOM only if Excel on Windows requires it for your locale.
• Quote fields that contain commas, quotes, or newlines.
• Export dates as ISO 8601 (YYYY-MM-DD).
• Keep long IDs as text to avoid scientific notation.
• Include a header row with stable column names.

Real-World Examples

Common export jobs.

Common Mistakes

These corrupt trust in the file.

• Forgetting HEADER so the first data row becomes column names in Excel.
• Tab-separated dumps saved as .csv without changing the delimiter story.
• Exporting NULL as the string "NULL" inconsistently.
• Shipping unrestricted SELECT * with PII.
• Opening UTF-8 CSV in Excel via double-click and breaking characters.

Best Practices

Treat exports like an API contract.

• Export explicit column lists, not SELECT *.
• Document delimiter, encoding, and null representation.
• Filter in SQL; do not dump then delete rows by hand.
• Verify row counts against COUNT(*).
• For Excel delivery, convert CSV to XLSX when formatting matters.

Why Use Convert CSV Online?

After the database spit out CSV, Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Preview and clean in the Online CSV Editor, convert to Excel or JSON, or generate INSERT scripts with CSV to SQL for a target database. Client-side workflows work on Windows, macOS, and Linux browsers.

Conclusion

Exporting SQL to CSV is a solved problem on every major engine—use COPY, OUTFILE, or client tools, then verify encoding and headers before you hand the file to Excel or another database.