Convert xml to xls?

J

Jie

Hi all,

does anyone know about an open-source tool or method that can convert
a certain xml file to a spreadsheet (e.g. xls)? Can one import xml
data in the OpenOffice program Calc? The problem is that the original
xml file can be very long and the digit precision of some data fields
is strictly required. Thanks a lot!


Jie
 
H

Hermann Peifer

Hi all,

does anyone know about an open-source tool or method that can convert
a certain xml file to a spreadsheet (e.g. xls)? Can one import xml
data in the OpenOffice program Calc? The problem is that the original
xml file can be very long and the digit precision of some data fields
is strictly required. Thanks a lot!

Jie

One idea would be to transform the XML document into a csv file and
import the csv file into your favourite spreadsheet application.

Hermann
 
P

Peter Flynn

Jie said:
Hi all,

does anyone know about an open-source tool or method that can convert
a certain xml file to a spreadsheet (e.g. xls)? Can one import xml
data in the OpenOffice program Calc? The problem is that the original
xml file can be very long and the digit precision of some data fields
is strictly required. Thanks a lot!

This was one of the first demos for XML conversion I wrote, before XSLT
appeared. It runs awk on the ESIS output of onsgmls and produces CSV.

http://silmaril.ie/downloads/software/xml2csv/xml2csv.zip

Bear in mind this is a proof-of-concept, not a production tool.

///Peter
 
Joined
Jun 2, 2011
Messages
1
Reaction score
0
i had the same problem of trying to convert a really long large xml file to something i can view in excel. This is what i did:

1. changed the extension to .csv (not xls, that didn't work)
2. opened excel and opened the file

i know the columns aren't quite right, but this is a much quicker way to view the data.
 
Joined
Nov 28, 2011
Messages
1
Reaction score
0
If you have MS Access, import the XML to access, then export as XLS. CLose to zero effort and fully formatted. Watch out for fields that have incorrect type (such as importing to Text format instead of memo format and so on). Any import errors will show up in the Import Error table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top