हिं हिन्दी

    Split a CSV file

    Split a large CSV into smaller files of N rows each.

    or drop a CSV file here

    Files never leave your device

    About this tool

    This tool splits one large CSV file into smaller CSV files with the number of rows you choose, and gives you all the parts in one ZIP. The header row is repeated at the top of every part, and rows that contain line breaks inside quotes are never cut in half. The file is streamed in pieces on your device, so CSVs of hundreds of MB can be split without uploading them.

    At a glance

    What it does
    Split a large CSV into smaller files of N rows each.
    Price
    Free, no sign-up
    Works in
    Your browser, on phone or computer. Works offline after the first visit.
    Privacy
    Files are processed on your device and never uploaded.

    How to split a CSV file

    1. Click "Select a CSV file" and choose your file.
    2. Enter the rows per file and keep "repeat it at the top of every part" ticked.
    3. Click "Split CSV" and download the ZIP of parts.

    Private

    Your files are processed in your browser and never uploaded.

    Fast

    No upload or queue. Results are ready in seconds.

    Free

    No sign-up, no limits and no watermark on your files.

    Frequently asked questions

    How many files will I get?

    The number of data rows divided by rows per file, rounded up. For example, 25,500 rows split at 10,000 rows per file gives 3 files: two of 10,000 rows and one of 5,500 rows.

    Does every part keep the header row?

    Yes, when "First row is a header" is ticked. The header is not counted in the rows per file, so each part has the header plus up to that many data rows.

    Why split a CSV at all?

    Many systems limit uploads, for example an import that accepts at most 5,000 rows or 10 MB per file. Excel also stops at 1,048,576 rows per sheet. Splitting makes each part small enough to import or open.

    What are the parts called?

    They are named after your file with a zero-padded number, such as sales-part-001.csv, sales-part-002.csv, so they stay in order when sorted by name.

    Are my files uploaded to a server?

    No. This tool runs entirely inside your browser, so your files never leave your device. Nothing is stored or seen by us.