Convert a CSV file to a MySQL Database Table

SplitCSV.com is not only the easiest way to split a large csv file, it is also the fastest and easiest way to convert a CSV file or Excel file (with a .xlsx extension) into a SQLite database file that can be queried using SQL. Here’s how:

 

1. Go to https://www.splitcsv.com/
2. Click the Choose File button and upload a CSV file or Excel file. Once the file is uploaded and processed, select the Split Options button to continue.
3. Once the Split Options page loads, click on the SQLite Database tab.

 

You can then select any other options and continue using all the existing Split CSV features, exactly the same as if you uploaded a CSV file or pasted in some content. Once the order is completed, you’ll be able to download the SQLite database file.

You can open the database file using your preferred database browser tools: preferences vary, but we’ve had success using:

• The SQLite3 command line shell (https://www.sqlite.org/cli.html)
• SQLiteViz in the browser (https://lana-k.github.io/sqliteviz/#/)

 

Happy splitting!