Drag each element from the "XML Source" pane to the corresponding column header in the Excel worksheet. This will create the associations and Excel will automatically create the required list objects.

Use Excel to combine multiple data sources in XML documents by creating a map in a spreadsheet that contains the predefined table information. Once the map is in place, the data can be imported ...