XML to Excel Converter

A program was created to combine the data from hundreds of individual XML files into 1 Excel sheet.

1. XML to Excel Converter – November 2012 (VBA/Excel)
A sales check process was developed using downloadable XML data from the activation system. Since hundreds of
different XML files were downloaded, they would only open up individually in Excel. A program was created to
take the hundreds of individual XML files, and put the data on one single sheet in Excel. This made the data
viewed, analyzed, and manipulated more easily. Without a program, this process could take 30 seconds per XML
file (repeated hundreds of times) but the program did the same task in 30 seconds.


This was the splash/main screen of this program. When clicking “Convert to Excel” any .xml files in the same folder as this Excel
workbook would opened, parsed, and put on a single Excel worksheet.