I want to summarize data from multiple xml forms into an Excel 2003 spreadsheet. Each xml file has the identical structure, but different data. I want to define the XML map in Excel, and import data for each file, with each file's data being on a new row.

Any ideas?

Thanks in advance.