CSV Splitter
Choose how to split: a set number of rows in each file, a set number of files, or one file for each value in a column such as region or department. Download them one by one or all together in a zip file.
Drag a file here or choose one
Worked examples
Split 10 rows into 3 files
10 data rows, Number of files = 3
Three files with 4, 3 and 3 rows
The first file takes the extra row. Each file has the header.
Split by region
Region,Sales North,120 South,80 North,95
File North: 2 rows. File South: 1 row.
One file for each different value in the Region column.
About CSV Splitter
A file that is too big to open, too long to import or too sensitive to send to everyone needs cutting up. This splitter makes smaller files three ways. By rows gives files of a fixed length, such as 1,000 rows each. By number of files shares the rows out as evenly as possible, so a list of 103 rows split into 4 files has 26, 26, 26 and 25 rows. By column makes one file for each different value, so a sales list becomes one file for each region.
The header row is repeated at the top of every file, so each can be opened and imported on its own. File names are built from the name of your file and the number or value, with characters that file names cannot hold replaced. You can download any one file or all of them together in a zip file. The most that is made at one time is 500 files.
How to use CSV Splitter
- Paste your CSV or open a file.
- Choose how to split: rows in each file, number of files or the values in a column.
- Enter the number, or choose the column.
- Download the files one at a time, or press Download all as a zip file.
Common uses
- Cutting a huge export into pieces a spreadsheet can open
- Sending each region or department only its own rows
- Staying within an import limit of a set number of rows
- Sharing a list between several people
Frequently asked questions
Is the header repeated in every file?
Yes, if the first row of your file is a header. Every part starts with the same header row so it can be used on its own.
How are rows shared out when they do not divide evenly?
When you ask for a number of files, the first files get one extra row each until the remainder is used up. Splitting 10 rows into 3 files gives 4, 3 and 3.
What are the files called?
Your file name, a dash and either a number or the column value, for example sales-North.csv. Characters such as slashes and colons are replaced with underscores, and repeated names get a number added.
Are capital letters in the column treated as different values?
Yes, unless you tick the box to ignore them. With it ticked, North and north go to the same file.
What is the limit?
The tool makes up to 500 files at once. If your choice would make more, you are asked to use a larger number of rows in each file or a different column.