SQLite: How do I save the result of a query as a CSV file?

sqlite csv
RayLoveless picture RayLoveless · May 20, 2011 · Viewed 121.1k times · Source

I'm new to SQLite. Is there a way I can export the results of a query into a CSV file?

Answer

gdw2 picture gdw2 · May 20, 2011

From here and d5e5's comment:

You'll have to switch the output to csv-mode and switch to file output.

sqlite> .mode csv
sqlite> .output test.csv
sqlite> select * from tbl1;
sqlite> .output stdout

Related questions

Importing a CSV file into a sqlite3 database table using Python

I have a CSV file and I want to bulk-import this file into my sqlite3 database using Python. the command is ".import .....". but it seems that it cannot work like this. Can anyone give me an example of how to …

Read More
Export from sqlite to csv using shell script

I'm making a shell script to export a sqlite query to a csv file, just like this: #!/bin/bash ./bin/sqlite3 ./sys/xserve_sqlite.db ".headers on" ./bin/sqlite3 ./sys/xserve_sqlite.db ".mode csv" ./bin/sqlite3 ./sys/xserve_sqlite.…

Read More
How to export sqlite to CSV in Python without being formatted as a list?

Here is what I currently have: conn = sqlite3.connect(dbfile) conn.text_factory = str ## my current (failed) attempt to resolve this cur = conn.cursor() data = cur.execute("SELECT * FROM mytable") f = open('output.csv', 'w') print >> f, "Column1, …

Read More