← All text tools

CSV splitter

Split a big CSV into parts by number of rows or by the value of a column.

  • Free
  • No sign-up
  • Works on any device

About CSV splitter

Large CSVs can crash Excel, which stops at 1,048,576 rows, or exceed email and upload limits. Split a file into parts of a set number of rows, or into one file per value of a column such as country or month. Each part keeps the header row.

How to use CSV splitter

  1. Open your large CSV file.
  2. Choose to split by a number of rows or by a column value.
  3. Download the resulting parts.

Why use this tool?

Also known as

Frequently asked questions

How many rows can Excel open?

1,048,576 rows per sheet. Bigger CSV files lose the extra rows, so split them first.

Is the header repeated in each part?

Check one of the output files to confirm. If you need a header in every part, make sure the option is on, so each file opens cleanly by itself.

When should I split by column value?

Split by a column when you want one file per group, such as per country or department. Choose a column with a manageable number of different values.

Is CSV splitter free?

Yes. CSV splitter on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Related tools