CSV Splitter

Split CSV or Excel rows by count, size or value and download CSV or XLSX parts.

On-device No sign-up Free to use

Split CSV controls

  1. 1 Add files
  2. 2 Arrange/Options
  3. 3 Download

Drop your table file here

or choose one from your device

One UTF-8 CSV or TSV file, or one XLSX workbook up to 20 MB, 500 columns and 200,000 rows. The file is read in your browser.

    ?

    Only for a workbook. Leave empty to read the first visible worksheet, or name one, such as Sheet1, or give its 1-based number.

    ?

    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.

    ?

    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.

    ?

    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.

    ?

    The heading of the column, or its 1-based position such as 2. Used by the distinct column value split only.

    ?

    When this is on, every part repeats the header row. Turn it off when the first line is already data, and address the column by its number.

    ?

    Detection suits a well-formed file. Set the delimiter yourself when a quoted cell confuses it.

    ?

    CSV parts prefix formula-like values, including after leading whitespace. The prefix changes stored text; check the receiving spreadsheet's import behavior. XLSX parts store values as text without the CSV prefix.

    ?

    XLSX parts need a header row and store every cell as text, so a part that begins with = does not run as a formula.

    Result

    Showing an example.

    Cut a four-row order file into two files of two rows each.

    The page reports four rows in two files and lists orders-part-1.csv and orders-part-2.csv with two rows each, then downloads split-parts.zip. Both parts begin with the line region,name.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/csv-splitter · 20 November 2026

    Was this helpful?

    How to use CSV Splitter

    1. Choose one CSV, TSV or XLSX file. For a workbook, select its worksheet by name or number.
    2. 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.
    3. 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.
    4. 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.

    You add
    File: orders.csv holding the lines region,name / EU,Ana / US,Lee / EU,Bo / US,Kim. Split by: Row count. Rows in each file: 2. Header row: on. Delimiter: automatic.
    You get
    The page reports four rows in two files and lists orders-part-1.csv and orders-part-2.csv with two rows each, then downloads split-parts.zip. Both parts begin with the line region,name.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with CSV Splitter