Tip of the Day | Monday 9 November 2026

This tool lets you export all worksheets, or only selected ones, from your workbook as separate files.
You can choose the output folder, export format, and whether to include cells in hidden rows and columns.

Supported file formats include:

• Excel Workbook (*.xlsx)
• Excel Binary Workbook (*.xlsb)
• Excel 97-2003 Workbook (*.xls)
• CSV, comma-delimited (*.csv)
• Text, delimited by semicolon (;) (*.txt)
• Text, tab-delimited (*.tsv)
• Formatted Text, space-delimited) (*.prn)
• Text, delimited by pipe (|) (*.txt)
• Text, delimited by tilde (~) (*.txt)
• JSON (*.json)
• Web Page (*.htm, *.html)
• Single File Web Page (*.mht, *.mhtml)
• PDF (*.pdf)

Additional options:

• Skip cells in hidden rows or columns
• Export text files using Unicode UTF-8 or UTF-16LE encoding
• Customize CSV/DSV export: field separator, text qualifier, and decimal symbol
• Automatically name output files based on sheet names

Content options:

• Export as values only (e.g., 12)
• Export as formulas (e.g., =3*E6)
• Export as displayed (e.g., €12.00)

Your last used settings and output location are remembered.

Use this tool when you want to:

• Split a workbook into individual files by worksheet
• Export only certain sheets in a specific format
• Quickly generate multiple files for sharing, reports, or backups

Starting this tool