CSV to XML scripts

To generate a valid XML file from a CSV (or Excel on the Mac) isn’t as simple as parsing the file and outputting each field surrounded by the correct tags. Characters need escaping and formats need set. This page is a great summary of the various methods of doing this conversion.