In this video we use Power Query (sometimes known as Get & Transform) to import an XML file into Microsoft Excel. This supports nested XML files, and the query can even be reused with another XML file as long as it has the same structure and element names.