CSV to XML converter
Flash supports XML. Consultants and project managers support Excel. Have you ever wished that either Excel or any other spreadsheet application, or any other application for that matter, had a decent exporter for XML data? Not that proprietary-Microsoft-not-terribly-W3C-compliant-type, but real, simple, proper XML? Well I have, and instead of waiting for it I decided to create a small Flash application that certainly helps!
Not many desktop applications export XML at all, but make that CSV (Comma Separated …something) and quite a few do. A typical CSV export from an Excel spreadsheet could look like this:
Now wouldn’t you much rather have that data formatted a little more like this?
Nice and tidy – and best of all; Flash supports it natively!
No more talk. Head here: http://www.oyvindnordhagen.com/flashdev/csvtoxml/
how about:
name,address,keywords
John Doe, “myaddress, NY, US”, “non, ongo, nes”
Yeah, that would not work very well. But you could do a search/replace and swap all the commas in the spreadsheed to i.e. “>” and then swap them back again once the XML is created.