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 Sheets is one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Download XLTools for Excel

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.

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.

   

   

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.

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.

   

   

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.

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.

   

   

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.

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.

   

   

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.

• 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

  

  

• 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

  

  

• 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

  

  

• 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