Structure Workbooks using XML

Structure Workbooks using XML

Why use XML in Excel?

XML is a technology that is designed for managing and sharing structured data in a human-readable text file. XML follows industry-standard guidelines and can be processed by a variety of databases and applications. Using XML, application designers can create their own customized tags, data structures, and schemas. In short, XML greatly eases the definition, transmission, validation, and interpretation of data between databases, applications, and organizations.

Open and work with an XML file

1. On the File menu, click Open.
2. In the Files of type list, select XML files (*.xml).
3. In the Look in box, navigate to the XML file you want to open, select the file, and then click Open.

The Open XML dialog box appears.

4. Click one of the options in the Open XML dialog box, and then click OK.

Information in the following sections explains how to use each option: