Importing data from many xml files which has same schema into a single excel sheet

Hi,

I have around 2000 xml files , can anyone suggest me what to do if i have to compile the data from them and view as rows in single excel sheet .

I tried using the XML mapping method , but i am only able to map a single xml. and not able to extract the data from all , if i have to do this i have to select each xml and open , which will be very tedious .

Please if anyone has a solution to this .I am attaching the xml which has the schema info.


Thanks in advance .

Regards,

Mayur