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