This will create the associations and Excel will automatically create the required list objects. Choose "XML" then "Export" from the "Data" menu to create your exported XML data file.

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