Microsoft Office Tutorials and References
In Depth Information
Importing and exporting XML data
To import XML data into an Excel worksheet, click the cell in which you want the first value
to appear. Next, click the Developer tab and then, in the XML group, click the Import
button to open the Import XML dialog box. Click the XML file you want to import and then
click Open. When you do, Excel will display a dialog box that indicates that the XML source
file doesn’t refer to a schema, so the program will create one for you. Click OK, verify that
the cell you selected appears in the XML Table In Existing Worksheet box of the next dialog
box that opens, and click OK to import the data.
TIP If you think the XML data file has changed, click the Refresh Data button in the
Developer tab’s XML group to update your worksheet.