Solved

Tools to convert XML to csv, txt, or excel

Posted on 2011-03-14
4
661 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
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 …

914 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now