logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...

ASAP Utilities  › File & System  ›  5. Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...

This tool exports either your selected range or the entire active worksheet to a new file.
You can choose to exclude hidden cells and customize how the content is saved. Supported export formats include:
  • Excel 97-2003 Workbook (*.xls)
  • Excel Workbook (*.xlsx)
  • Excel Binary Workbook (*.xlsb)
  • PDF (*.pdf)
  • Formatted text (space-delimited text file)
  • Tab-delimited text file (*.tsv)
  • JSON (*.json)
  • CSV/DSV (comma- or delimiter-separated values)
          ·  Choose your own delimiter (e.g., comma, semicolon, pipe |, tilde ~)
          ·  Set a field encloser (e.g., double quote ")
          ·  Choose the decimal separator
          ·  Optionally encode as Unicode (UTF-8 or UTF-16) You can also copy the data directly to the clipboard as:
  • Tab-delimited format
  • Space-delimited format Export 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 are remembered automatically. This tool is ideal when you want to:
  • Save a specific section of your workbook as a separate file
  • Quickly extract data for sharing or reporting
  • Export data in a specific format without modifying your original file

    Screenshots

    Example screenshot: 1
    1, File & System  ›  5 Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
    Example screenshot: 2
    2, File & System  ›  5 Export Selection or Sheet to New File (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


    File & System  ›  5 Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
    Additional keywords for this tool:
    save selection, export Excel range, save filtered data, export as txt, export as tsv, export to PDF, export as CSV UTF-8, save without hidden cells, export as values or formulas, export Excel to JSON, copy Excel to clipboard, create flat file from Excel, save part of Excel file, Excel export options



  • 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.