export spreadsheet data in a variety of formats

After you have imported XML data, mapped the data to cells in your worksheet, and made changes to the data, you often want to export or save the data to an XML file. There are two ways to export XML data from a Microsoft Office Excel 2007 worksheet:

• Microsoft Office Help Online recommends using the Export command in the XML group on the Developer tab to get XML data out of your worksheet.
• For backward compatibility with earlier XML functionality, you can still use the Other Formats command on the Save As submenu of the Microsoft Office Button .

Export XML data in mapped cells to an XML data file

1. If the Developer tab is not available, do the following to display it:
   1. Click the Microsoft Office Button , and then click Excel Options.
   2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

      Note The Ribbon is a component of the Microsoft Office Fluent user interface.

2. On the Developer tab, in the XML group, click Export.

   

   Note If a small Export XML dialog box appears, click the XML map that you want to use, and then click OK.

   The Export XML dialog box will only appear if an XML table is not selected and if the workbook contains more than one XML map.

3. In the large Export XML dialog box, in the File name box, type a name for the XML data file.
4. Click Export.

Note There may be headings or labels in your worksheet that are different from the XML element names in the XML map. However, the XML element names are always used when you export or save XML data from the worksheet.

http://office.microsoft.com/en-gb/excel/HP102064011033.aspx?pid=CH100648521033 - Will explain XML data in greater detail