Split an Excel file into several files
Choose the column that divides (branch, sales rep, customer) or a batch size: every piece keeps the header, and they all go into a ZIP archive, or as sheets of a single workbook.
What this tool does
- By the value of a column: one file per value, named after it.
- By number of rows: regular batches, for an import that refuses large files.
- Each piece as XLSX or CSV in a ZIP archive, or a single workbook with one sheet per piece.
- A preview of the pieces and their row counts before splitting.
What it does not do: A workbook with sheets cannot hold more than 255 pieces: beyond that, choose separate files. Formulas and formatting are not carried over.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Merge Excel files : Files and sheets in a single table, even when the columns are not in the same order.
- Look up between two files : VLOOKUP between files, without a formula, and the list of what found nothing.
- Reconcile two lists : Statement and ledger, file and export: what matches, and the differences.
- Compare two Excel files : Two versions of the same table: added rows, removed rows, changed cells.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.