Creating the syntax for new SQL tables can be a pain especially for CSV files with a lot of columns. I’ve started using DB Browser for SQLite because I prefer GUI interfaces over the command line. A big benefit of using DB Browser is that I can quickly create tables from CSV files and start analyzing my data in minutes.
Step 1: Create and Save a New Database
Click on the New Database button and choose a location to save your database
Step 2: Import CSV File
In the top navigation bar, you can click on File > Import > Table from CSV file…
And that’s it!
If you have multiple CSV files you want to append to the same table, check out this post: Easily Append Rows to a Table from Multiple CSV files using DB Browser for SQLite