Note: An XML file contains data that’s been arranged ... This method involves loading the data from an XML document using Power Query, which is a powerful data automation tool found in Excel.