Excel to XML
- Started
- Last post
- 7 Responses
- youngdesigner
Is it possible to convert an Excel spreadsheet to XML? What's the best way to do this?
- bulletfactory0
yup. "Save as" XML.
- youngdesigner0
It's not that simple...looks like I need to map the entires to XML somehow
- vaxorcist0
there's XML, and.... there's XML....
save-as XML will give you what Microsoft thinks is the XML tagset... which may not be at all what you want....
If you want to map the entries to XML tags, like the top-line of each row being the sub-entity, that's probably a small PHP script to write output from a tab-separated export from Excel... I'm sure somebody has written this somewhere... it's probably a 2 hour job or so..
i.e.
to row looks like: (\t = ta)_
ID /t Name /t Rankand the XML you want looks like:
<employee>
<id>111</id>
<name>joe smith</name>
<rank>vice president</rank>
</employee>etc...
- youngdesigner0
thanks vaxorcist...online converter turned out to be the way to go
- vaxorcist0
what was the URL of the online converter?
- youngdesigner0
http://xmlgrid.net/csvToXml.html…
Looks like there are a bunch of them
- vaxorcist0
yes, that's pretty much what I was thinking....
- only issue is how to deal with extra commas, like George Smith, MDvaxorcist
- just tell George to get off his high horse.bulletfactory