Tunes Library Album List Export
With the previous version of iTunes I could export an album/artist list into an Excel doc but with the latest version I can't figure it out. Anyone know? Thanks.
iMac
With the previous version of iTunes I could export an album/artist list into an Excel doc but with the latest version I can't figure it out. Anyone know? Thanks.
iMac
JMJ,
It is now on the File menu. File > Library > Export Playlist.....
Thanks for the reply. When I go to Export Playlist my choices are: Plain Text, Unicode Text, XML, M3U, M3U8. I want to export to Excel- or at least to a list I can paste into Excel.
JMJ,
I think those options are the same as the have always been.
If you just want to copy into Excel, you can use Edit > Select All, Edit > Copy in iTunes, and then Paste into Excel. It will show up in Excel with the same columns that were on display in your iTunes view for that playlist.
That worked with a bit of adjustment: In Albums View I used your commands and pasted into Excel. It did list all the songs (14814!), track numbers, times, dates, etc which I didn't want- but I deleted all but the Artist, Album, and Genre columns, then selected those and in the Data tab, clicked "Remove Duplicates."
Hope this helps the next person. Thanks!
JMJ,
It is probably a little more straightforward if you start in iTunes Songs view instead of Album view, but glad it worked out.
Tunes Library Album List Export