logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Export selection or active sheet as new file...

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

File & System  ›  5. Export selection or active sheet as new file...

With this utility you can save your selected data range or the entire worksheet as a new file.
You can choose not to include hidden cells in your export.

The data can be exported in the following file formats:
  • Excel 97-2003 Workbook (*.xls)
  • Excel Workbook (*.xlsx)
  • Excel Binary Workbook (*.xlsb)
  • PDF (*.pdf)
  • Formatted text (space delimited)
  • Tab delimited text file
  • Tab delimited unicode text file
  • JSON (*.json)
  • CSV (comma separated value or custom separated)
  • CSV unicode, UTF-16LE / UTF-8 (comma separated value or custom separated)
    You can also use the CSV option to create your own custom separated file by setting your own field separator, field encloser and decimal separator. This way you can for example create pipe (|) delimited text files.

    You can also choose to copy the information directly to your clipboard in the following formats:
  • tab delimited
  • space delimited

    You can choose to export the contents of the cells as:
  • Values (for example 12)
  • Formulas (for example =3*E6)
  • As displayed (for example EUR 12,00)

    Your last used settings will be remembered.

    Screenshots

    Example screenshot: 1
    1, File & System  ›  5 Export selection or active sheet as new file...
    Example screenshot: 2
    2, File & System  ›  5 Export selection or active sheet as new file...
    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 active sheet as new file...
    Additional keywords for this tool:
    save, flat table, tsv, txt, xls, dbf, textfile, option to save only the filtered results, UTF8, UTF16, UTF-8, UTF-16, UTF8 BOM, UTF-16 BOM


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


    Empowering Excel Users Worldwide for 25 Years