Solved

Tools to convert XML to csv, txt, or excel

Posted on 2011-03-14
4
670 Views
Last Modified: 2012-05-11
Dear all,

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

Thank you!
0
Comment
Question by:cuconsortium
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
sshah254 earned 500 total points
ID: 35134580
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
 

Author Comment

by:cuconsortium
ID: 35134598
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
 
LVL 9

Expert Comment

by:sshah254
ID: 35134644
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
 

Expert Comment

by:mbatuchic
ID: 35134652
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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question