Shiklo Tools
PDF40
Image20
Calculators & Converters25
Text & Writing13
Developer26
Video14
Audio14
Document14
Data & Spreadsheet12
Web & SEO9
OCR & Scanning5
Archive & File12
Security & Privacy23
Health & Medical29
QR & Barcode5

Split Excel Sheets into Separate Files

Save each sheet of an Excel or OpenDocument workbook as its own .xlsx or CSV file, keeping the formatting.

Need to send each department only its own sheet, or load every tab of a workbook into another system? Open an Excel workbook (.xlsx or .xlsm) or an OpenDocument spreadsheet (.ods), tick the sheets you want, and the tool saves each one as a separate file: an Excel workbook that keeps the cell formatting, column widths, merged cells and frozen panes, or a CSV file with the values. One sheet downloads directly; several come together in a ZIP, named after the workbook and the sheet.

A sheet on its own can no longer see the other sheets, so formulas that refer to them would turn into #REF! errors. The tool replaces those formulas with the values they last calculated and tells you how many it changed; formulas within the sheet keep working. You can also choose to save values only. The workbook is split in your browser and never uploaded.

How to use Split Excel Sheets into Separate Files

  1. Choose or drop an .xlsx, .xlsm or .ods workbook.
  2. Tick the sheets to save (hidden sheets start unticked).
  3. Choose Excel (.xlsx) or CSV, and whether to keep formulas or save values only.
  4. Click Split: one file downloads directly, several come as a ZIP.

Features

  • One .xlsx or CSV file per sheet
  • Formatting, widths, merged cells and frozen panes kept
  • Formulas that use other sheets saved as their values
  • Choose which sheets; hidden sheets marked
  • Several files downloaded as one ZIP
  • Excel .xlsx, .xlsm and OpenDocument .ods; nothing is uploaded

What is kept in each file

Excel output copies the sheet's cells with their values, number formats, fonts, fills, borders and alignment, the column widths and row heights, merged cells, frozen panes, the print setup and data validation. Formulas that only use cells on the same sheet are kept as formulas. Charts, pictures, pivot tables, slicers, comments and macros are not copied, and links between sheets cannot work once the sheets are in different files.

In the original sheetIn the split .xlsx fileIn the CSV file
Values and textkeptkept
Formatting, column widths, merged cellskeptnot kept
Formula using the same sheet, =SUM(B2:B9)kept as a formulasaved as its value
Formula using another sheet, =Prices!B2*C2saved as its valuesaved as its value
Charts, pictures, pivot tables, macrosnot copiednot copied

Why formulas that use other sheets become values

A formula such as =Prices!B2*C2 needs the Prices sheet. In a file that contains only the Orders sheet it would show #REF! the moment Excel recalculates, which looks like broken data. Saving the last calculated value instead keeps the numbers exactly as they appeared in the workbook. The values are those Excel or LibreOffice saved when the file was last calculated, so recalculate and save the workbook first if you changed it in a program that does not calculate automatically. Choose Values only to replace every formula, for example when you send figures to someone who should not see how they are calculated.

Excel or CSV?

Choose Excel when people will open the files: they look like the original sheet. Choose CSV to import the data into a database, an accounting system, Python or another tool: each file is plain text with one row per line, values separated by commas, saved as UTF-8 with a byte-order mark so that Excel shows accented letters and currency signs correctly. Dates are written as year-month-day. Use Excel to CSV instead if you need a different separator.

Supported workbooks

Excel .xlsx files and macro-enabled .xlsm files (the output is always .xlsx, without macros) and OpenDocument .ods spreadsheets from LibreOffice and other suites. OpenDocument sheets are saved with their values; their formatting is not converted. Old binary .xls files and password-protected workbooks cannot be opened in a browser: save them as .xlsx without a password first. Workbooks up to 100 MB can be split.

Frequently asked questions

How do I split an Excel workbook into separate files?

Drop the workbook here, tick the sheets and click Split. Each sheet becomes its own .xlsx or CSV file.

Is the formatting kept?

Yes for Excel output: formats, fonts, colours, borders, column widths, merged cells and frozen panes are kept. CSV files hold values only.

What happens to formulas?

Formulas within the sheet are kept. Formulas that refer to other sheets or workbooks are saved as their last calculated values so they don't turn into #REF! errors.

Is my workbook uploaded?

No. It is split in your browser and never leaves your device.

Can I split only some sheets?

Yes. Untick the sheets you don't need. Hidden sheets start unticked.

Does it work with .xls or .ods files?

.ods works. The old .xls format can't be read in a browser; save it as .xlsx first.

How are the files named?

Workbook name, a dash and the sheet name, for example Budget - March.xlsx. Several files are downloaded as one ZIP.

Related tools