Microsoft Office Tutorials and References
In Depth Information
Import Data from an XML File
Import Data from
an XML File
You can analyze data that currently resides in
XML format by importing that data into Excel
and then manipulating and analyzing the
resulting XML table.
XML is a standard that enables the
management and sharing of structured data
using simple text files. These XML files
organize data using tags, among other
elements, that specify the equivalent of a table
name and field names. Here is a simple XML
example that constitutes a single record in a
table named “Products”:
These XML files are readable by a wide variety
of database programs and other applications,
including Excel 2010. Excel usually stores
imported XML data in an XML table, a range
that looks and operates much like a regular
Excel table, except that it has a few XML-specific
1 Click the cell where you
want the imported data
2 Click the Data tab.
3 Click Get External Data.
4 Click From Other
5 Click From XML Data
The Select Data Source
dialog box appears.
6 Select the folder that
contains the XML file you
want to import.
7 Click the XML file.
8 Click Open.