Split Excel Sheets

Reads the workbook, writes each worksheet out as its own .xlsx, and hands you a ZIP. Values, formulas, number formats, column widths, merged cells and comments come across. Fonts, fill colours, borders, charts, conditional formatting and dropdown lists do not — the page says so again next to the download button, not only here.

  • No upload
  • No account
  • No watermark
  • No file limit
Drop your files hereor click to chooseNo size limit and no count limit — only what your own computer can hold.

Your files

    Nothing chosen yet.

    Where your file goes

    Nowhere. This page downloads a small program into your browser, and that program reads the file straight from your disk. The program comes from this site like any image or stylesheet — but your file only ever travels from your disk into your own browser tab.

    Why this one

    What you get that the big converters cannot offer.

    It tells you what it drops

    Cell colours, borders, charts, conditional formatting and dropdown lists are gone in the copies. That is the honest cost of rebuilding the file in the browser, and you should know it before you send the files on.

    Formulas stay formulas

    A formula that only refers to its own sheet still works. One that points at a sheet left behind cannot — so the page counts those and tells you how many, instead of letting Excel surprise you with #REF!.

    One ZIP, not thirty downloads

    Browsers block a page that fires off download after download. Everything past the first file arrives as a single ZIP.

    Files named after the sheets

    budget-Q1 Actuals.xlsx, not sheet1.xlsx. Slashes and colons are swapped out so the names work on Windows and macOS.

    How to use it

    Choose an .xlsx, .xlsm or .xls file.

    Untick “skip empty sheets” if you want those too.

    Press Start and download the ZIP.

    When people use it

    One tab per client, one file per client

    A workbook where each tab is a customer, and each customer should only ever see their own numbers.

    An upload form that takes one sheet

    Plenty of accounting and payroll imports read the first sheet and ignore the rest.

    Splitting a monthly pack for review

    Send three people three files instead of one workbook with everybody’s tabs in it.

    Questions

    What exactly is lost?

    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.

    Why are the colours gone?

    The library that rebuilds the file in your browser writes number formats but not the rest of the styling. Keeping it would mean either a paid library or an upload, and both cost more than the colours are worth. If the formatting matters, copy the sheet inside Excel instead.

    Do formulas still work?

    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.

    Can it read old .xls files?

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

    Is the file uploaded?

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

    Other tools