logo ASAP Utilities
HomeExtra features for ExcelExportExport Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...

ASAP Utilities  › Export  ›  4. Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...

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

    Screenshots

    Example screenshot: 1
    1, Export  ›  4 Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    Example screenshot: 2
    2, Export  ›  4 Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    Example screenshot: 3
    3, Export  ›  4 Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    Example screenshot: 4
    4, Export  ›  4 Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Export  ›  4 Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    Additional keywords for this tool:
    export sheets, save each sheet as file, split workbook into separate files, export Excel tabs, save tabs as files, export selected worksheets, multiple sheet export, batch export Excel, export worksheets as files, workbook file splitter, save Excel sheets individually, create individual files from workbook
    Trustpilot
    Download  



    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.