HOME - about - indie cred - subscribe to RSS - listen to podcasts
« gmail invites
social networking software gone mad »

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.

Add this post to your favorite Web 2.0 social bookmarking site:These icons link to social bookmarking sites where readers can share and discover new web pages.
  • co.mments
  • del.icio.us
  • digg
  • Fark
  • Furl
  • NewsVine
  • Reddit
  • TailRank
  • YahooMyWeb

This entry was posted on Wednesday, August 25th, 2004 at 6:03 pm and is filed under Tech. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

9 Responses to “xml to csv”

  1. fluffy Says:
    August 25th, 2004 at 7:35 pm

    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:
    August 25th, 2004 at 9:20 pm

    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:
    August 26th, 2004 at 10:45 am

    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:
    August 26th, 2004 at 7:46 pm

    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:
    August 26th, 2004 at 10:07 pm

    Arthur, what are you importing into?

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

  6. Arthur Says:
    August 27th, 2004 at 6:59 am

    Arthur, what are you importing into?

    Postgres.

  7. Arthur Says:
    August 27th, 2004 at 7:01 am

    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:
    September 6th, 2004 at 8:20 pm

    Did you ever resolve this?

  9. joy Says:
    September 9th, 2004 at 10:25 pm

    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.