Hi, Ben.
One way to convert Excel data into an XML file would be to create a merge template in Word, merge the data from the Excel spreadsheet, and then save the merged document as a text file with a .XML extension.
The real trick is determining what the XML file should look like. As a simple example, if you had a CSV file that looks like this...
"FirstName","LastName","MrMs","NoteDate","NoteTime","NoteText"
"Bob","Loblaw","Mr","2006-02-10","12:09:30","This is a note."
...after converting to XML it would look something like this...
<?xml version="1.0"?>
<AllData xmlns = "http://www.maximizer.com/maximizer/xmlimportexport/3.0"
xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation= "http://www.maximizer.com/maximizer/xmlimportexport/3.0 MXISchema.xsd">
<Individual>
<FirstName>Bob</FirstName>
<LastName>Loblaw</LastName>
<MrMs>Mr</MrMs>
<Note>
<Date>2006-02-10T12:09:30</Date>
<Text>This is a note.</Text>
</Note>
</Individual>
</AllData>
To see more XML tags, try exporting some address book entries to XML and then look at the resulting file.