From SQLite to CSV


This entry is part 4 of 4 in the series SQLite

If you have a SQLite database and you have installed DB Browser, you can view and export your tables to a CSV (comma-separated-values) text file. Once you have that text file it is very easy to get that into Excel. We have a small post here called From CSV to Excel. Below is a screenshot of the DB Browser showing the table of planets. That table of planets was built from the CSV file that was imported as described in the post called From CSV to SQLite.

Click to Enlarge SQLite to CSV

I had clicked on the Browse Data tab.

How do I export the data to a CSV file? File, Export, Table(s) as CSV File…,

Export SQLite to CSV Click to Enlarge

There are some options to choose from here. After clicking Save you get the dialog box asking you for a file name and a location. Supply those. If you open the CSV file in a text editor, like Notepad++, you get what you expect, as shown below.

ind,planet,type,radius_km,moons,distance_AU
0,Mercury,rock,2440,0,0.39
1,Venus,rock,6052,0,0.72
2,Earth,rock,6371,1,1
3,Mars,rock,3390,2,1.52
4,Jupiter,gas,69911,80,5.2
5,Saturn,gas,58232,83,9.54
6,Uranus,ice,25362,27,19.8
7,Neptune,ice,24622,14,30.06
Series Navigation<< From CSV to SQLite

Leave a Reply