Split a CSV file into multiple files

How to split a CSV file

1. Choose the file, CSV or Excel. The number of rows and columns is shown.
2. Choose how to split:
   • Rows per file: for example, 5,000 rows per file for an import limit.
   • Number of files: for example, 4 equal parts for four people.
   • Value in a column: one file per country, region, salesperson, status and so on, named after the value.
3. Check the list of files and download them as a ZIP.

When you need it

• Import limits in customer databases (CRMs), e-mail tools, online stores and accounting apps that accept only a certain number of rows or megabytes per upload.
• Excel’s row limit of 1,048,576 rows: split a bigger export into parts that Excel can open.
• Sharing one region’s or one person’s rows without sending everyone the whole file.
• E-mail attachment limits on large exports.

Splitting by a column’s value: an example

Say orders.csv has a Region column. Choose Value in a column and pick Region:

This gives three files, each starting with the header row: orders - North.csv with orders 1001 and 1003 (capital letters are ignored), orders - South.csv with order 1002, and orders - (blank).csv with order 1004. Use it to give each region, salesperson or store only its own rows, or to split an export by a status or month column.

How the split works

The tool reads the file properly, so values in quotes that contain commas or line breaks stay in one piece. A row is never cut in half. Every part starts with the original header row and keeps the original column order. Rows are not sorted or changed. When splitting by a column’s value, values that differ only in capital letters go into the same file, and empty values go into a “(blank)” file.

The separator (comma, semicolon or tab) is detected automatically. The parts are saved as standard CSV files with commas (UTF-8), or as Excel workbooks.