Add an XML map to a workbook

Microsoft Office Excel 2003

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.

  1. On the Data menu, point to XML, and then click XML Source.

    The XML Source task pane is opened.

  2. Click XML Maps.
  3. Click Add.
  4. In the Look in list, click the drive, folder, or Internet location that contains the file you want to open.
  5. Click the file, and then click Open.
  6. Click OK to dismiss the XML Maps dialog box.

The XML map is displayed in the XML Source task pane.