Highlight the data file and then click "Import" to map the data directly to the spreadsheet under the table information, recreating the XML table within your Excel spreadsheet.

Learn how to open an XML File in Excel, Word, Chrome, and Edge on a Windows computer using the methods mentioned in this post.

Excel pro tips: Importing and parsing data When data dumps into your spreadsheet and it's a big mess, you'll know what to do.