This is something I made for when you need to create an xml playlist for use with web MP3 flash playlists, JW player, etc. Whenever I need to put together a playlist from scratch, I really get annoyed editing a playlist in Dreamweaver, or a text edit program. I figured there has to be an easier playlist builder on the web, and there are a ton of XML builders, and software people want to sell, but I could not find one for a simple flash MP3 playlist. So I built one with Excel.
Consider this my first Microsoft related contribution to the web. Free for the taking. This is a great tool for those who just want to quickly type in the artist name, album, file name, and boom, there you have it. This is great for bands, record labels, bloggers, or any website featuring playlist media. Enjoy.
Instructions here are simple. It’s an Excel file with 3 tabs. The first is “Data Entry”. Type in the blue areas. Title, website, and your file directory on your server with your mp3 files. Using this requires that you have a basic knowledge of xml, and playlist building. Please do not contact me with questions on how to build xml files, but feel free of course if you find any bugs, errors, or general thoughts to improve on this concept.

Step two, go to the second tab, titled “Copy This Code Save as XML” and copy the highlighted blue cells. Paste it in to a text edit program, and save it as an xml file. Place the xml file on your server like you would any other playlist. Voila. Easy breezy. There are 20 lines for 20 tracks. If your playlist is less than 20, just remove those lines once you pasted it in your text file.

You can help yourself to the file here:
http://www.circuittostereo.com/free/xmlbuilder.xlsx
http://www.circuittostereo.com/free/xmlbuilder.xls