Unable To Expand XML Table In Excel Power Query Editor

[alteredstate]

Hello Everyone!

I'm unable to expand the Table.packages column in Excel Power Query Editor from an imported XML file. Would anyone know how I could expand the Table.packages column? For some reason I'm not allowed to upload the XML text file that I am using.

XML Screenshot.png

[alansidman]

To upload your XML file, you will first need to zip it and then you will be able to upload it.

[alteredstate]

To upload your XML file, you will first need to zip it and then you will be able to upload it.

Thank you! I uploaded the XML file.

[Haluk]

@alteredstate, try the below VBA code to import the package names as shown in the below image;

Note: The code imports the names of 13220 packages in total. (XML file must be in the same folder with the Excel file)

Please Login or Register  to view this content.