3.6. Use XML Maps

If all of the XSLT in the preceding sections intimidated you, relax a bit. Excel also provides graphical tools for importing XML into workbooks through XML maps. XML maps are the way Excel represents XML schemas within a workbook. Excel can generate these maps from the structure of an imported XML file, or Excel can load an XML schema as an XML map.

Excel uses XML maps as a way to bind data from an XML file to cells and list columns on a worksheet. You create this binding by selecting items from an XML map displayed in the XML Source task pane and dragging them to locations on a worksheet.