DataMimiDataMimi

Split Excel or CSV File

One big file into several: every N rows, one file per sheet, or one file per branch, month or person.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Split Excel or CSV File

  1. 1Select your file, or drop it on the page
  2. 2Choose how, then run it
  3. 3Download split.zip

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

How do I split an Excel file into multiple files?

Upload the file, choose how to split it — every N rows, one file per sheet, or one file per value of a column — and download a zip with the parts.

Can I split by a column, such as one file per branch or salesperson?

Yes. Type the column's name or its letter. Each different value gets its own file, named after the value, with every matching row.

Is the header row kept in every file?

Yes. Every part starts with the same header row, so each file opens and works on its own.

Does it work with CSV files?

Yes. A CSV gives CSV parts saved as UTF-8 that Excel opens with accents intact; a workbook gives Excel parts.

More Excel tools

See all