Page 1 of 22PREVNEXT

So that's how: Using XML in Excel 2003

Excel 2003 makes it easier to work with XML
New tools in Microsoft Office Excel 2003 make it easier to work with Extensible Markup Language (XML). Learn how to use these tools to create XML lists and XML maps. XML lists have the same look and feel as regular Excel lists, but they take their data from XML files. XML maps are sets of links between the cells in a worksheet and the elements in an XML schema. You can import data into the map, modify the data, and then save the changed data or export it for others to use.

About this course

This course includes:

  • Four self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Create an XML list.
  • Create an XML map.
  • Import and export XML data to and from mapped data cells.
  • Use the icons, controls, and options in the XML Source task pane.

Before you begin

The practices for this course require that you have either Microsoft Office Excel 2003 or Microsoft Office Professional Edition 2003. You cannot complete the practices by using the version of Excel that comes with Microsoft Office Standard Edition 2003. You also need a basic understanding of XML (including schemas and well-formed data) as well as Excel lists. For more information about XML, see XML: What's it all about? For training on Excel lists, see Lists I: How to use lists in Excel 2003.

XML is now a widely accepted standard for sharing data among computer users and computer systems. Two new tools in Excel 2003 — XML lists and the XML Source task pane — make it easier than ever to use XML.

This course explains the concepts behind these new tools, and shows you how to use them to process XML data in Excel 2003.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 22PREVNEXT