https://www.freeformatter.com/xpath-tester.html
From BIP data model, goto CODE tab and select the xml string and paste it above website (option 1)
In XPath expression type the following:
/output/nodeList/dataStructure/group/element/@name
Make sure to uncheck ‘Include XML Item Type in output’
To get XPath, start from bottom (or last lines) of XML
Another website to get XPath from XML is https://codebeautify.org/Xpath-Tester or https://xpath.curiousconcept.com/
Take the output and store it in text file. Then load that text file into Excel worksheet. While loading (or after loading) replace text name= with null
Copy all the cell and then in the same worksheet, paste the data using excel TRANSPOSE feature.
You now have all the table columns.
Delete all the other rows (of original data) and start your BIP excel template work.
Nasar's Blog 