Convert XML to Excel
1. Open excel and go to “Data” tab.
2. From “Data” tab, go to “Get Data” > From File > From XML.
3. Select the XML file to convert and click “Transform data” once the file is loaded. In Power Query Editor > Click on the arrow sign on the column name to transform the column name.
4. Once the data is transformed, click “Close and Load”.