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:
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: