Split CSV File

Cut a Large CSV into Smaller Files.

Loading…

Excel stops at 1,048,576 rows. Mail-merge and import tools often cap uploads at 1,000 or 10,000 records. A CSV that's too big for the tool you need has to be cut into pieces.

Choose the rows per file. Every piece gets the header row, so each one is a valid CSV by itself. The pieces are numbered and delivered in one ZIP.

How to use the Split CSV File tool

  1. Choose your CSV file.
  2. Set the number of rows per file.
  3. Download the ZIP with the parts.
  • Getting under the record limit of an import tool
  • Opening a huge export in Excel in sections
  • Sending a contact list to a bulk-email service in batches

Tips for the best result

  • The tool tells you how many files you will get before you download.
  • Rows that contain line breaks inside quotes are kept whole.

Quick facts

PriceFree
Works withCSV → ZIP
Where it runsIn your browser, on your device
AccountNot needed

Frequently asked questions

How large a file can it split?

Files of a few hundred megabytes work on a computer with enough memory. On a phone, stay under about 50 MB.

Can I split by a column value, such as one file per country?

No. It splits by row count.

Is the header repeated?

Yes, unless you untick the option.

How are the files named?

With the original name and a number: data-01.csv, data-02.csv and so on.