Edmond Woychowsky walks you through his process, including all the necessary sample code, to convert an XML file to an Excel spreadsheet.

Excel pro tips: Importing and parsing data When data dumps into your spreadsheet and it's a big mess, you'll know what to do.