Tools to convert XML to csv, txt, or excel

Posted on 2011-03-14
Medium Priority
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!
Question by:cuconsortium
  • 2

Accepted Solution

sshah254 earned 2000 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).


Author Comment

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!

Expert Comment

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.


Expert Comment

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


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

600 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