Many people in the workplace have a pile of old version. xls format Excel files in their hands, and use the new version of WPS to open the prompt "compatibility mode". The formula is inexplicably invalid. Uploaded to the company's collaboration platform, colleagues said it could not be opened. Even copied to the mobile phone, typesetting is all messed up. Converting Excel into Xlsx format can solve these compatibility problems at one time, and can also support larger data volume and more advanced functions. Whether it is financial statements, administrative summary data, or teacher statistical results, it can be used. It is the basic operation to improve office efficiency.
Why batch Excel into Xlsx?
1. Cross-software/device compatibility: Xlsx format can perfectly adapt to the new version of Office, WPS and online documents. No matter whether the computer, mobile phone or tablet is opened, it will not be garbled.
2. Support more office requirements: it can accommodate more than one million rows of data, and can also use the new version of Excel functions such as dynamic charts and data verification. The old version of. xls format does not support it at all.
3. Convenient team cooperation: At present, most companies and schools use Xlsx format to transfer files by default. After conversion, they do not need to adjust the format repeatedly and just send them directly.
4. Reduce file damage: The old version of. xls file is easy to damage after being stored for a long time. Xlsx format storage is more stable, and even if it is stored in the cloud, it is not easy to have problems.
Effect Preview
Before treatment:
After treatment:
Method one: HeSoft Doc Batch Tool
Recommended Index:β
β
β
β
β
Advantages:
1. Real batch processing, can directly select the entire folder of Excel files, one-time conversion of thousands, not one by one selection;
2. Small problems can be automatically fixed during conversion, such as misplaced cells and invalid simple formulas, which are almost the same as the original file after conversion;
3. After conversion, it can be directly encrypted in batch, which is suitable for processing sensitive documents such as financial data and contract ledgers.
Disadvantages: Need to download software to use.
Operation steps
1. Open first HeSoft Doc Batch Tool After the installation is completed, open it, find "Excel Tools" in the function bar on the left, click on it and select "Excle to xlsx".
2. Click "Add Folder" to find the folder where the files to be converted are stored, and confirm the import after selecting it.
3. Click "Output Path" and click "Start Conversion". After the progress bar is finished and the display processing is completed, open the output folder to the saved path and you can get all Xlsx files.
Method 2: WPS/Jinshan Document (Combined Version)
Recommended Index:β
β
β
β
β
Advantages: Without installing new tools, the computer can turn local with WPS, and turn online with Jinshan document without WPS, with high flexibility.
Disadvantages: WPS free version can only transfer 5 files at a time, and members are required for batch transfer. Jinshan documents need to be transferred online to stabilize the network, and large files need to be transferred slowly.
Operation steps
1. Local WPS: Open WPS, click "Tools" at the top, and then select "Format Conversion" β "Excel to Xlsx".
2. Click "Add File" and select the. xls file to be transferred. The free version can select up to 5.
3. Select the output path, click "Start Conversion" and find it in the corresponding folder after the conversion.
4. Use Jinshan Document Online: Log in to your account, upload the. xls file, right-click on the file and select "Save As" and then select "Xlsx Format".
Method 3: Microsoft Excel's own functions
Recommended Index:β
β
β
β
β
Advantages: Without installing any additional software, the computer's own Excel can be used. The conversion quality is the most stable and the format will not be lost.
Disadvantages: Only one file can be transferred one by one. If there are dozens or hundreds of files, your hands will be sore.
Operation steps
1. Double-click to open the. xls file you want to convert.
2. Click "File" at the top and select "Save".
3. Select Excel Workbook (.xlsx) as the save type ".
4. Select the place to save, click "Save" and close the file.
Method 4: cloudconvert online tools
Recommended Index:β
β
β
β β
Advantages: high conversion accuracy, even if there are complex tables, nested formula file, turn is not easy to error.
Disadvantages: Online conversion has data security issues. Words can only be converted into one file, which is inefficient.
Operation steps
1. Open the browser, search "cloudconvert", enter the official website and find the "Excel to Xlsx" function.
2. Click "Choose File" to transfer the xls file to be transferred and drag it directly.
3. Without setting other parameters, the tool will automatically start the conversion.
4. After turning to "download", you can get the Xlsx file.
Method 5: FreeConvert Online Tools
Recommended Index:β
β
β
β β
Advantages: online use, easy to handle a small amount of documents.
Disadvantages: English operation interface is not very friendly, and can only be converted individually, which is greatly affected by network speed.
Operation steps
1. Enter FreeConvert official website and select "Document Converter" on the first page ".
2. Select the "XLSX Converter" function again and click "XLS to XLSX Converter".
3. Click "Choose Flie" to upload the file, and after downloading, you can get the Xlsx file.
Method 6: Zamzar Online Tool
Recommended Index:β
β
β
β β
Advantages: completely free, no need to register an account, online conversion.
Disadvantages: The conversion speed is a bit slow. If you catch the peak period, you may have to wait several minutes. Oversized files (over 1M) require money.
Operation steps
1. The browser searches for "zamzar" and after entering official website, follow the circled path to find the "xls to xlsx" function.
2. Click "ChooseFlie" to batch select the. xls files to be transferred.
3. Confirm that the output format is Xlsx, click "Start" and save it.
Method 7: FreeFileConvert
Recommended Index:β
β
β
β β
Advantages: online conversion is more convenient, no need to download software.
Disadvantages: Access to some areas is not very stable; The conversion speed depends on the network speed. Slow network speed takes a lot of time.
Operation steps
1. Enter the official website of the FreeFileConvert and select the "XLS to XLSX" function according to the path.
2. Click "Choose Files" to upload local files.
3. Confirm that the output format is Xlsx, click "Convert" and wait for the tool to convert automatically.
4. Click "Download" to download after turning.
Method 8: LibreOffice
Recommended Index:β
β
β
β β
Advantages: completely free, do not have to spend money to buy members.
Disadvantages: The interface is a bit complicated. It takes half a day to find the function button for the first time. There may be some minor problems after some advanced formats are transferred.
Operation steps
1. Open the LibreOffice Calc software, click "File" β "Open" and select the. xls file.
2. After the file is opened, click "File" β "Save".
3. Select "Microsoft Excel 2007-2019(.xlsx)" as the save type ".
4. Select the save path and click "Save.
Method 9: Online-Convert Online Tools
Recommended Index:β
β
β
β β
Advantages: You can set your own conversion parameters, such as whether to keep macro commands or compress pictures, which is suitable for people with special needs.
Disadvantages: There are many advertisements in the free version and the conversion speed is slow. Only one file can be transferred at a time, so batch processing is very troublesome.
Operation steps
1. Enter Online-Convert official website and select "Document" β "Excel" β "Convert to Xlsx".
2. Click "Choose Files" to upload the. xls file to be transferred.
3. Then click "Start conversion".
4. After turning to "Download", download the file.
Method 10: Aspose Online Tool
Recommended Index:β
β
β
β β
Advantages: can directly upload cloud files, file size and number of unlimited.
Disadvantages: Batch conversion needs to be upgraded to paid users.
Operation steps
1. Enter Aspose official website and select the "XLS to XLSX" function according to the path.
2. Click Dtop or upload your files to upload the local files.
3. Confirm that the output format is Xlsx, click "Convert" and wait for the tool to convert automatically.
4. Click "Download" to download after turning.
The above methods can basically solve the core requirements of Excel to Xlsx. Even if you need to process multiple files in the future, don't manually convert them one by one. Selecting batch tools can greatly improve the efficiency. You can choose the appropriate tools according to your own needs.