Before you convert your spreadsheet into XML, you need a markup schema. This defines each field that you’ll use in your XML file.
In our spreadsheet, we have four types of information: car make, car model, year of manufacture, and value. So our Excel schema will have four different tags.
For simplicity’s sake, we’ll call them “make,” “model,” “year,” and “value.”
Open up a blank text file, and add the following lines:
These are standard pieces of information that XML files need. Don’t worry about them too much right now.
Now add the following lines:
The record tags define a single record described by our spreadsheet. The other tags define the relevant pieces of information for that record.
Finally, add the closing tag to the end of the file: