4.1.2 Merge multiple XML files and convert to Excel(XLS) using the command line

Excel uses a smart merge technology to automatically merge data from multiple XML files. This comes in very handy if you have similar data in many XML files (maybe you receive this everyday), and you need to convert data in these XML files to a single Excel spreadsheet.

The conversion is very simple: just list out all the XML files you need to merge and extract to Excel. In the following example, sales data for each month is merged and extracted to an XLS file.

Exultcmd.exe -t XLS -f sales.xls -w sales-062007.xml sales-072007.xml sales-082007.xml

Soon gets tedious if you need to explicitly list out all the XML files for conversion. Just use a wildcard.

Exultcmd.exe -t XLS -f sales.xls -w sales*.xml

What if you need to merge all XML files in a directory and extract to Excel?

Exultcmd.exe -t XLS -f sales.xls -w C:\Dir\*.xml

How about merging XML files in multiple directories? Follow this example:

Exultcmd.exe -t XLS -f sales.xls -w C:\DirA\*.xml C:\DirB\*.xml

Argon DataViz

Create Pivot Tables and Pivot Charts from Large Datasets.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.