You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Export playlist and edit using excel or other editor

I have a lot of duplicates due to the same songs being downloaded through different albums (i.e. greatest hits, compilations).

I have used a playlist to display all songs and then I displayed the duplicates using the "duplicates" function. I would like to export the playlist to some other app where I can sort and filter (i.e name and then bit rate) so that I can edit the list to include the "keeper" tracks from the multiple duplicates. I would then like to import this playlist back into Itunes so that I can have a playlist called "keeper tracks".

Does anyone know how I Can do this? It seems that the playlist is in a UTF-8 type format and it is not showing as individual rows for each track when I try to use an editor.

Thank you

Mac OS X (10.6.4), iMac 21", 3.06 GHZ, 4.0GB

Posted on Nov 6, 2010 5:33 AM

Reply
5 replies

Nov 6, 2010 6:09 AM in response to 4x15mph

Theoretically you can use the Export command and read the XML into Excel. But it is far easier to copy and paste...

Display the playlist in iTunes, and make sure all the columns that you care about are present. (If any are missing, enable them by going to View > View Options.) Then Edit > Select All, and Edit > Copy.

Now switch over to Excel and Edit > Paste (or CTRL-V). Everything will show up and will be correctly columnized in Excel. Now you can go to town with sort, filter, etc.

Export playlist and edit using excel or other editor

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.