Exult makes converting XML to CSV very easy. It works by parsing the XML for data, automatically creating tables and columns, and identifying relationships between tables as dictated by the XML structure. These relationships are built using primary and foreign keys. Though primary and foreign keys do not have any special significance for CSV files, they are very important when loading the data into a database. By exporting the XML relationships as primary and foreign keys, Exult gives you the option of carrying these relationships over to whatever the intended target of the CSV export.
Exult also includes options to merge data from two or more tables into a single table. The merge takes into account the relationships between parent and child tables. This is very useful if you want to flatten the XML data.
After XML parsing is complete, you can preview the data and select the tables you want to export.
An important feature of Exult is that it can handle large XML files without running into memory restrictions. This is due to the fact that Exult parses the XML data to an embedded database, so the entire XML file is never loaded into memory.
Note that Exult supports different output formats in addition to CSV, including saving directly to a Microsoft Excel spreadsheet (XLS file), Microsoft Access Dataabase (MDB or ACCDB files), HTML or Text.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.