File Format & Compatibility

Open an XML File in Microsoft 365 Excel When the XML Handler Fails

Steve KSteve K Nov 22, 2026 868 views

Question details

The user needs to open an XML file in Excel after changing its file association does not work.

Open an XML File in Microsoft 365 Excel When the XML Handler Fails
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.
Before you start

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.

Solution 1Recommended

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.

1
Browse for the file

Open Excel, then select File > Open > Browse.

2
Open the XML file

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.

3
Choose a table

When Excel prompts you, select As an XML table and click OK.

4
Accept the schema prompt

If Excel offers to create a schema from the XML data, click OK. Review the imported data in the worksheet.

Open the XML File Directly in Excel as a Table
XML structure matters: Not every XML file can be displayed as a table. Opening the file in Excel also does not resolve a separate upload problem.
Free Microsoft Office alternative

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.

Work with tabular data in a familiar spreadsheet interfaceCompatible with Microsoft Excel XLS and XLSX formatsFree, lightweight Office alternativeContinue working with compatible Excel files in WPS Spreadsheet
microsoft office alternative - wps office

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.