After you finish working with your XML document, you can export or save the data for use in other XML compatible documents and applications. You can save the contents of a mapped range with the XML Data format or XML Spreadsheet format. The XML Data format is an independent XML industry standard that uses a separate XML schema, while the XML Spreadsheet format is a specialized Excel XML file that uses its own XML schema to store information, such as file properties. Export XML Data -
| Open the worksheet with the XML data. | -
| Click the Data menu, point to XML, and then click Export. | -
| If necessary, click the XML map you want to use, and then click OK. | -
| Select a location where you want to export the XML data. | -
| Type a name for the XML file. | -
| Click Export. | Did You Know? You can quickly verify a data map before you export the data . Click the Data menu, point to XML, click XML Data Source, click the Verify Map For Export link at the bottom of the task pane, and then click OK when it's done. | Save XML Data -
| Open the worksheet with the XML data. | -
| Click the File menu, and then click Save As. | -
| Click the Save As Type list arrow, and then click XML Data or XML Spreadsheet. | -
| Select a location where you want to save the XML data. | -
| Type a name for the XML file. | -
| Click Save. | -
| If necessary, click Continue, click the XML map you want to use, and then click OK. | IMPORTANT When you save with the XML Data format, the active worksheet is now the XML data. To work with the original worksheet, you need to re-open it. Did You Know? You can also open an XML data file . Click the File menu, click Open, click the Files Of Type list arrow, click XML Files, select the XML data file, click Open, click the As An XML List, As A Read-Only Workbook, or Use The XML Source Task Pane option, and then click OK. | |