Save multiple Excel worksheets as separate files in XLSX, TXT, PDF and other formats

When you save an Excel workbook in a different file format, for example, *.txt or *.pdf, Excel will only save the active worksheet. What if you need to save not an entire worksheet, but only a selected range, or all worksheets at once?

The Export Sheets feature simplifies exporting data from Excel to other formats:

  • Export data to TXT, CSV, HTML, PFD and other formats
  • Split a workbook and save the worksheets as separate XLSX or XLS files
  • Export a single range or all worksheets at once

Before you begin, add Export Sheets to Excel

Export Sheets is one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Get started with XLTools ribbon
– free trial gives you 14 days of full access to all features.

How to export data from Excel to a different format

The list of supported export formats covers most needs:

  • XLSX, XLS, XLSM, XLSB, ODS
  • TXT, PRN
  • XML
  • HTML
  • PDF

If you want to export data to CSV format, check out the Export to CSV tool. With its wider functionality, you can also choose a delimiter and character encoding.

Export worksheets to the most common formats: XLSX, TXT, PRN, XML, HTML, PDF
  1. On XLTools tab, click the Export button From the drop-down list, select the required format A window will open.
  2. Choose Selected range, This worksheet or All worksheets in this workbook.

    If you choose to export all worksheets, each worksheet will be saved as a separate file. The resulting files will inherit names from the corresponding source worksheets.
  3. Set processing options.

    Select all worksheets in this book and export to TXT
  4. Check the box Open file (folder) after export, if you want to see the result immediately.

    Note: the resulting CSV file will open either in Notepad, or in Excel. This depends which program you have as default to open *.csv files on your computer.
  5. Click OK Save the file(s) to your computer Done.
See result: all worksheets in a workbook are saved as TXT

Another approach to save multiple worksheets to a different format, is to use Workbook Organizer.

  1. On XLTools tab, click the Workbook Organizer button A window will open.
  2. From the list of all worksheets, select one, all or just a few worksheets you want to export.
  3. Click the Save icon From the drop-down list, select Save sheet(s) as separate files.

    Select the worksheets in Workbook Organizer and export them to a different format
  4. The window with export options will open Set processing options Select the output format.
  5. Click OK Save the file(s) to your computer Done.

How to split a workbook and save worksheets as separate files

You can save worksheets in a workbook as separate files in just a few clicks, essentially, splitting a workbook. At the same time you can choose the format of the output files: XLSX, XLS, XLSM, or XLSB.

  1. On XLTools tab, click the Export button From the drop-down list, select the required format A window will open.
  2. Choose All worksheets in this workbook.
  3. Set processing options.

    Select the worksheets you want to save as separate files
  4. Check the box Open folder after export, if you want to see the result immediately.
  5. Click OK Save the files to your computer Done.
See result: all worksheets as saved as separate files

To split the workbook in a click, use the quick access button:

  1. On XLTools tab, click the drop-down list on the Workbook Organizer button Click Save all sheets as separate files.
  2. Save the files to your computer Done.

    Quickly split an Excel workbook into multiple files

How to set processing options for exporting Excel worksheets

You can define how to process and export values from Excel to other formats. Note, that depending on the selected export format some options may not be available.

Set processing options to export Excel data
  • Save values As formatted values

    Select this option, if you want to export values in the format that matches Excel formatting – as displayed in cells. For example, 10%, 12-Mar-2016, $40.

    The option is available for: TXT, PRN, XML, HTML

    Set option: export formatted values
  • Save values As actual values

    Check this option, if your source table has merged cells. The add-in will duplicate values from merged cells into the corresponding places of the resulting file.

    The option is available for: TXT, PRN

    Set option: export actual values
  • Check the box Unmerge cells and duplicate values

    Check this option, if your source table has merged cells. The add-in will duplicate values from merged cells into the corresponding places of the resulting file.

    The option is available for: TXT, PRN

    Set option: unmerge cells when exporting
  • Check the box Replace formulas with their results

    Check this option, if you want to replace formulas with their calculated values. This will help avoid errors and broken formulas in the resulting files.

    The option is available for: XLSX, XLS, XLSM, XLSB, ODS

    Set option: replace formulas with results
Any questions or suggestions?
How can we help?