logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Tuesday March 17th, 2026

Tip of the Day | Tuesday March 17th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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
    Example screenshot: 1, Export  ›  Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    Example screenshot: 2
    Example screenshot: 2, Export  ›  Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    Example screenshot: 3
    Example screenshot: 3, Export  ›  Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...
    Example screenshot: 4
    Example screenshot: 4, Export  ›  Export Worksheets as Separate Files (Excel, PDF, TXT, CSV, etc.)...

    Starting this tool


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

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.