Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to open XML files in Excel 2003
Article ID: 827294 - View products that this article applies to.
For a Microsoft Excel 2002 version of this article, see 282161
In Microsoft Excel, you can open and save Extensible Markup Language (XML) files. This article describes how XML files are displayed when you open them in Excel.
Structured DataXML is a meta-markup language that provides a format for describing structured data. XML is a subset of the Standard Generalized Markup Language (SGML) that is optimized for delivery over the Web.
XML is a flexible text format that is derived from SGML (ISO 8879) as defined by the World Wide Web Consortium (W3C). The W3C oversees the implementation of XML so that it remains independent of applications and vendors. For more information about the W3C and XML, visit the following W3C Web site:
http://www.w3.orgIn XML, you can define an unlimited set of tags. Tags are used to describe the type of data that is enclosed. The following XML example is a weather report:
How to Open Files in ExcelWhen you open an XML file in Excel, you are prompted to select one of the following methods to import the XML data:
Open the File As an XML ListWhen you open an XML source, Excel looks for a tag for an XML style sheet (XSL). The XSL describes how the data is to be presented. If the tag is present, Excel prompts you with a choice to apply the style sheet or not. If you select to apply an XSL, the XSL dictates how to present the data; in this case, the remainder of the information in this section of this article does not apply.
If there is no XSL tag, you receive the following message:
Excel then imports the data in the XML source. If the XML data contains duplicate fields inside an element, Excel spreads the data over multiple rows. Each row contains one unique set of data. This can cause a small set of data in XML to be displayed as a larger number of rows in Excel.
Open the File As a Read-Only WorkbookWhen you select to open an XML source document as a read-only workbook, the first tag of the element is used like a title and is placed in cell A1. The rest of the tags are sorted alphabetically and placed across the second row. The weather report example earlier in this article will be sorted into the following list of column headings when you open it as a read-only workbook:
Use the XML Source Task PaneThe schema of the XML data file is displayed in the XML Source task pane. You can then drag elements of the schema to the worksheet to map those elements to the worksheet.
If you are opening an XML data file that does not refer to a schema, Excel infers the schema of the XML data file.
(http://support.microsoft.com/kb/287739/ )XL2002: Error Message: The Following Features from Your Workbook Will Not Be Saved in the XML Spreadsheet
(http://support.microsoft.com/kb/287734/EN-US/ )XL2002: Excel Saves XML Files in the XML Spreadsheet Format
For more information about XML, visit the Microsoft Developer Network XML Home or the XML Software Developer's Kit Web site: