Split a CSV file into multiple files

How to split a large CSV file into multiple files

Split CSV is the easiest way to split a large CSV file into multiple files. If you have a CSV file that is too large to open in a specific program (like Excel or Google Sheets) you can often break it apart into smaller files and then load each file individually. This helps so you're less likely to hit the file size limit for Microsoft Excel or Google Sheets. Here is the easiest way to do it:

  1. Go to https://www.splitcsv.com  
  2. Click the Choose File button and select your CSV file. The file will begin uploading immediately. 
  3. Indicate whether or not there is a header section, and if so how many lines should be copied into each split file. 
  4. You can choose how to split the file: you can limit the number of rows in each file (by selecting the Rows tab and entering the maximum number of rows in each file), the size of each file (by selecting the Size tab and then entering the appropriate size in bytes) or specify the exact number of files to produce (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. Press the Confirm button to verify the 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!

The Fastest Way to split a CSV file into multiple files

If you're looking to split a text file (extension of .txt) you've come to the right place. Check out our guide to splitting a large Txt file here.