Split a CSV file into individual files based on a column value
Separate a CSV file into multiple files based on the value of a specific column
SplitCSV.com is the easiest way to split a large CSV file (with a file extension of .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) because it uses too much memory or hits the row/column limit.
- Has multiple rows you want to separate out into individual files based on the value of a specific column.
You can often break it apart into smaller files and then load each file individually. smaller files. Here is the easiest way to split a CSV file based on the value of a specific column:
- Go to https://www.splitcsv.com/
![SplitCSV.com](https://content.services.victoriaperfortunam.com/assets/6b657862-fbbb-4e0f-8d0c-b644f1cafc2b?width=624)
- 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.
![2](https://content.services.victoriaperfortunam.com/assets/a02f5215-f817-4550-8de6-a81d0a62d228?width=624)
- Once the Split Options page loads, click on the Value tab.
![Split by Value selection](https://content.services.victoriaperfortunam.com/assets/cb387116-98b5-45c0-afbf-55f443edc47f?width=624)
- Select the column to be used for the split.
![Selecting the column to control the split](https://content.services.victoriaperfortunam.com/assets/7dda7045-8fcf-453e-bd54-f0f994fdccf5?width=624)
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 zip files.
![Download your split output](https://content.services.victoriaperfortunam.com/assets/143bed44-1ca6-4d1b-85b3-b2777929ad72?width=624)
Happy splitting!