Excel® 2013 On Demand

Creating an XML Data Map

Using XML data in Excel follows the same basic process: (1) Add an XML schema file (.xsd) to a workbook, (2) map XML schema elements to individual cells, (3) Import an XML data file (.xml), (4) enter data, and (5) export revised data from mapped cells to an XML data file. You can use the XML Source task pane to create and manage XML maps. The task pane displays a hierarchical list of XML elements in the current XML map that you use to map to worksheet cells. After you create an XML data map, you can import XML data to fill in the information you want from a data source.

Create an XML Data Map

Open the worksheet in which ...