Split Excel Sheets

Fonts, text colour, cell fill, borders, alignment, charts, conditional formatting, data validation dropdowns and macros. What survives is the cell values, the formulas, number formats such as #,##0.00, column widths, row heights, merged cells and comments.

The library that rebuilds the file in your browser writes number formats but not the rest of the styling. If the formatting matters, copy the sheet inside Excel instead.

Formulas inside the same sheet do. Formulas pointing at another sheet cannot, because that sheet is not in the new file: Excel shows #REF!. The page counts them and tells you before you download.

Yes, and .xlsm too. The output is always .xlsx. Macros in an .xlsm are not carried over.

No. The workbook is read and rebuilt inside your browser, and the ZIP is built there too.

Yes. Add them all and every sheet of every workbook becomes its own .xlsx. Each file name starts with the name of the workbook it came from, so two workbooks that both have a sheet called Summary do not overwrite each other. If two names still end up the same, the second gets -2 on the end. Everything goes into one ZIP, named after the first workbook.

A sheet with no values in any cell. A sheet that holds only a formula is not treated as empty, even if the formula shows nothing. Empty sheets are skipped by default and the page tells you how many it left out. Untick skip empty sheets before you press Start if you want a file for those too.

Yes. The page goes through every sheet listed in the workbook, hidden or not, so a sheet you cannot see in Excel still gets its own file. If you do not want it, delete that file from the ZIP before you send the set on.

Workbook name, a hyphen, then the sheet name: budget-Q1 Actuals.xlsx. Characters Windows will not accept in a file name, such as slashes, colons, asterisks and question marks, become underscores. Very long names are cut at 80 characters, and names Windows reserves, like CON or NUL, get an underscore in front.

No. When only one file comes out, for example a workbook with one sheet that has data and a few empty ones that were skipped, the button downloads that single .xlsx directly. The ZIP only appears when there are two or more files to hand back.

There is no list to pick sheets from. The page splits every sheet that is not empty, and you take the one you need out of the ZIP. That still beats copying the sheet by hand when the workbook has dozens of tabs.