XML Data

J

Jcraig713

Is there any way to create a program to turn data I may be viewing as an xml
list in excel, to return a record where all attributes of the record are in
ONE record row. I have an xml file where the data many times is displayed
across several rows in excel. Trying to sort on the data then becomes
extrememly problematic. I would like to view the xml data in excel like I
could when importing a txt file. Is this possible using xml in excel?
 
J

jason

Is there any way to create a program to turn data I may be viewing as an xml
list in excel, to return a record where all attributes of the record are in
ONE record row.  I have an xml file where the data many times is displayed
across several rows in excel.  Trying to sort on the data then becomes
extrememly problematic.  I would like to view the xml data in excel like I
could when importing a txt file.  Is this possible using xml in excel?

try using the SPLIT function with < and > or use MID while looping
through the text.
could you share some sample data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top