is there an application that can be used to convert XML to CSV?
It depends. XML is a complex format that can represent any kind of data.
CSV is garbage and has no defined format.
It all depends on what your CSV is for - the specific software and version number, including the specific variety of CSV required.
Once you know that, then you can figure out a transformation to convert your XML into that CSV.
As Keith states, Excel can open XML files but, in practice, it does a poor job of complex XML files - it can usually extract the headers, but the data is somewhat hit-or-miss, depending on the complexity of the data structure - your system already includes a load of XML files, so try opening the in Excel to see what you get.
That is despite the fact that XML is supposed to be unambiguous and portable.
If Excel can't handle your specific files, then you have a couple of other options - at the end of the day, XML is basically text, so it comes down to text parsing. There are also some XML-specific tools in AppleScript that can read an XML files into AppleScript lists, which can then be exported.
So, start with Excel. if you're lucky, you're set. Otherwise you'll need to dig deeper.
Oh, and you might be able to use OpenOffice, a free office clone.
Excel will do it.
I don't have excel and don't wish to purchase it. I am trying to move specific files from one website plugin to a different plugin. These are calendar entries. I can only export them to xml and the calendar app only imports csv files.
I found one website that will allow me to convert only a 1 mb file and my file is 3.6 mb
There is no guarantee that the csv from xml is the correct csv format for the other program.
I tried that but it gives me an input/output error
XML to CSV
