Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to convert multiple xlsx formats to xls formats or vice versa in Excel?

Supposing your co-worker have an older version of MS Excel as xls format, but your Excel format is xlsx (Excel 2007, 2010 or 2013), after sending the Excel files to him, his old version of Excel would not open these new formats unless he downloads a compatibility pack from Microsoft Office net. So before sending the files to him, you’d better convert the Excel files from xlsx format to xls format. How could you convert multiple xlsx formats to xls formats or vice versa at once in Excel?

Convert multiple xlsx formats to xls formats with Save As function one by one

Convert multiple xlsx formats to xls formats with Kutools for Excel at once

Convert multiple Excel files to PDF files with Kutools for Excel


Convert multiple xlsx files to xls files or convert multiple workbooks to PDF files:

With Kutools for Excel's Format Converter utility, you can quickly convert multiple xlsx files to xls files or vice versa, at same time, you also can convert workbook files PDF files as you need.

doc convert xlsx to xls file 8

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Convert multiple xlsx formats to xls formats with Save As function one by one


The Save As function in Excel can help you convert the workbook’s xlsx format to older xls format one by one.

1. Open your workbook that you want to convert its format.

2. Click File > Save As in Excel 2010 and later version, and a Save As dialog will display, specify a folder to place the new format of the file, and then click Save as type drop down list to choose Excel 97-2003 Workbook, see screenshot:

doc convert xlsx to xls file 1

3. Then click Save button to close the dialog, and this Excel format has been converted from xlsx to xls.

Tip: If you are using Excel 2007, please click Office Button > Save As > Excel 97-2003 Workbook, see screenshot:

doc-convert-xlsx-to-xls2

With this Save As function, you just only convert one Excel file at a time, if you have hundreds of Excel files need to be converted, this method is not a good choice.


Convert multiple xlsx formats to xls formats with Kutools for Excel at once

With this Kutools for Excel’s Format Converter utility, you can convert multiple xlsx formats to xls formats or vise versa, it also can help you convert multiple workbooks to PDF files at one.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days. 

When you have installed Kutools for Excel, you can do as following steps:

1. Click Kutools Plus > Workbook > Format Converter, see screenshot:

doc convert xlsx to xls file 2

2. And in the File Format Converter dialog, click the Type drop down list to choose the converter type you need, in this example, I select Excel 2007 or higher to Excel 97-2003. Then click doc-button1 button to add the files or folders that you want to convert. See screenshot:

doc convert xlsx to xls file 3

3. After adding the Excel files into the list box, click doc-button2 button to specify the directory that you like to put these new format files. You can also save the new files into the source file directory. If you don’t want to keep the source files after conversion, please check Delete source files after conversion.

doc convert xlsx to xls file 4

4. Then click OK to start converting, after finishing the conversion, a new workbook will be displayed to show the details of the conversion. See screenshot:

doc convert xlsx to xls file 5

5. And all the Excel files format in the specified folder have been converted. See screenshot:

doc convert xlsx to xls file6

Notes:

1. With this utility, you can also convert multiple xls formats to xlsx formats by choosing the Excel 97-2003 to Excel 2007 or higher from the Type drop down list.

2. All of the files in your specified folder which includes the subfolders will be converted to the file format as you want as well.


Convert multiple Excel files to PDF files with Kutools for Excel


Convert multiple Excel files to PDF files with Kutools for Excel

If you want to convert multiple workbook files to PDF files immediately,  please select the Excel workbook to PDF from the Type drop down list.

doc convert xlsx to xls file 7

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Demo: Convert multiple xlsx files to xls files or convert multiple workbooks to PDF files

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Related article:

How to convert multiple workbooks to PDF files at once in Excel?


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
 
 
 
 
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Bill Hogsed · 5 years ago
    Can you save a xls as a xlsx and maintain 1,048,576 rows and XFD Columns?