XML if for website design and it is called Extensible Markup Language.
you can save it as XML if you want it does not matter, it should open up in the schools program of MS Office.
Striving to provide you with the BEST ANSWER.
Applies to
Microsoft Office Excel 2003
Note The information in this article assumes that you have a basic knowledge of Extensible Markup Language (XML). If you'd like more basic information, see Manage Information with XML in Microsoft Office Professional Edition 2003.
One of the most powerful features of Microsoft Office Excel 2003 is one you can't really see: support for user-defined XML schemas. In plain English, that means you can add XML schemas (a schema is just a structure) and data to your workbooks, regardless of where the XML originated. Excel automates most of the processes for you. All you need to do is open the file and decide how you want to use the data.
You can:
View the data in an XML list Use this option when you want to see all your data in one list. Lists act as cohesive units. If it helps, think of them as worksheets within larger worksheets. You can manipulate the data in a list separately from the surrounding worksheet. For example, you can sort data, rearrange rows, and, to a limited extent, rearrange the columns in a list without affecting the surrounding cells.
View the data in a read-only workbook Use this option when you or others need to view the data in a file but don't need—or want—to manipulate it. Read-only workbooks can provide a fast way to create business reports and other types of files that you don't want users to change. When you select this option, Excel displays the data in a static grid.
Create a map from the structure and import data into the map When you use the XML Source task pane to create a map, you link or bind a cell in a worksheet to an element in the XML file. Importing data into the map populates the cells with data. This is the most flexible and powerful option for working with XML data. For example, say your sales department stores its data as XML, and you need to create a report that summarizes sales activity for each month. When the sales department posts new data, you can import that data into a map or set up a system that updates your worksheets automatically. This figure shows a worksheet with a populated map. Excel surrounds the mapped cells with a blue border.
Open and work with an XML file
Follow these basic steps to view an XML file in Excel by using one of the methods described earlier.
Note If you'd like to follow this procedure but don't have an XML file handy, you can download this sample XML file. Follow the on-screen instructions, and place it in a convenient place on your network or your computer's hard disk.
On the File menu, click Open.
In the Files of type list, select XML files (*.xml).
In the Look in box, navigate to the XML file you want to open, select the file, and then click Open.
The Open XML dialog box appears.
Click one of the options in the Open XML dialog box, and then click OK.
Information in the following sections explains how to use each option:
As an XML list
If a message box appears, click OK to close it. Excel creates the list. Notice that Excel adds all the data in the file to the list.
Depending on the structure of your source file, you may see a lot of repeated data, such as names and dates. You can eliminate redundancies by using the Use the XML Source task pane option when you open the file.
More information
The following links take you to more information about Excel and XML lists:Using XML in Excel
About lists
Troubleshoot lists
As a read-only workbook
Excel adds all the data in the file to the list and flattens the file, meaning it displays the data in a standard grid instead of a list.
Depending on the structure of your source file, you may see a lot of repeated data, such as names and dates. You can eliminate redundancies by using the Use the XML Source task pane option when you open the file.
Use the XML Source task pane
The XML Source task pane appears and displays the schema (the structure) of your XML file.
Drag the items (they're called elements) that you want to map from the task pane to blank cells on your worksheet.
Select any one of the mapped cells. On the Data menu, point to XML, and then click Import.
The Import XML dialog box appears.
Use the Look in list to locate the source file you want to import. Select the file, and then click Import.
Click OK to display the map in the task pane.
More information
The following links take you to more information about XML maps:
Using XML in Excel
Unsupported XML schema constructs
Tip
The following steps demonstrate another way you can open the XML Source task pane and use it to create an XML map:
On the Data menu, point to XML and then click XML Source.
In the XML Source task pane, click XML Maps, a