Free online PDF tool

Excel Split

Splits an Excel workbook (.xlsx) and returns the pieces in a ZIP: cut each worksheet every N rows or N columns with the header repeated in every file, or one workbook per worksheet. A preview of the worksheet shows what you are cutting, and you choose which worksheets to split. Values, number formats, fonts, fills, borders, merged cells, widths, heights, comments and links carry over; split by worksheet also keeps formulas as written, freeze panes and tables, while splitting by row or column does not carry data validation, conditional formatting, tables, charts, freeze panes or print setup. Formulas that point outside their own file or at another worksheet will not find their data. Workbooks with pivot tables, macros, embedded objects or data connections are refused. Splitting needs a server, so the file is sent over an encrypted connection, split, and the copy there is deleted as soon as the result is sent back, unless you are signed in and asked to keep it.

Drop an Excel file here
Split a workbook into one file per worksheet.

What it does

Excel Split, at a glance.

  • Cut each worksheet every N rows or N columns, header repeated
  • Or give every worksheet its own .xlsx, in a ZIP
  • Delete the server copy as soon as the result is sent back

This tool needs a server. The file is sent over an encrypted connection, processed, and the copy there is deleted as soon as the result is sent back — unless you are signed in and asked to keep it.

Step by step

How to split an Excel workbook

  1. Open the .xlsx workbook you want to split.
  2. Choose the worksheets to split out, or keep every visible one.
  3. Download the ZIP: one workbook per worksheet, in worksheet order.

Questions

Excel Split: questions and answers

Yes. Splitting a workbook needs a server, so the file is sent over an encrypted connection. The copy there is deleted as soon as the result is sent back, unless you are signed in and asked to keep it.

Similar tools

The reverse direction first, if there is one, then a few more we think you'll want next.