How to import XML files into Microsoft Excel (Tested with Microsoft Excel 2016):

1. Open a blank Excel workbook

2. In the Data tab, click "From Other Sources" and then "From XML Data Import".

3. Choose the xml file to be imported and click Open button

4. In the next error or warning window, click OK button

5. In the "Import Data" window, click OK button