You don't need to have all the data in one xml file to pull all of it into Excel. Open one of the xml file and Click on File -> Export To -> Microsoft Office Excel. Now in the wizard that comes up select all the fields that you want to export out. Once the fields to Export out are selected, you will be asked if you want to export data in ...