Why so complicated? Just open the File with File->Open choose xml and load it. See what'll happen.

Answer from Friedrich on Stack Overflow
๐ŸŒ
Microsoft Support
support.microsoft.com โ€บ en-us โ€บ office โ€บ import-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4
Import XML data - Microsoft Support
If you're using Excel 2016 or earlier, click Data > From Other Sources > From XML Data Import. Go to the drive, folder, or Internet location that has the XML data file (.xml) you want to import.
๐ŸŒ
Conversion Tools
conversiontools.io โ€บ convert โ€บ xml-to-excel
XML file to Excel Converter Online | Convert XML to spreadsheet
We accept any well-formed XML file regardless of schema or structure. The converter supports all character encodings, with UTF-8 being the most common. Large XML files are processed efficiently. XLSX (default): Modern Excel format for Office 2007 and later. Supports up to 1,048,576 rows and 16,384 columns.
Discussions

Translate XML-File into Excel-Table and back again
Easiest way to load XML data into Excel is to use Power Query . Data > Get Data > From File > XML. Excel also has a built-in way under Developer > Export to export to XML if you have fewer than 65k rows. More on reddit.com
๐ŸŒ r/excel
9
12
August 12, 2022
Transform XML data in excel
I have an xml file that when I import in to excel presents the data as such Fieldname1A2B3C4A5B6C7A8B9CHow can I transform this to ABC123456789 More on learn.microsoft.com
๐ŸŒ learn.microsoft.com
5
0
April 16, 2025
Quick convert XML to Excel - Stack Overflow
What is the quickest (as in least effort, not super performance) way to convert 112K rows in XML to a Excel view. More on stackoverflow.com
๐ŸŒ stackoverflow.com
Convert xml to excel/csv
Please help me in converting XML file into excel/csv. Thank you in advance. More on discuss.python.org
๐ŸŒ discuss.python.org
0
0
October 15, 2022
People also ask

Can XML file be converted to Excel?
Yes, this is easy with our unique Free XML to Excel Online Converter.
Steps to Convert XML to Excel:
  • Upload XML file
  • Click 'Run Conversion' button
  • When the file is converted - download Excel file
๐ŸŒ
conversiontools.io
conversiontools.io โ€บ convert โ€บ xml-to-excel
XML file to Excel Converter Online | Convert XML to spreadsheet
How do I open an XML file in Excel?
First, convert XML to Excel format using our Free XML to Excel Online Converter.
Steps to use XML to Excel Converter:
  • Upload XML file
  • Click 'Run Conversion' button
  • When the file is converted - download Excel file
  • Open Excel file in Microsoft Excel
๐ŸŒ
conversiontools.io
conversiontools.io โ€บ convert โ€บ xml-to-excel
XML file to Excel Converter Online | Convert XML to spreadsheet
๐ŸŒ
Kaltura
knowledge.kaltura.com โ€บ help โ€บ how-to-convert-an-xml-document-to-csv-file-or-excel-spreadsheet
Convert API XML output to CSV or Excel | Kaltura Knowledge Center
Choose where to save the file and click Save. OpenExceland clickFilein the ribbon bar. ChooseOpen, thenBrowseto locate the file saved in the previous step. Select the file and clickOpen. A pop-up box displays. Choose As an XML table and click OK.
๐ŸŒ
Microsoft Learn
learn.microsoft.com โ€บ en-us โ€บ answers โ€บ questions โ€บ 5450821 โ€บ transform-xml-data-in-excel
Transform XML data in excel - Microsoft Q&A
April 16, 2025 - Select your XML file and import it. Once the data is loaded in a table format, click on Transform Data to open Power Query. Select the "Field" column. Click Transform โ†’ Pivot Column.
๐ŸŒ
DataConverter
dataconverter.io โ€บ convert โ€บ xml-to-xlsx
Convert XML to Excel Online - DataConverter.io
Use our free online tool to convert your XML data to Excel 2007+ (.xlsx) quickly
Find elsewhere
๐ŸŒ
Wikihow
wikihow.com โ€บ computers and electronics โ€บ software โ€บ file manipulation โ€บ how to convert xml data files to excel: 2 easy methods
How to Convert XML Data Files to Excel: 2 Easy Methods
March 10, 2025 - If you want to save the file as an Excel XLSX file, choose Excel Workbook from the "Save as type" or "File Format" menu. You can choose any of the formats in the list, including CSV (Comma Delimited).
๐ŸŒ
Excel Easy
excel-easy.com โ€บ examples โ€บ xml.html
Convert XML to Excel - Step by Step Tutorial
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <data-set xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <record> <LastName>Smith</LastName> <Sales>16753</Sales> <Country>UK</Country> <Quarter>Qtr 3</Quarter> </record> <record> <LastName>Johnson</LastName> <Sales>14808</Sales> <Country>USA</Country> <Quarter>Qtr 4</Quarter> </record> </data-set> Note: the tags refer to the column names, but you can give them any name you want!
๐ŸŒ
MaxAI
maxai.co โ€บ file-tools โ€บ xml-to-excel
XML to Excel - Convert a XML to Excel Online for Free | MaxAI
Convert XML to Excel online for free. Effortlessly transform your XML data to Excel format for seamless integration and compatibility. No file size limits, downloads, or sign-ups required.
Top answer
1 of 5
28

Why so complicated? Just open the File with File->Open choose xml and load it. See what'll happen.

2 of 5
6

If you're using Excel 2007 and want to use XSLT, your best bet would probably be use the EXPath Zip Module features to modify an existing Excel .xslx file.

My preferred option, however, would be to use a small Excel VBA Macro.

I've included sample code below for a VBA procedure called 'load' - this sample uses the XML DOM, so all 112K rows of your XML will be first loaded into memory, but if performance isn't an issue its simpler than the SAX alternative.

You would need to modify xpathToExtractRow to suit your XML input structure. There is also an assumption that the immediate child nodes of the XML row element contain the cell data you wish to import as text nodes, if not, you will need to use a SelectNode call to get the data you require.

Private dom As DOMDocument60

Public Sub load()

Dim nodeList As IXMLDOMNodeList
Dim nodeRow As IXMLDOMNode
Dim nodeCell As IXMLDOMNode
Dim rowCount As Integer
Dim cellCount As Integer
Dim rowRange As Range
Dim cellRange As Range
Dim sheet As Worksheet

Dim xpathToExtractRow As String
xpathToExtractRow = "/feed/row"

Set dom = New DOMDocument60
dom.load ("c:\test\source.xml")
Set sheet = ActiveSheet
Set nodeList = dom.SelectNodes(xpathToExtractRow)

rowCount = 0
For Each nodeRow In nodeList
    rowCount = rowCount + 1
    cellCount = 0
    For Each nodeCell In nodeRow.ChildNodes
        cellCount = cellCount + 1
        Set cellRange = sheet.Cells(rowCount, cellCount)
        cellRange.Value = nodeCell.Text
    Next nodeCell
Next nodeRow

End Sub

Sample Input XML:

<?xml version="1.0" encoding="utf-8"?>
<feed>
  <row>
    <firstname>joe</firstname>
    <lastname>smith</lastname>
    <country>jamaica</country>
  </row>
  <row>
    <firstname>bill</firstname>
    <lastname>coots</lastname>
    <country>uk</country>
  </row>
</feed>
๐ŸŒ
Python.org
discuss.python.org โ€บ python help
Convert xml to excel/csv - Python Help - Discussions on Python.org
October 15, 2022 - Please help me in converting XML file into excel/csv. Thank you in advance.
๐ŸŒ
Table Convert
tableconvert.com โ€บ home โ€บ convert xml to excel online
Convert XML to Excel Online - Table Convert
January 14, 2026 - Convert XML to Excel online with our free online table converter. XML to Excel converter: convert XML to Excel in seconds โ€” paste, edit, and download Excel. Need to convert XML to Excel for an API, spreadsheet, or documentation? This online table converter keeps your data private in your browser.
๐ŸŒ
Indeed
indeed.com โ€บ career guide โ€บ career development โ€บ how to convert xml to excel in 4 steps (plus tips)
How To Convert XML to Excel in 4 Steps (Plus Tips) | Indeed.com
June 28, 2024 - Converting XML to Excel can make working with and analyzing that data easier for people.Excel works with two primary forms of XML files, the XML schema file (.xsd) and the XML data file (.xmd), when converting data. You can add the .xsd schema file to an Excel worksheet to create an XML map that helps manage and organize the XML data.
๐ŸŒ
Trump Excel
trumpexcel.com โ€บ home โ€บ how to import xml file into excel | convert xml to excel
How to Import XML File into Excel | Convert XML to Excel
September 29, 2023 - The above steps would insert a new worksheet in the Excel file, and load all the data from the XML file into the new worksheet. And again, in case the data updates in this URL, simply refresh the query to get the new data in Excel. So these are two simple ways that you can use to convert an XML file into Excel.
๐ŸŒ
Alteryx Community
community.alteryx.com โ€บ t5 โ€บ Alteryx-Designer-Desktop-Discussions โ€บ XML-to-Excel โ€บ td-p โ€บ 1162329
Solved: XML to Excel - Alteryx Community
December 14, 2023 - If you are wanting to get the xml into Excel with each line of code on a separate row, you can use the top method in the workflow. If you'd like to see all of the code in a single cell, you can use the second output in the workflow. This, however, will only work with small xml files due to Excel's character limit in a cell.
๐ŸŒ
ConvertCSV
convertcsv.com โ€บ xml-to-csv.htm
XML To CSV Converter
Convert XML to CSV and XML to Excel Spreadsheet
๐ŸŒ
Easydatatransform
easydatatransform.com โ€บ convert_xml_to_excel.html
Convert XML to Excel offline on Windows or Mac
Ensuring the pink input item is selected, click the To File button in the Left pane (scroll to the bottom of the Left pane). A window will appear. Set the new file name and location.
๐ŸŒ
CoolUtils
coolutils.com โ€บ online โ€บ xml to xls
XML to Excel Converter - Transform Data Files
If you have an XSLT file, you can add to to the app for the right transformation. Convert XML in 3 ways: expand to table form, highlight XML tree or create a report.
Rating: 4.9 โ€‹ - โ€‹ 1.66K votes
๐ŸŒ
Udemy
blog.udemy.com โ€บ home โ€บ how to convert data in excel to xml in 7 easy steps
How To Convert Data in Excel to XML in 7 Steps - Udemy Blog
October 24, 2025 - Itโ€™s widely used across the internet and in many software environments. You can convert XML to Excel by using Excelโ€™s built-in โ€œGet Dataโ€ feature or the โ€œImportโ€ button on the Developer tab.