B] Open XML file using the Data menu (Import Excel) This method involves loading the data from an XML document using Power Query , which is a powerful data automation tool found in Excel. Open MS ...

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. Advertisement ...

In this guide, we’ll not only show you how to export and import Excel files to and from Numbers, but we’ll also show you how you can spot and fix issues that often occur when you do.