Split a Large CSV or Excel File

Break a big file into smaller ones every N rows, or into one file per value in a column (per region, per SKU, per month).

Your files are read in this browser tab and never uploaded.

Choose an Excel or CSV file
.xlsx, .xls or .csv
Output:
0
Files created
0
Data rows

    How to split a CSV file into smaller files

    1. Upload the .csv, .xlsx or .xls file you want to split.
    2. Choose Every N rows and enter a size (for example 1,000 for an import limit), or choose One file per value in a column and pick the column.
    3. Pick CSV or Excel output. Each file keeps the original header row.
    4. Click Split File, check the list of parts, then download them all in one ZIP.

    When people use this

    • Getting under an upload limit, such as a CRM, email tool or marketplace that accepts only a set number of rows per import.
    • Sending each region, store or salesperson only their own rows.
    • Opening a file that is too big to work with comfortably in Excel or Google Sheets.

    Frequently Asked Questions

    Yes. Every part starts with the original header row.

    Files of tens of megabytes usually work fine. Very large files (hundreds of MB) depend on your computer's memory, because the whole file is read into the browser.

    Yes. Choose "One file per value in a column", and each distinct value (for example each country) becomes its own file. Up to 1,000 distinct values are allowed.

    No. Splitting happens in your browser, and the ZIP is built on your device.

    More Excel & CSV Tools

    See all excel & csv tools →