3 Replies Latest reply: Sep 21, 2007 12:50 AM by Freis1968
Freis1968 Level 1 Level 1 (40 points)
Ok, someone here must know how you can export all of your Albums by Artist onto a spreadsheet that can then be printed out.

I have close to 800 albums in my iTunes library and I want to export this list into a text or spreadsheet format that shows the following:

Album name - Artist

Is this possible or is there a program out there that will do it?

I tried exporting the library out via File>Export Library and I get an xml document that when opened it just a bit of gibberish. I also exported the library and I got everything about each album, such as Album name, artist, song title, time, genre, etc and it is all mashed together and is not consise.

Appreciate the reponses.

iMac Intel Core 2 Duo, Mac OS X (10.4.10), 2.1ghz, 1gb Ram, 20" iMac
  • Freis1968 Level 1 Level 1 (40 points)
    Second request.
  • jere7my Level 4 Level 4 (1,810 points)
    Well, you can print a list of albums directly from iTunes — just select Album Listing > List of Albums in the Print dialog. Failing that, you can show the "Artist" and "Album" columns in your library, select all, and copy and paste the data into your favorite spreadsheet program. You'll then need to delete duplicates, but there are easy ways to do that. (Sort by Track Number first, for instance, and then you can easily select only track 1 from each album.)
  • Freis1968 Level 1 Level 1 (40 points)
    Thank you for the reply. I am trying to click on Solved to give you points but the dumb Apple forum thingymabob is not working and keeps giving me an error. I will keep trying.