How to Open an XML File: Excel, Browser, Notepad & Convert

Quick answer: An XML file is structured data written as plain text with tags like ...—not a Word or Excel workbook by itself. Everyday users can open an XML file in Microsoft Excel (As an XML table), preview it in Chrome/Edge, or peek in Notepad. Power users prefer Notepad++, Microsoft XML Notepad, or VS Code for folding and highlighting. To analyze the data, import to a sheet and Save As .xlsx / CSV—don’t stare at tag soup if you only need a table.

 

This guide answers the four searches behind open xml file in the US: which app to use, how to read tags clearly, why Windows or Excel says the file is broken, and how to convert XML without learning markup. (Note: Office files like .docx/.xlsx are “Open XML” packages under the hood—but a generic .xml export from a bank, CRM, or developer tool is usually just tagged text.)

What is an XML file—and can Excel, Chrome, or Notepad open it?

XML (Extensible Markup Language) stores hierarchical data. Windows often has no default “XML Viewer,” so double-click may show Windows cannot open this file or a long Open with list. Pick by goal:

• Microsoft Excel — best when the file is tabular (orders, inventory, reports). Use File → Open → choose As an XML table, or Data → Get Data → From File → From XML.

• Chrome / Edge — fast preview. Drag the file onto the browser or use File → Open. Valid XML often shows a collapsible tree.

• Notepad — always works for small files, but you only get raw tags—fine for a quick peek, poor for nested data.

• Notepad++ / Microsoft XML Notepad / VS Code — lightweight “pro” options: syntax colors, fold nodes, search, and (in some tools) schema validation.

 

Tip: right-click → Open with → Choose another app and check “Always” only after you know which workflow you want. Many people set Excel for data XML and leave Chrome as the occasional viewer.

Why does my XML look like code—and how do I read it like a map?

Those angle brackets are the data. Tags name fields; nesting shows parent/child relationships. To read them “elegantly”:

1. Open in Chrome/Edge and click the triangles to expand/collapse nodes (when the browser formats the file).

2. In VS Code or Notepad++, use code folding on blocks and search for field names.

3. In Microsoft XML Notepad, use the tree pane—closest to a mind-map view for non-developers.

4. If you only care about columns, skip reading markup: import as an Excel table and work in the grid.

 

Why some browser views look neat and others are one line: pretty-printed XML with line breaks and indentation usually gets a tree UI. Minified XML (everything on one line), XML with a stylesheet that the browser treats differently, or files that aren’t well-formed can dump as a single code string. Pretty-print in an editor, or re-save with indentation, then reopen.

 

Why can’t I open the XML—damaged, encoding, or too big?

When Excel, a browser, or an app says the file is corrupt / invalid format, check these causes in order:

• Broken syntax — missing closing tags, mismatched nesting, or special characters not escaped (& → &, <<> → <). A red squiggle in VS Code often points to the line.

• Encoding clash — declaration says UTF-8 but the file was saved as ANSI/Windows-1252 (or the reverse). Reopen with the correct encoding in Notepad++/VS Code and Save As UTF-8.

• Huge files — hundreds of MB can freeze Notepad and strain casual viewers. Use Excel Power Query / Get Data, VS Code with patience, or a streaming XML tool—never rely on Notepad alone.

• Wrong expectation — incomplete downloads, HTML renamed to .xml, or password-wrapped exports that aren’t plain XML.

 

Work on a copy. If Excel fails on the full file, carve a small valid sample (first few records) to confirm the structure before trying conversion tools.

How to convert an XML file to Excel, CSV, or PDF

Most non-technical users don’t want to study tags—they want the numbers in a sheet or a printable page.

1. Open Excel → File → Open the .xml → select As an XML table (or Data → Get Data → From XML).

2. Review headers, delete helper/junk columns, set number/date formats.

3. File → Save As → Excel Workbook (.xlsx) or CSV (Comma delimited).

4. For a printable snapshot: File → Print → Microsoft Print to PDF (or Export → Create PDF/XPS where available).

 

Online “XML to Excel” converters exist, but avoid uploading payroll, medical, or customer dumps to random sites—use desktop Excel/WPS on a local copy instead.

Another option: clean and export the table in WPS Spreadsheets

After you’ve imported XML into a grid—or when Microsoft Office associations are messy—open the workbook in WPS Office Spreadsheets. Filter and chart the fields in a familiar sheet layout, then Save As .xlsx or CSV for analysis, or print/PDF when stakeholders want a static copy.

That path helps mixed Windows/Mac teams keep moving without waiting on one Office build, and the free tier covers everyday spreadsheet cleanup when you don’t need a Microsoft 365 subscription just to turn tagged data into a usable table.

 

Need a universal way to open office files? See our free online file opener for PDF, Word, Excel, PPT, and more formats.

FAQ

Can I open an XML file in Microsoft Excel?

Yes for many tabular exports. Use File → Open and choose As an XML table, or Data → Get Data → From File → From XML, then Save As .xlsx.

Can Chrome or Edge open an XML file?

Yes. Drag the file into the browser or use Open. Well-formed indented XML often shows a collapsible tree; minified XML may appear as one line.

Is Notepad enough to open XML?

For tiny files, yes. For nested data, use Notepad++, Microsoft XML Notepad, or VS Code so you can fold nodes and search tags.

Why does my XML look like gibberish or mojibake?

Usually an encoding mismatch (UTF-8 vs ANSI). Reopen with the correct encoding in Notepad++ or VS Code and save as UTF-8.

How do I convert XML to CSV or Excel without coding?

Import as an XML table in Excel (or tidy in WPS Spreadsheets), then Save As .xlsx or CSV. Use Print to PDF only when you need a static printout.

What’s the difference between a .xml file and a .docx/.xlsx “Open XML” file?

A plain .xml is tagged text. Office Open XML (.docx/.xlsx) is a ZIP package of many XML parts plus media—open those with Word/Excel/WPS, not as a single text dump.

Summary

To open an XML file, match the app to the job: Excel for tables, Chrome/Edge for a quick tree, Notepad for a tiny peek, and Notepad++/XML Notepad/VS Code when you need fold and highlight. If the file won’t open, check syntax, encoding, and size before assuming it’s lost. Convert by importing to a sheet and saving .xlsx / CSV (or Print to PDF). When you need a lightweight spreadsheet follow-through, tidy and export the table in WPS Spreadsheets.

Free Office Download

• Use Word, Excel, and PPT for FREE, No Ads.

• Edit PDF files with the powerful PDF toolkit.

• Microsoft-like interface. Easy to learn. 100% Compatibility.

• Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

Free Download

100% secure

Algirdas Jasaitis