- SQLite Introduction
- From CSV to SQLite
- From SQLite to CSV
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.
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…,
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