4 min read
Open and edit an XML file in Excel (without coding)
Excel can "open" an XML, but the result is often unreadable or breaks the file's structure. Here's a reliable way to edit any XML in a spreadsheet and get it back intact.
Why Excel's native open is a problem
When you open an XML directly in Excel, it tries to guess the structure and often offers a confusing schema mapping. For even slightly complex XML (nested elements, attributes, repetitions), the result is unusable and, crucially, you won't be able to regenerate the original file.
The real need isn't just opening the XML: it's editing it AND rebuilding it identically so you can reuse it.
The reliable method
- Drop your XML file on ExcelifyXML.
- Get a clean CSV, where the XML hierarchy is flattened into readable columns.
- Open it in Excel, Numbers or Google Sheets and edit whatever you need.
- Rebuild the original XML in one click — the algorithm restores the exact structure, attributes and order.
Which XML files are supported?
- E-commerce feeds (Google Shopping, PrestaShop, WooCommerce, Magento)
- PIM exports (Akeneo, Salesforce Commerce Cloud)
- RSS files, sitemaps, various business exports
- UTF-8, UTF-16, ISO-8859-1, Windows-1252 encodings (auto-detected)
Security and privacy
No file is kept: processed in memory on European servers then deleted immediately. DOCTYPE/ENTITY declarations are blocked (XXE attack prevention), and CSV formula injection is neutralized.
Open your XML file in Excel now:
Transform a file