Import CSV to SQLite


With DB Browser we can import a comma separated values (CSV) file into a SQLite database file. Using the DB Browser application we can choose File > Import > Table from CSV file. Be sure to be running as the Administrator to make the database editable.

We have another post here at this site called From CSV to SQLite, but it is more complicated because it goes through Python.

In DB Browser (running as administrator), with a database open, go to File > Import > Table from CSV file. Select your CSV file. I chose the file called names.csv. Next you will see this window, or something similar. I clicked the Advanced button.

Leave a Reply