Return to the Organizing the Home Forum | Post a Follow-Up

iPod/Music Organization

Posted by tommeca (My Page) on
Wed, Aug 1, 07 at 0:33

I gave my husband an iPod last Christmas and now find myself in the midst of downloading every CD we have onto it. So far I've downloaded 3500 songs and have about the that many more to go.

Outside of carrying the iPod with me, does anyone know of a method to take the information from iTunes and converting it into another format (Excel?) so that I can carry an inventory in my Palm? I've done a little experimenting and haven't been successful yet.

Although it sounds a little tedious, my purpose is (1) to have an inventory, and (2) avoid purchasing duplicate CDs in the future. (I haven't found that many, but still have found enough.) I have a complete inventory of all of our movies and books, so it seems like a natural progression to inventory the music.

Any advice welcome!

Follow-Up Postings:

Try this:

In iTunes, go to File and choose Export. It can save the information about the songs as a text file or an xml file. Choose txt. Then open the txt file in Excel, choose "delimited" in the first window that comes up, click "next", choose "tab" and click "next", then in the next box that comes up choose the data format for each column (I use "general" for all of them) and finally click "finish". All the dates will be messed up, as Excel doesn't offer an option for importing dates with times, but the rest of the information should be correct.

RE: iPod/Music Organization

Here is one way on a Mac (I can't help on PCs, maybe something similar would work?):

Open iTunes
click on Library > Music
move mouse to Music window with all the songs and Select All (Edit > Select All or use Clover + 'a' key)

Open Excel - however you get a new worksheet
click paste (Edit > Paste or use Clover + 'v' key)


A Mac program that works well for moving music between from the iPod BACK to your computer, or between iPods is SENUTI (spell iTunes backwards - clever).

More on Senuti


RE: iPod/Music Organization

Thank you both for great, detailed instructions. I've finally finished the loading and am now doing the first sync w/ the iPod. I hope to be able to work on exporting the information in the next week or so.

Thanks again!

RE: iPod/Music Organization

I don't have an IPod, so no help there.

As for making sure you don't buy duplicate CD's, my solution is not so much maintaining & carrying around an inventory of what I already have...but carrying a wishlist of what I want, or "need" if you work on building collections.

If it made my wishlist, I know I don't already own it.

If it made my wishlist, I know I've thought about it and want it more than any impulse buy and it serves a purpose for my music tastes and collection.

If I see a CD in a store that's not on my wishlist & could be an impulse buy...I DON'T buy it!!!! I write it down on my wishlist for the next planned trip...or to verify, or to think about it or research it in the event I discover I really don't need or want it in the next few days. I've had to discipline myself to do this, but it absolutely works for me in stopping wasted money on impulse buys. If the CD is released, remember that IT WILL BE THERE THE NEXT TIME, and if it's not, there are so many other ways to buy the CD online or in other stores. You're not missing any opportunities if you walk away from impulse CD purchases.

 o Post a Follow-Up

Please Note: Only registered members are able to post messages to this forum.

    If you are a member, please log in.

    If you aren't yet a member, join now!

Return to the Organizing the Home Forum

Information about Posting

  • You must be logged in to post a message. Once you are logged in, a posting window will appear at the bottom of the messages. If you are not a member, please register for an account.
  • Please review our Rules of Play before posting.
  • Posting is a two-step process. Once you have composed your message, you will be taken to the preview page. You will then have a chance to review your post, make changes and upload photos.
  • After posting your message, you may need to refresh the forum page in order to see it.
  • Before posting copyrighted material, please read about Copyright and Fair Use.
  • We have a strict no-advertising policy!
  • If you would like to practice posting or uploading photos, please visit our Test forum.
  • If you need assistance, please Contact Us and we will be happy to help.

Learn more about in-text links on this page here