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 “;”.
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 “;”.