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 Excel 97-2003 To Excel 2013
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:3.
When you have installed Kutools for Excel, you can do as following steps:1. Click Kutools Plus Workbook Format Converter, see screenshot: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 button to add the files or folders that you want to convert.
See screenshot:3. After adding the Excel files into the list box, click 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.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:5. And all the Excel files format in the specified folder have been converted.
See screenshot: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. Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%. 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.