Tools to convert XML to csv, txt, or excel

Dear all,

  is there any simple to use freeware or shareware that can convert XML data to CSV or Txt file?

Thank you!
cuconsortiumAsked:
Who is Participating?
 
sshah254Commented:
Excel can import XML files.

Once you have it in Excel, you can export it to text or csv (it will depend on the format of the data).

Ss
0
 
cuconsortiumAuthor Commented:
when I convert it in Excel.  Excel is eliminating the preceeding "0"s in the numbers.  how do i preserve these "0"s ?

Thank you!
0
 
sshah254Commented:
If excel detects it as numbers, it will remove the preceding 0s.

You'll have to somehow convert these numbers to text by encapsulating them within double quotes.

Or if you have the XSD (the schema definition file) for the XML, then you should be able to change the datatype in the XSD.

Upload a sample if you can.

Ss
0
 
mbatuchicCommented:
Here is a freeware that can convert data from lots of sources to excel.  Let me know if it worked.

http://www.cogniview.com/pdf2xl-enterprise.php?gclid=CIeQrNK6z6cCFYTr7QodLFHDsQ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.