File Format & Compatibility

Convert Office Spreadsheet XML to XLSX in Excel

Rana GarciaRana Garcia Nov 14, 2026 868 views

Question details

Convert an Office Spreadsheet XML file into an XLSX workbook while preserving its worksheet structure and data.

Convert Office Spreadsheet XML to an XLSX Excel File
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the XML 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.

2
Choose a workbook option

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.

3
Check the worksheet

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.

4
Save as XLSX

Select File > Save As, choose a location, and select Excel Workbook (*.xlsx) as the file type. Enter a file name and select Save.

5
Verify the saved workbook

Open the new .xlsx file in Excel and check its sheet tabs, data, and formatting.

Open the Spreadsheet XML file in Excel and save it as XLSX
If the XML opens as plain data: Do not save the result as the final workbook until you have checked it. XML import options may extract data without preserving the original worksheet structure or formatting.
Work with spreadsheets in WPS Office

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. 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. 2. Inspect the workbook: Check the sheet tabs, cell values, and layout. Continue only if WPS displays the XML as the expected workbook.
  3. 3. Save as XLSX: Select Menu > Save As, choose a location, and select the Excel Workbook (.xlsx) format before saving.
  4. 4. Check the new file: Open the saved .xlsx file and confirm that the expected worksheets and data are present.
Save a recognized spreadsheet as an XLSX workbookCompatible with Microsoft Excel XLSX filesReview worksheet tabs and data before savingFree spreadsheet tools with a familiar interface
microsoft office alternative - wps office

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.