Hey there! Sign in to join this conversationNew here? Join for free

Exporting list of albums from iTunes as a .txt file (Windows)

Announcements Posted on
Struggling to get a graduate job in IT and tech? 17-05-2016
Find the answers: Edexcel GCSE maths unofficial mark scheme 05-05-2016
  1. Online

    ReputationRep:
    Hi, I came here because the Apple support forums are ****ing useless. What I want to know is if there is a way of extracting a list of individual albums from iTunes without doing it manually (either typing (ugh) or dragging a song from each album into a playlist), but without it repeating each one n times where n is the number of songs on the album. If I tried doing it in a non-automated way it would take forever (~5000 albums).

    Cheers.
  2. Offline

    ReputationRep:
    Copy and paste the whole list of songs into excel then remove the uneccesary columns...
  3. Online

    ReputationRep:
    (Original post by gowans07)
    Copy and paste the whole list of songs into excel then remove the uneccesary columns...
    Not sure if you read my OP, but I don't want a list of songs, I want a list of albums without having to make a playlist with one track from each album.
  4. Offline

    ReputationRep:
    If you can get the data out in the form of Artist,Album,Track then you could simply use Excel to remove the duplicate album names. Try exporting a playlist?
  5. Offline

    ReputationRep:
    (Original post by TheDefiniteArticle)
    Hi, I came here because the Apple support forums are ****ing useless. What I want to know is if there is a way of extracting a list of individual albums from iTunes without doing it manually (either typing (ugh) or dragging a song from each album into a playlist), but without it repeating each one n times where n is the number of songs on the album. If I tried doing it in a non-automated way it would take forever (~5000 albums).

    Cheers.
    Copy and paste the library into excel. Then delete the other columns so you just have a column of albums. Select the column, go to 'data' then 'advanced filter' (next to the big funnel) - tick 'Unique records only' and click okay, and then you're done.

    Ooh I forgot to add - make sure you have a 'title' in the first row rather than an album name.
  6. Online

    ReputationRep:
    Thanks.

Reply

Submit reply

Register

Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  3. this can't be left blank

    6 characters or longer with both numbers and letters is safer

  4. this can't be left empty
    your full birthday is required
  1. Oops, you need to agree to our Ts&Cs to register
  2. Slide to join now Processing…

Updated: June 2, 2012
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Today on TSR

Edexcel GCSE maths answers

Check the unofficial mark scheme

Poll
What date is the EU referendum on?
Useful resources

Articles:

The Student Room tech wikiTech forum guidelines

Quick link:

Unanswered technology and computers threads

Sponsored features:

Making money from your own website

Need some cash?

How to make money running your own website.

Groups associated with this forum:

View associated groups
Quick reply
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.