We often use Excel in data processing domain, and today I will share with you an Excel cheat sheet.
Tag Archives: excel
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 “;”.