Convert Office Spreadsheet XML to XLSX in Excel
Question details
Convert an Office Spreadsheet XML file into an XLSX workbook while preserving its worksheet structure and data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user has an Office Spreadsheet XML file and wants to use it as an Excel workbook.
- Observed behavior
- Renaming the file with an .xlsx extension does not convert it, and Excel may display worksheet names such as Forecast as cell content.
Make sure the source file has its original .xml extension rather than a renamed .xlsx extension. Check that you have Excel installed and can identify the expected worksheet names and data.
Open the Spreadsheet XML file in Excel and save it as XLSX
Use Excel to interpret the XML as a workbook, verify the result, and create a real XLSX file.
In Excel, select File > Open > Browse. Choose the .xml file; if it is not visible, change the file-type filter to XML Files or All Files.
If Excel asks how to open the XML, choose an option that opens it as a workbook rather than as an XML table. The available options may vary by Excel version.
Inspect the sheet tabs and cells. For example, confirm that Forecast appears as a worksheet tab rather than only as cell content, and check that the data is in the expected rows and columns.
Select File > Save As, choose a location, and select Excel Workbook (*.xlsx) as the file type. Enter a file name and select Save.
Open the new .xlsx file in Excel and check its sheet tabs, data, and formatting.

Save a recognized XML spreadsheet as XLSX in WPS Spreadsheets
Try opening the XML file in WPS Spreadsheets and saving it as an XLSX workbook. Check the sheet tabs and data first; if WPS does not interpret the XML as a workbook, use Excel instead.
- 1. Open the source file: In WPS Spreadsheets, select Open and browse to the original .xml file. If needed, choose All Files in the file picker.
- 2. Inspect the workbook: Check the sheet tabs, cell values, and layout. Continue only if WPS displays the XML as the expected workbook.
- 3. Save as XLSX: Select Menu > Save As, choose a location, and select the Excel Workbook (.xlsx) format before saving.
- 4. Check the new file: Open the saved .xlsx file and confirm that the expected worksheets and data are present.

Frequently Asked Questions
Why doesn't changing .xml to .xlsx convert the file?
Changing the extension only changes the file name, not its contents. Open the XML in Excel and use File > Save As with Excel Workbook (*.xlsx) selected.
Why is the worksheet name appearing in a cell?
Excel may have interpreted the file as XML data rather than as a workbook. Reopen the original .xml file through File > Open and, if prompted, choose an option that opens it as a workbook.
Will importing XML preserve every worksheet and its formatting?
Not necessarily. XML import options can extract data without recreating the original sheets or formatting. Check the sheet tabs, cells, and formatting before saving as XLSX.
What should I do if WPS Spreadsheets does not display the XML correctly?
Do not rely on the incorrectly displayed result. Open the original .xml file in Excel using File > Open, verify the workbook structure, and then use File > Save As to create an XLSX file.




