Map XML elements to a worksheet

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

1. On the Data menu, point to XML, and then click XML Source to open the XML Source task pane.
2. To map one or more elements to your worksheet, select the elements in the XML Source task pane. To select nonadjacent elements, click one element, and then hold down CTRL and click each element.
3. Drag the selected elements to the worksheet location where you want them to appear.