English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I have a XML file that needs to be converted to a CSV or Excel file, while retaining the intended table format. Does anyone know of a free utility that I can download, or VB code that I can use in Excel or VB 2006 Express to accomplish this, or at least get me started?
*I'm currently using Excel 2003 Standard. I understand that if I had 2003 PROFESSIONAL, that version has a built-in feature that would import an XML file and retain the formatting. Excel 2003 Standard imports the XML data, but doesn't keep the table format. It just imports the whole table into one cell, so it's kinda worthless in that respect.
I'd appreciate ANY help that you guys can possible offer. Google searching hasn't provided me with any straightforward answers so far...

2006-09-29 09:01:26 · 2 answers · asked by TruthIsFreedom 3 in Computers & Internet Programming & Design

2 answers

Check this one http://www.ricebridge.com/xml-csv-convert.htm
and this
http://rustemsoft.com/XMLConverter.htm
Hope it helps, shall lookup more and post if I get it!

You are right Excel Professional has the feature however if you dont have it then its no good.

2006-09-29 09:32:22 · answer #1 · answered by Prashant P 1 · 1 0

Use Excel to open the XML file. From there you can save it into XLS format or CSV format.

2006-09-29 16:07:09 · answer #2 · answered by steve 6 · 0 1

fedest.com, questions and answers