Microsoft® Office Excel® 2007 Plain & Simple

Interacting over the Web with XML

The goal of XML is to be a universal language, allowing data to move freely from one application to another. In this case, that means that saving an Excel worksheet as an XML document would allow any other spreadsheet program to read the XML file, separate out the cell names and data, and use the annotations to recreate the worksheet. By the same token, you could take a worksheet saved as an XML file and, regardless of the program in which the file was created, import it into Excel.

Save a Workbook as an XML Spreadsheet

1. Click the Microsoft Office button.

2. Click Save As.

3. Click the Save As Type down arrow.

4. Click XML ...