Add an XML map to a workbook
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.
- On the Data menu, point to XML, and then click XML Source.
The XML Source task pane is opened.
- Click XML Maps.
- Click Add.
- In the Look in list, click the drive, folder, or Internet location that contains the file you want to open.
- Click the file, and then click Open.
- Click OK to dismiss the XML Maps dialog box.
The XML map is displayed in the XML Source task pane.