Split an Excel file into separate files
Turn one big spreadsheet into several: a workbook per sheet, a file for each region or client, or equal pieces of N rows. The header row is repeated in every part, and formats and formulas come along.
How it works
- Step 1
Choose your .xlsx or .csv file.
- Step 2
Pick how to cut it: each sheet, the values of a column, or every N rows.
- Step 3
Download all the parts together as a ZIP.
Why use it
- Send each client or region only its own rows: the other sheets are left out of every part.
- Number formats, column widths, styles and formulas are kept, and relative formulas follow their rows.
- CSV files work too, accents and semicolons included.