How to parse (encoded)data from xml to exel

Question

Hi, I have an xml file where I have a structure in which some of the data is encoded. When I convert the xml file into excel file, the column for the encoded data is presented by the URL. Is there any way I can parse that data into actual data for anylizing.

tnx.

Answer 1

I'm not exactly sure what you mean by "the encoded data is presented by the URL". Can you give more details or maybe show an example?
How do you perform the conversion to an excel file?

Either way, you can import data into excel using a selected encoding (from office 2003 and forward). That may help with your problem.