Jump to content

Analyze XML data with Excel 2002


Recommended Posts

Analyze XML data with Excel 2002

Excel 2002 lets you open and analyze an XML file as a native Excel file. You can use all of Excel's analysis tools, including pivot tables and pivot charts, with XML data.

To open an XML file, go to File | Open, and select XML Files from the Files Of Type drop-down list. Navigate to the XML file you want to open, and click Open.

Excel displays XML tags as column headings and lists the data in the rows below the appropriate column headings. For example, in an XML Orders file, every Orders element may have Ship Region as a child element. In the worksheet, Excel represents the child element as the column header /Orders/Ship Region/.

Excel opens XML files as read-only files, so users can't make changes to the original file while analyzing it in Excel.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...