Open an XML File in Microsoft 365 Excel When the XML Handler Fails
Question details
The user needs to open an XML file in Excel after changing its file association does not work.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- The user wants to view XML data in Excel.
- Observed behavior
- Associating the XML file with MSOXMLED.EXE does not allow the file to open or upload.
Make sure Excel is installed and that you can locate the XML file on your device. If the file is part of a download, extract it first if necessary.
Open the XML File Directly in Excel as a Table
Use Excel's Open dialog to bypass the XML file association and display compatible data in a table.
Open Excel, then select File > Open > Browse.
Locate and select the XML file, then click Open. If it is not visible, change the file type filter to show XML files or all files.
When Excel prompts you, select As an XML table and click OK.
If Excel offers to create a schema from the XML data, click OK. Review the imported data in the worksheet.

Work With Excel Tables in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheet to continue working with tabular data and make migration easier. It does not repair the Microsoft XML handler.

Frequently Asked Questions
Why doesn't double-clicking my XML file open it in Excel?
The XML file association may point to a handler that cannot open the file as expected. Instead, start Excel and use File > Open > Browse to select the XML file.
What should I choose when Excel asks how to open the XML file?
Select As an XML table and click OK. If Excel offers to create a schema from the XML data, click OK again.
Why can't I see my XML file in Excel's Open dialog?
In File > Open > Browse, check the folder and change the file type filter to XML files or all files.
Will opening the XML file in Excel fix an upload error?
No. Opening the file in Excel helps you view compatible XML data, but an upload error may require separate troubleshooting in the service receiving the file.




