Convert a CSV file to a MySQL Database Table

Instantly 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/ Screen Shot 2022 05 10 at 10.32.12 Pm
  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. Screen Shot 2022 05 10 at 10.32.12 Pm
  3. Once the Split Options page loads, click on the SQLite Database tab.Screen Shot 2022 05 10 at 10.32.59 Pm

 

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.

SQLite database download

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

 

Happy splitting!