combine ~500mb of xml data into a large *.xlsx spreadsheet

Closed - This job posting has been filled and work has been completed.

Job Description

I have ~500mb of xml data broken into files ~30mb files with 30,000-50,000 rows each.
I need you to combine all of these files into a one large *.xlsx file (I use excel 2013, x64) or into a large *.csv file (openable in excel).

I tried to just use the excel data import tool, but it just froze my excel for half hour and nothing happened in the end.

sample xml file is attached

Open Attachment