Demo step-by-step for how to load XML files into MS Excel and format as table. XML Source Pane provides ability to map XML hierarchy objects into Table rows and columns. Also includes www.xmllint.com, special characters, and empty Table Refresh steps.
Cheers.
https://www.spjeff.com/2024/12/26/xml...
https://learn.microsoft.com/en-us/pre...)