I have a requirement where there are some 8000 xml files in a particular folder. Each xml file when imported to excel displays 25 columns each. I want to export all the xml files from the folder at a stretch so that all the 8000 records are uploaded to the spreadsheet instead of uploading individually.

How can i automate this process?

Please help me out regarding this