How to use CSV Splitter
- Choose one CSV, TSV or XLSX file. For a workbook, select its worksheet by name or number.
- Choose Row count, Target file size or Distinct column value. Enter the rows per part, CSV size target or column heading/position for that mode.
- Check the delimiter and header setting, then select CSV or XLSX parts. XLSX parts require a header row; size mode still budgets serialized CSV lines.
- Split the table and review each part's row count and filename. Download the ZIP or single part, then inspect the result before using it elsewhere.
Example: CSV Splitter
Cut a four-row order file into two files of two rows each.
Options
- Worksheet name or number
- Choose the worksheet used for file splitting. An empty choice uses the first visible sheet; otherwise enter its name or 1-based position.
- Split by
- Row count cuts the table into fixed chunks, target file size packs rows until a part reaches a chosen size, and distinct column value gives every value in one column its own file.
- Target size in MB
- Used by the target file size split. Rows are packed until the next one would push a part past this size; the size is measured from the written lines, not guessed.
- Rows in each file
- Used by the row count split. A value of 1000 turns 4,200 rows into five files holding 1000, 1000, 1000, 1000 and 200 rows.
- Column for the value split
- The heading of the column, or its 1-based position such as 2. Used by the distinct column value split only.
- The first row holds the column names
- For file splitting, enable this when the first record names the columns. Without headings, refer to columns by their 1-based positions.
- Delimiter
- For file splitting, choose the separator between source text cells. An automatic choice, when offered, must still be checked against quoted and multiline values.
- Protect spreadsheet formulas
- The file splitting CSV export can prefix formula-like source text, including after leading whitespace. This changes stored text. An XLSX export, when offered, uses inert text cells without the CSV prefix.
- Part format
- XLSX parts need a header row and store every cell as text, so a part that begins with = does not run as a formula.
Supported inputs and limits
- One CSV/TSV/XLSX file up to 20 MiB, 500 columns, 200,000 data rows and 2,000,000 cells.
- Up to 200 parts.
- Size mode measures serialized CSV lines, not compressed ZIP or XLSX size; workbook sizes can differ.
- XLSX parts need a header row and keep every cell as inert text.
- CSV protection prefixes risky cells.
More details
Parts repeat headers when selected; safe filename collisions receive distinct names.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
What every part keeps
Parts use the selected separator and repeat the header when that option is enabled. Splitting does not coerce source values into numbers. Formula protection can add prefixes to exported CSV cells, and the report counts those changes. An application opening CSV may still infer cell types, so import identifier columns as text when leading zeroes matter. XLSX parts store their cells as text.
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?
This tool replaces unsupported filename characters and unsafe name patterns with a plain slug. Slashes, control characters, repeated-dot patterns and reserved device names can therefore change a value-based filename. The report lists changed names alongside their 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?
CSV protection prefixes text whose first visible character is =, +, - or @, including after leading whitespace. A negative number can therefore receive an apostrophe even when you intended ordinary data. Review the destination's import behavior before disabling the guard.
Does file splitting change formula-like text in Excel output?
The file splitting XLSX download stores each value as inert text, preserving a leading equals or minus sign. CSV formula protection can instead add a prefix. Neither format recalculates saved workbook formulas.