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

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!

Tip: Quickly save just your selection or sheet as a new file

Starting this tool

Click ASAP Utilities › File & System › 5. Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

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

Choose your language preference below

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

Reopen Current File Without Saving Changes

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

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

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