Use Excel Splitter - free
Frequently asked questions
What happens to formulas that reference other sheets?
Formulas that reference cells on a different sheet will break once that sheet is split into a separate file, since the reference no longer resolves. Values computed before splitting are preserved as static results where the source uses simple formulas.
How many sheets can I split at once?
There is no hard limit. Every sheet in the workbook becomes its own file.
What format are the split files?
Each output file is a standard .xlsx spreadsheet.