Donate SIGN UP

iTunes listings

Avatar Image
ABCharlie | 10:23 Thu 31st Mar 2011 | Music
2 Answers
Is it possible to get a list of my Album titles and their Artists (but without track listings) off iTunes and transfer to a separate Word or Excel file?

Thanks for any advice!
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by ABCharlie. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
You can. Create a new playlist showing only album and artist. You will still have all the tracks shown, you can't get rid of these yet. Select all the albums you want to list and add to your playlist, you will now have track, album and artist. Go to edit, select all, copy.
Open Excel and paste. You now have the three columns listed. Delete the Track column.
You now have lots of duplicate album/artists. In excel select all in your new list, go to the Data menu and select Filter/Advanced Filter. Under Action, click filter the list in-place, at the bottom check the Unique Records Only checkbox and click OK. This should remove pretty much all your duplicates leaving only single rows for album artist (assuming your albums all have a single artist).
You might get an error message when using advanced filter that says it cannot find column headings. Ignore.
Question Author
Milvus - it worked a treat!
Thanks for your help.
All the best. Charlie

1 to 2 of 2rss feed

Do you know the answer?

iTunes listings

Answer Question >>

Related Questions