Microsoft Office Tutorials and References
In Depth Information
Importing and exporting XML data
Other programs could display or process the XML file’s contents in other ways, but you
wouldn’t have to change the underlying XML file. All of the work is done by the other
To work with XML data in Excel, you must use the controls on the Developer tab. If
the Developer tab doesn’t appear on the ribbon in your copy of Excel 2013, display
the Backstage view, and then click Options to open the Excel Options dialog box. Click
Customize Ribbon to display that page of the dialog box and then, in the Main Tabs list
in the panel on the right, select the Developer tab’s check box.
When you click OK, the Developer tab appears on the ribbon.