Wednesday, May 6, 2015

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?



arrow blue right bubble Convert multiple xlsx formats to xls formats with Save As function one by one

Hint


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 / 2013, and a Save As dialog will display, specify a folder to place the new format of the file, and then click Save as typedrop down list to choose Excel 97-2003 Workbook, see screenshot:
doc-convert-xlsx-to-xls1
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.

arrow blue right bubble Convert multiple xlsx formats to xls formats with Kutools for Excel at once

With this Kutools for Excel’s File 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 includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.
When you have installed Kutools for Excel, you can do as following steps:
1. Click Enterprise > Workbook Tools > File Format Converter, see screenshot:
doc-convert-xlsx-to-xls3
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-xls4
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-xls5
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-xls6
5. And all the Excel files format in the specified folder have been converted.
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.



Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
gold star1 More than 120 powerful advanced functions which designed for Excel:
  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...
Screen shot of Kutools for Excel
btn read more     btn download     btn purchase

6 comments:

  1. This site have particular software articles which emits an impression of being a significant and significant for you individual, able software installation.This is the spot you can get helps for any software installation, usage and cracked.
    kutools for excel crack
    tweakbit pcsuite crack
    jetaudio music player apk crack
    eco falling ball crack
    material batch uninstaller crack

    ReplyDelete
  2. It is amazing and wonderful to see your blog. Thanks for sharing this information,..
    advanced-xls-converter-crack

    ReplyDelete



  3. Really Appreciable Article, Honestly Said The Thing Actually I liked The most is the step-by-step explanation of everything needed to be known for a blogger or webmaster to comment, I am going show this to my other blogger friends too.
    restoro-crack
    kutools-for-excel-crack
    deep-freeze-crack
    little-snitch-crack
    sidify-music-converter-crack
    sony-vegas-pro-crack
    sparkol-videoscribe-pro-crack
    avocode-crack
    beecut-crack
    ninjagram-crack

    ReplyDelete
  4. CrackBins Full Version Softwares Free Download
    UniPDF PRO Crack
    MediaMonkey Gold Crack
    Varicad Crack
    FinePrint Crack
    VueScan Pro Crack
    Renee PassNow Crack
    Inpixio Photo Studio Key

    ReplyDelete