File Cannot Open

Fix XML Files Not Opening in Excel from Teams or SharePoint

Natalie TaylorNatalie Taylor Nov 14, 2026 872 views

Question details

The user needs to open XML files in Excel from Microsoft Teams or SharePoint Online.

Fix XML Files Not Opening in Excel from Teams or SharePoint
Product
Microsoft Excel, Microsoft Teams, and SharePoint Online
Device & OS
not provided
Scenario
A user selects an XML file stored in Teams or SharePoint and wants it to open in Excel.
Observed behavior
The XML file opens as text or fails to launch in Excel.
Before you start

Confirm that the file is valid XML and intended to be opened in Excel. Note whether the issue affects one file or multiple files, users, sites, and devices.

Solution 1Recommended

Open the XML file from within Excel

Use Excel's Open dialog to check whether the file itself can be opened, independently of the Teams or SharePoint link.

1
Download the file

In Teams or SharePoint, select the XML file and choose Download from the file menu.

2
Open it in Excel

In Excel, select File > Open > Browse, locate the downloaded XML file, and open it. If it is not visible, change the file type filter to show XML files or all files.

3
Choose an import option

If Excel offers XML import options, select the option appropriate for the file and follow the prompts. Some valid XML structures may not import as a worksheet.

4
Compare the results

Try opening the same file from its Teams or SharePoint location, then repeat the test with another file or device. If Excel opens the downloaded file but the link does not launch Excel, investigate the opening path or device configuration.

Open the XML file from within Excel
Free Microsoft Office alternative

Work with Excel-compatible spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move spreadsheet work between applications. It does not fix Microsoft Teams or SharePoint XML launch settings.

Open and edit compatible Excel XLSX and XLS filesWork with spreadsheet data in a familiar interfaceUse a free, lightweight office suiteMove existing Excel-format workbooks between Office applications
microsoft office alternative - wps office

Frequently Asked Questions

Why does my XML file open as text instead of in Excel?

Teams, SharePoint, a browser, or the device's file association may handle the XML file as text. Download the file and try Excel > File > Open > Browse to check whether Excel can open it separately.

Does valid XML always open as an Excel worksheet?

No. An XML file can be valid without having a structure Excel can import as a worksheet. Open it through Excel's File > Open menu and follow any XML import prompts to test the file.

How can I tell whether the issue is tenant-wide?

Test the same XML file and other files across multiple users, SharePoint sites, and devices. If the issue is widespread, ask a Microsoft 365 administrator to contact Microsoft through Help & support in the admin center.

Should I change the Windows registry to fix XML file opening?

Only consider registry changes after reviewing Microsoft's relevant guidance and confirming the installed Office and Registry Editor versions. Back up the relevant registry key and involve an administrator before making changes.