6 Answers

• Reputation: 628 Q&A: 25 0 23 1123 1525 14 Classifieds: 0 0 what's this? Follow Following 3

  1 0 You might want to try a program called "Delicious Library." You can get it in the apple app store or find out more here: http://www.delicious-monster.com/ Basically, it can contain books, DVDs, LPs, toys, music and whatever. It automatically grabs all of your info. from iTunes already. Then all you have to do is do an "Export" to Excel or whatever format you want with the data you want. It is a pretty neat little program and I'm pretty happy with it so far. I haven't tried exporting my itunes to excel format, because I don't have a need to, but I just looked and it can be done. I think you can also export it in txt format or other kinds of formats too. What I have used it for is cataloging books and DVDs mostly. I entered most of my books from my tab-delimited list from LibraryThing and used the isight camera barcode scanner for most of my DVDs. Kristin Bell answered in Tech Support 9 months ago | Report 3 comments by mister_fusspot, Fnarf, and Kristin Bell… 0 0 That looks like a great solution, though I suspect Fnarf is on a Windows computer in which case it would not be applicable. I wonder if an equivalent exists in that world? mister_fusspot commented 9 months ago | Report 0 0 Yeah, Delicious is Mac-only. There are Android equivalents, like the one I mentioned, but they suck donkey balls. Fnarf commented 9 months ago | Report 0 0 Fnarf! Why are you not on a Mac?!? :) jk :) Yah, I thought that might be a problem. Sorry. :( Kristin Bell commented 9 months ago | Report Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend:

• Reputation: 342 Q&A: 3 4 2 202 45 1 Classifieds: 0 0 what's this? Follow Following 0

  1 0 Not a definitive answer because I'm not wholly sure of your exact hardware set-up or desired results, but here are a few ideas... 1) If you would be happy with a TXT file, you could simply create a new playlist and drag the entire library into that playlist. iTunes allows for a TXT export of playlists, unlike the library itself. 2) If you really want it as an Excel file and your computer's version (2003) can't do it, copy the XML file on a thumb drive and go to a friend/library/Kinkos and make the conversion. Then import it into whatever you want... an Android phone I think? 3) Consider using Evernote, a cross-platform application which allows you to sync a wide range of file types across all your devices. You would still have to figure out how to migrate the exported library into Evernote, but I suspect there would be a way. Here's the URL; perhaps you could write to their technical support and see if they think it's feasible. http://www.evernote.com/ Good luck. mister_fusspot answered in Tech Support 10 months ago | Report Comment on this answer Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend:

• Reputation: 733 Q&A: 22 0 4 224 16 1 Classifieds: 0 0 what's this? Follow Following 0

  0 0 Hey Fnarf- I have two options for you. 1) If you have a PDF reader on your phone and acrobat on your computer you can File->Print and save an album list as a PDF. You may need to have acrobat pro for this and it won't work if you really want it as an excel file. 2) Make a playlist that includes all of your albums (or any subset of them). Go to File->Library->Export Playlist. Change the extension to .csv, save and open (it should automatically open with excel). Now you have a list of all songs with all of the relevant meta data. Since you only want a list of albums make a new column after the albums and add this function: =IF(D2=D1,"",D2) Drag the function down to the bottom (encompassing all albums), copy special (values) to a new worksheet and sort. You should now have what you're looking for. It should actually be fairly easy to write a script that dynamically updates this list every day or whenever. But that may be more than you need. Buena suerte. Danger answered in Tech Support 9 months ago | Report 4 comments by mister_fusspot, Danger, and mister_fusspot… 1 0 Hey Danger - which version of iTunes are you using? I'm on 10.4 on a Mac and CSV is not one of the options offered for exporting playlists. I wonder it will be available on 10.3 which is what he's using. Otherwise very helpful answer. mister_fusspot commented 9 months ago | Report 2 0 It's not actually a given 'option'. When you get to name the file you are saving it should be something like: "music playlist.txt" by default. Just go ahead and change it to "whatever.csv" yourself. You can also change the file extension after saving if need be. This works on 10.3, I haven't looked on 10.4 yet, but I'm almost certain it is the same. There is no real difference between *.csv and *.txt. Excel is just usually the default to open csv files. Technically it means comma separated values, but in reality iTunes saves it as a tab delimited file (tab separates information as opposed to commas). Excel just assumes you're an idiot and goes ahead and opens it properly anyway. Danger commented 9 months ago | Report 1 0 Thanks, Danger, you just taught me something useful. mister_fusspot commented 9 months ago | Report 0 0 This looks cumbersome but possible. I'll try it and let you know. Fnarf commented 9 months ago | Report Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend:

• Reputation: 1627 Q&A: 33 0 3 1043 136 0 Classifieds: 0 0 what's this? Follow Following 2

  0 0 A little bird told me that there's an update available for Word 2003, making it possible to open .xdoc files. It might be worth checking to see if Microsoft is offering a similar update for Excel. keshmeshi answered in Tech Support 9 months ago | Report 1 comment by Fnarf… 0 0 It's actually the same update, the "Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 and later File Formats", and I already have it, and it doesn't help. (sad face). Excel 2003 is already XML-enabled but not all XML is created equal, apparently. Fnarf commented 9 months ago | Report Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend:

• Reputation: 102 Q&A: 0 0 3 50 8 0 Classifieds: 0 0 what's this? Follow Following 0

  1 1 Get an intern. Carole answered in Tech Support 9 months ago | Report Comment on this answer Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend:

• Reputation: 1045 Q&A: 28 0 3 485 60 0 Classifieds: 0 0 what's this? Follow Following 0 capicola

  0 0 Idea 1: Can you import the exported iTunes file into Google Docs, which uses a different parser for its spreadsheet? Idea 2: I dunno how comfortable you are manipulating and transforming XML documents, but there appear to be some basic XSLT stylesheets that you can save as files to your iTunes folder and use with no or minimal coding to get an album list in a browser here: http://www.movable-type.co.uk/scripts/itunes-albumlist.html The author presents the complicated theory and how-to and options to customize before sticking in the simple instructions and stylesheets below: To use this script, in its basic or full form, save the albumList.xml and albumList.xsl shown below to your My Music/iTunes folder, and open albumList.xml in your browser (IE6 or Firefox). If you want to tailor the layout, with the guidelines above you should be able to mix and match the components as required. You are welcome to re-use these scripts [without any warranty express or implied] for personal use. Good luck! capicola answered in Tech Support 10 months ago | Report Comment on this answer Enter your comment or ask a new question preview THIS IS A PREVIEW: Click "Post" to submit it or "Edit" to make changes. edit Please wait… This could take a minute if the tubes are clogged.

  Share this answer with a friend: