Excel – iTunes: Let’s account for our music

Recently I was bit lost managing my iTunes songs and its playlist. So I thought excel would lend me a hand to get hold of my music analytics. So here I have created an excel VBA based solution to get out my list of all the songs present in my iPod.

Additionally I have also created a utility to create playlist via VBA for my iPod. Hope this tool helps many others to enjoy their music excelly.  

Songs list from iPod to Excel Sheet
 

Creating Playlist in iPod from Excel
 

Result in iTunes
 


Download:


Download solution



References:
Link1: http://developer.apple.com/sdk/itunescomsdk.html