Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Jolly Roger Newsgroups: comp.sys.mac.databases Subject: Re: XML to CSV converter Date: 21 May 2014 15:35:45 GMT Organization: People for the Ethical Treatment of Pirates Lines: 21 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Trace: individual.net R1OElVuln6zsc6txzvpiLgx82o2JT/3mTmY8KtyVCG0H3MpEOh Cancel-Lock: sha1:0PGUqIt56W78gw3i5IH/E2yiP1k= X-Face: _.g>n!a$f3/H3jA]>9pN55*5<`}Tud57>1Y%b|b-Y~()~\t,LZ3e up1/bO{=-) User-Agent: slrn/1.0.1 (Darwin) Xref: csiph.com comp.sys.mac.databases:92 On 2014-05-21, Martin Τrautmann wrote: > On 20 May 2014 18:01:16 GMT, Jolly Roger wrote: >> There are many, many flavors of XML. You'll need to figure out what type >> of XML markup it is and then use an XSL transform to convert it to CSV. > > I have that kind of XML which can be opened directly by Excel. > > I guess that removing all overhead would return a proper .csv - but I'm > afraid that some data would be incomplete, thus giving random truncation > of rows. If it's an Office XML document, and you want to open it in Office 2008, you need the Open XML File Format Converter: -- E-mail sent to this address may be devoured by my ravenous SPAM filter. I often ignore posts from Google. Use a real news client instead. JR