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.

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.

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.