xml to csv

Posted by joy


Does anyone know of an app that will convert XML files to CSV?

And no, I do not have access to the latest version of Microsoft Office. And Open Office could do it, but I’d be forced to create a filter by hand.


9 Responses to “xml to csv”

  1. fluffy Says:

    CSV is typically flat, while XML is typically nested. XML is much better-suited to S-expressions. Of course it depends on what you’re trying to convert.

    If it’s simple enough you could just try doing something with XSLT.

  2. joy Says:

    It’s a long story. Basically, I’m using an old version of MS Office and I have data in this XML file that I’d like to import either into .CSV or into an Access table.

  3. fluffy Says:

    Okay, and is it flat data, or is it hierarchical? Again, flat would be pretty easy to do via XSLT, but hierarchical wouldn’t, since CSV is strictly flat.

  4. Arthur Says:

    It’s a long story. Basically, I’m using an old version of MS Office and I have data in this XML file that I’d like to import either into .CSV or into an Access table.

    How fast do you need it: for work I’m a step away of focussing on a couple of XML import routines. Secondly, as fluffy said, how hierarchical does it look like?

  5. joy Says:

    Arthur, what are you importing into?

    The data isn’t that hierarchical, it’s basically database data in XML.

  6. Arthur Says:

    Arthur, what are you importing into?

    Postgres.

  7. Arthur Says:

    it’s basically database data in XML.

    If it’s not personal data, send me a sample to my gmail-address, so I can see what I can do with it.

  8. Charlie On the Pennsylvania Turnpike Says:

    Did you ever resolve this?

  9. joy Says:

    I did solve the problem….. I got a copy of Office 2003 (long story, to be told later) and it can read the malformed xml out of the box.