Free online XML converter
XML to Excel Converter – Convert XML to XLSX
Turn an XML file into an Excel spreadsheet (.xlsx). Choose which entries become rows, include nested fields and attributes as columns, and check the preview before downloading.
Convert XML to Excel
Your XML data
XML structure preview
Field names onlyChoose the XML entries you want as rows in Excel.
If your XML uses namespaces, you may see names like ns1:Item. These help keep different fields separate.
Excel preview
How to Convert XML to Excel Online
Choose an XML file or paste its contents. Select which entries should become rows, then choose one worksheet or separate worksheets for all detected groups. Click Convert XML to Excel, check the preview, and download your .xlsx file. Nested fields and XML attributes can become columns, while values such as 00123 stay as text.
Your XML file stays in your browser
The converter reads your XML, builds the spreadsheet, and creates the XLSX download on your device.
Processed locally
Your XML file is read and converted right here in this browser tab.
No account required
No account, email address, or payment details required.
Your information stays private
Your XML elements, attributes, and values are not sent to our servers.
How to Convert XML to XLSX
Choose or paste XML
Select an .xml file from your device or paste XML data into the input area. You can also try the built-in sample.
Choose the records
Choose the entries you want as Excel rows. You can put different groups of entries on separate worksheets.
Convert and download
Click Convert XML to Excel, check the worksheet preview and any data warnings, then download your XLSX workbook.
Convert a Single XML Record to Excel
Even if your XML contains just one product, you can turn it into one Excel row. In this example, the product ID, name, and price become three columns.
XML input
<products>
<product id="00123">
<name>Keyboard</name>
<price>49.99</price>
</product>
</products>Excel worksheet: products
| @id | name | price |
|---|---|---|
| 00123 | Keyboard | 49.99 |
Download the XML sample file to try it in the converter.
Convert Multiple XML Tables to Separate Excel Sheets
If your XML contains products and categories, choose All detected groups under Worksheets to create. The example below creates one worksheet for two products and another for two categories.
XML with two record groups
<catalog>
<products>
<product id="00123">
<name>Keyboard</name>
<price currency="USD">49.99</price>
</product>
<product id="00124">
<name>Mouse</name>
<price currency="USD">25.00</price>
</product>
</products>
<categories>
<category id="c1"><title>Accessories</title></category>
<category id="c2"><title>Office</title></category>
</categories>
</catalog>Excel workbook output
XML to Excel Formats and Limits
The converter creates a standard XLSX workbook. XML values are written as text so product codes, identifiers, and date-like strings are not automatically reinterpreted as numbers or dates.
| Input | XML file or pasted XML text |
|---|---|
| Output | Excel workbook (.xlsx) |
| Maximum XML file size | 10 MB |
| XML structure | Up to 100,000 elements and 128 levels of nesting |
| Maximum cells in one workbook | 2 million, including cells in all worksheets |
| Rows per worksheet | Up to 1,048,576 rows, including the header row |
| Columns per worksheet | Up to 16,384 columns |
| Data groups | Up to 12 listed automatically; export one or all listed groups |
| Nested elements | Can be flattened into columns |
| XML attributes | Included as columns when enabled |
| Cell values | XML text and attribute values are kept as text |
| Privacy | Processed locally in your browser; no account required |
How XML Elements Become Excel Columns
XML often stores details inside other details. Choose which XML entries should become Excel rows, and the converter can place their names, values, and attributes in separate columns.
Repeated records become rows
Each product entry in a list of products can become its own row in Excel.
Nested fields become columns
A nested value such as address.city can become one column. You can change the separator used in column names.
Attributes become columns
An attribute such as id="00123" becomes @id. Attributes on nested elements use the parent path, such as price.@currency.
Similar field names stay separate
When fields belong to different XML namespaces, labels such as ns1:id and ns2:id help keep their values in separate columns.
What XML Information Is Preserved in Excel?
Excel stores rows and columns, so it cannot keep every detail of an XML document. Here is what stays the same and what may change.
| XML content | What happens in Excel |
|---|---|
| Element text | Written as text in a cell. Leading zeros and date-like strings are not automatically converted; surrounding whitespace is trimmed. |
| Attributes | Added as columns when Include XML attributes is selected. |
| Nested elements | Flattened into column names when Show nested fields as columns is selected. |
| Repeated simple values | Joined in one cell with a vertical bar by default. You can choose to keep only the first value. |
| Repeated nested items | Several items may be combined into one Excel row instead of appearing on separate rows. |
| XML namespaces | Labels such as ns1 and ns2 keep fields with the same name in different namespaces from being mixed together. |
| Text mixed with nested elements | Text and nested values become separate columns. Their original reading order is not kept. |
| Comments, formatting, and element order | Not preserved in the spreadsheet. Keep the original XML if these details matter. |
The converter does not check your XML against a schema, preserve XML-only formatting, or add formulas to your Excel file.
Import XML into Excel with Power Query or an Online Converter
Excel can import XML directly. Choose the method based on whether you need a quick one-time spreadsheet or a repeatable data-import workflow.
Microsoft Excel Power Query
- Open Data → Get Data → From File → From XML in supported desktop versions.
- Use the Navigator to inspect available collections and preview the data.
- Better suited to repeatable imports and refreshable data workflows.
- Offers additional transformation options for more complex sources.
This XML to Excel converter
- Useful for a quick XML to XLSX conversion without installing software.
- Choose one detected record group or export all detected groups.
- Preview flattened columns and attribute values before downloading.
- Processes the source XML locally in your browser.
For more ways to open XML directly in Excel, see Microsoft's XML import guide.
Common XML to Excel Conversion Issues
| What you see | What to check |
|---|---|
| The wrong records appear as rows | Choose another option under Data to turn into rows, or enter a different XML path (advanced). |
| Nested values appear in one cell | Turn on Show nested fields as columns and convert again. |
| An attribute column is missing | Turn on Include XML attributes. |
| Repeated values are combined | This is the default behavior. Review the warning or choose Keep the first value only if that is what you need. |
| Two fields have similar names | Labels such as ns1:id and ns2:id indicate fields from different XML namespaces. |
| The XML cannot be read | Check that every opening tag has a matching closing tag, special characters are escaped, and the document has no DOCTYPE declaration. |
| The file exceeds a limit | Split the XML into smaller files or export one record group at a time. |
XML to Excel Converter FAQ
How do I convert XML to Excel online?
Choose an XML file or paste XML text. Select which data should become Excel rows, choose one or multiple worksheets, and click Convert XML to Excel. Check the preview and download your XLSX file.
Can I convert XML to XLSX?
Yes. The converter creates an .xlsx workbook that you can open in Microsoft Excel, Google Sheets, Apple Numbers, and other spreadsheet apps.
Can it convert an XML file that contains only one record?
Yes. Even one product can become a row in Excel. If it does not appear in the list, enter its location in the XML path (advanced) field.
Can nested XML become Excel columns?
Yes. With Show nested fields as columns enabled, nested values can become columns such as address.city and address.zip. You can change the separator used in column names.
Can XML attributes become Excel columns?
Yes. Keep Include XML attributes selected to add attributes as columns. An attribute such as id appears as @id, while an attribute on a nested element can appear as price.@currency.
Can I convert multiple XML tables into separate worksheets?
Yes. Under Worksheets to create, choose All detected groups to put each type of record on its own worksheet. Choose Selected group (one worksheet) if you only need one table.
Does the converter preserve leading zeros and date-like values?
XML text and attribute values are written to Excel as text. Values such as 00123 and 03/04/2026 are not automatically changed into numbers or dates.
What happens when an XML element appears more than once?
By default, repeated values with the same name are joined in one cell using a vertical bar. You can instead keep only the first value, but the other values will be omitted. Repeated nested objects may lose their original row relationships when flattened.
Does it support XML namespaces?
Yes. If different XML namespaces use the same field name, the converter keeps them in separate columns using labels such as ns1:Item and ns2:Item.
What are the XML file and workbook limits?
The XML input can be up to 10 MB and contain up to 100,000 elements with a maximum nesting depth of 128. Up to 12 groups are listed automatically; for other data, enter its XML path manually. The workbook is limited to 2 million cells in total, 1,048,576 rows per worksheet including the header, and 16,384 columns per worksheet.
Is my XML file uploaded to a server?
No. XML parsing and XLSX generation run in your browser. The source XML is not uploaded to our servers.
Can I import XML into Excel without an online converter?
Yes. Supported desktop versions of Excel can import XML through Data, Get Data, From File, and From XML. Power Query is useful when you want to inspect, transform, or refresh data from a source.
Related Data Converters
Ready to convert XML to XLSX?
Choose an XML file or paste your data, review the records, and create your Excel workbook in your browser.