How to use CSV Splitter
- Choose the CSV or TSV file to split. It is read in your browser.
- Pick Row count and set how many rows each file holds, or pick Distinct column value and name the column to divide on.
- Leave the header row option on when the first line names the columns, and set the delimiter if automatic detection chooses the wrong one.
- Press Split CSV, check the row count listed for each part, then download the ZIP or the single part.
Example: CSV Splitter
Cut a four-row order file into two files of two rows each.
Options
- Row count
- The table is cut into chunks of the size you set, with the last chunk holding whatever is left. Four thousand two hundred rows at one thousand rows each produce five files.
- Distinct column value
- One file is written for each different value in the chosen column, and a value keeps the order it first appeared in. The column is named by its heading or by its 1-based position.
- Delimiter
- Automatic detection suits a well-formed file. Set the delimiter yourself when a quoted cell confuses detection, which usually shows up as one very wide column.
- Protect spreadsheet formulas
- A cell that begins with =, +, - or @ receives an apostrophe in every part, so a spreadsheet reads it as text rather than running it.
Supported inputs and limits
Where your input is processed
This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.
What every part keeps
Each file is written with the same separator and, when the option is on, the same header row, so a part opens like the file it came from. Cell text is never converted into a number, so an identifier such as 0012 keeps its leading zeroes. The formula prefix is the only deliberate change to a value, and the report counts the cells it touched.
Questions about CSV Splitter
How many files will I get?
A row count split gives one file per chunk and one more file for the remainder, so 4,200 rows at 1,000 rows each produce five files. A distinct column value split gives one file for each different value in that column.
Why did a value end up in a file named orders-eu-x.csv?
A slash, a backslash, a control character, two dots in a row or a device name cannot go into a file name, so the value is reduced to a plain slug. Every name that changed is listed with the row counts.
Is my CSV uploaded anywhere?
No. The file is read in your browser, each part is written there, and the download is created from that data on your device.
Why did a value such as -5 gain an apostrophe?
Formula protection is on by default and a cell whose first visible character is one of those looks like a formula to a spreadsheet, even when a space or a tab comes first. Turn the option off when a leading minus sign is ordinary data.