Connect to an XML file

  1. In the POWER QUERY ribbon tab, click From File > From XML.
  2. In the From XML Browse dialog box, browse for or type a file URL to import or link to a file.
  3. Click Open.

After the connection succeeds, you will be able to use the Navigator pane to browse and preview the collections of items in the XML file in a tabular form.

You can download the sample XML file to practice how to connect to an XML file.

Formula Example

= Xml.Tables(File.Contents("C:\Downloads\XML Example.xml"))

Applies to:
Excel 2013, Excel 2010