SQLite - How to export query results or a table to a CSV file?

To export SQLite data to a csv file:

Using sqlite3 command-line tool

Run this command:

sqlite> .mode csv
sqlite> .output file_name.csv
sqlite> select * from table_name;
sqlite> .output stdout

You probably need to export the header of the results too, so don’t forget to turn on the header before exporting:

sqlite> .headers on

Using TablePlus GUI tool

You can also export an entire SQLite table or a set of query results from its table view:

To export the whole table:

• Right click on the table name from the right sidebar
• Choose Export…

To export a set of query results:

• Execute the query
• Right click on the result and choose export results, or click on the export button at the bottom right

---

New to TablePlus? It’s a GUI client for multiple relational databases. It’s native, beautiful, and available for free.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS.