Google Answers Logo
View Question
Q: Convert from XML into tab-delimited text ( Answered 5 out of 5 stars,   1 Comment )
Subject: Convert from XML into tab-delimited text
Category: Computers > Software
Asked by: daveamazon-ga
List Price: $5.00
Posted: 24 May 2003 16:08 PDT
Expires: 23 Jun 2003 16:08 PDT
Question ID: 208224
How can I convert an XML file into tab-delimited text?  Please note I
do not need to convert from tab-delimited text into XML.  I have an
XML doc (only format that was available to me) and I need to convert
it to some kind of delimited text file.
Subject: Re: Convert from XML into tab-delimited text
Answered By: errol-ga on 24 May 2003 18:58 PDT
Rated:5 out of 5 stars
Hi there, Daveamazon!

After many hours of looking through a Google search, I managed to find
a program which will do exactly what you need.

I have installed several program trials, most of which didn't work at
all, even Adobe InDesign 2.0 would not do the task that you needed.
The only one which did is called "ParseRat", a slightly tricky to use
application which does the job.
Download the trial from here:

The interface is very confusing and sometimes the text will be
obscured but the basic way to perform the operation is like this:

- Run the program
- Click OK on the username/password box
- Click the Open button on the top left
- Select your xml file
- Click the Output tab
- Select Tab Delimited
- Click the Output button on the top left
- Save as "filename.txt" (remember to include the .txt extension)

And that's it!
You will have to play with the settings a bit to make it perfect, you
can make it output the field names too if you would like to.

I hope this helps.
Kind regards,

Related Google searches:

"xml to tab delimited text"

Request for Answer Clarification by daveamazon-ga on 25 May 2003 08:53 PDT
I have tried several times to get ParseRat to function correctly, so
far without success.  It seems to import the XML file but will not
export the data correctly.  Thanks for your research but I still need
a solution.

Clarification of Answer by errol-ga on 25 May 2003 09:15 PDT
Hi there.

It worked fine for me.
I think there was a button called "copy all fields" that you have to
click on the bottom right first to copy the data to the output window
before you click the Output button.


Request for Answer Clarification by daveamazon-ga on 25 May 2003 12:20 PDT
Couldn't find the "copy all fields" button.

Here is the actual XML file I'm trying to convert:


Clarification of Answer by errol-ga on 25 May 2003 12:47 PDT
Hello again.

I've got the file.
I'll convert it for you then post the link.


Clarification of Answer by errol-ga on 25 May 2003 16:59 PDT
Hello there!

I successfully changed it into Tab Delimited text for you.
However, the file size limit for my GA Hotmail account is 1MB so I'll
have to post the URL here. (3.3MB)

And also, CSV & Excel: (3.3MB) (1MB)

To convert the file, I simply used Excel (Office XP) which did a fine
job of the conversion.

Kind regards,
daveamazon-ga rated this answer:5 out of 5 stars and gave an additional tip of: $5.00
Great researcher--Thanks!

Subject: Re: Convert from XML into tab-delimited text
From: errol-ga on 27 May 2003 21:17 PDT
Thank you for your kind generosity!

For your information, I will delete the files from the web server in
about two days.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy