Convert from SQLite to CSV

It’s very simple:

sqlite> .mode list
sqlite> .separator ,
sqlite> .output exported_file.csv
sqlite> select * from yourtable;
sqlite> .exit

You can use other separator. For Microsoft Excel default separator is “;”.