iPod/Music Organization

TommeCAAugust 1, 2007

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!

Thank you for reporting this comment. Undo

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.

    Bookmark   August 1, 2007 at 12:05PM
Thank you for reporting this comment. Undo
Lena M

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


    Bookmark   August 1, 2007 at 12:16PM
Thank you for reporting this comment. Undo

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!

    Bookmark   August 7, 2007 at 11:19AM
Thank you for reporting this comment. Undo

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.

    Bookmark   August 18, 2007 at 11:03AM
Sign Up to comment
More Discussions
Loved This Book!
I just (quickly!) read "The Life-Changing Magic...
Organizing vs. Cleaning?
Have discovered in the last few weeks that I get a...
I am donating like a madwoman!
In 2006, we put our home on the market, and to get...
Get rid of cookbooks, and cook more?
About a year ago, I got rid of most of my cookbooks...
Large closet advice
I'm turning a spare bedroom into a dressing room and...
© 2015 Houzz Inc. Houzz® The new way to design your home™