Sussed it.. and its easier than i thought..

MS Excel has the facility to import data from multiple xml files.

details here:
http://office.microsoft.com/en-us/ex...es_into_one_or