How to open a large CSV file

A lot of the time when you're trying to work with a large CSV file, you run into excel's row limit. Excel's limit is 1,048,576 rows by 16,384 columns - this means that if a worksheet has more rows or columns than the limit, Excel will often not open, or it will crash. In addition, if you have an older computer or you have a lot of programs running on your machine, you might hit a memory or resource limit for files that are smaller than Excel's limit.

We made SplitCSV.com to solve this problem. Its the easiest way to split a CSV file into multiple smaller files that can be opened in Excel or Google Sheets. Here's how it works

1. Head over to https://www.splitcsv.com  
2. Click the Choose File button and select your CSV file to upload. The upload should begin immediately (see below):
3. Select if your file has a header, and how large it is (by rows). 
4. Choose how to split the file: by row count  (by selecting the Rows tab and entering the maximum number of rows in each file), by file size (by selecting the Size tab and then entering the appropriate size in bytes) or by number of output files  (by selecting the Files tab and then entering the number of files to output). The image below shows an example of limiting the file size.
5. Select Confirm to verify your selections choices, then press the Split button to queue the split up and view the receipt.
6. The split will be queued for completion, and should be executed shortly. The receipt page will refresh to include a link to the split results: all results will be zipped up for download.

All uploaded files will be kept for at most 7 days before being deleted: depending on volume it could be earlier.  At no time is the original source file downloadable, and the link to download the results will only be available on the receipt page, no where else.

Happy splitting! Please email team@splitcsv.com with questions, concerns, comments or suggestions.

Wondering how to open and split a large CSV file? Easy explainer video available here