Re: iTunes Library in a Spreadsheet
Works wonderfully opening a plain text file in numbers. Stuart Breden PO Box 132 Kalamunda WA 6926 Hm Ph: (08) 9257 1577 Wk Ph: (08) 9291 4599 Mbl: 0417 053 266 On 06/03/2009, at 6:20 PM, Mark Secker wrote: You can also do Library / export playlist from within the library or any playlist. export as plain or unicode (for non western characters) text which doesn't say it in the export but is tab delimited. this can then be imported in to pretty much any spreadsheet and/or database program. you can also export as xml if you have a need for that Hello WAMUGers, I was 'fiddling' around with Numbers '09 today, and I got thinking perhaps I could do a Spreadsheet of my iTunes Library. (Ok Daniel, I couldn't find anything more constructive to do) ;-) This is what I did: 1. In iTunes click Music Library 2. Edit Select All 3. Edit Copy 4. Open Numbers (or another Spreadsheet Application you use) 5. Choose a Blank Template 6. Click on Second Row (I left Row One for Headers, as you need to type them in when tidying up the Spreadsheet) 7. Edit Paste Match Style It takes awhile to do the paste (spinning Beach Ball- depends on amount of songs in your library). I thought This is not going to work But eventually you end up with your Library Listing pasted in neatly with columns as in iTunes. Change column widths if required, and type in headers (column Names) I have 10 columns - Name / Time / Artist / Album / Genre / Size / Kind / Composer / Year / Release Date This would also work if you Select All Copy from a specific playlist, so you could create a track listing of a playlist you burned to a CD. Someone on List might find this useful Cheers, Ronni -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au -- Mark Secker Computer Support Officer ph# 61-8-6488 1855 (ECEL) mailto:m...@biz.uwa.edu.au University of Western Australia - CRICOS Provider No. 00126G ~ http://www.pbase.com/marxz It takes an idiot to do cool things that's why it's cool - Haruhara Haruka (FLCL) Ubi fumus, ibi fumus -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au
Re: iTunes Library in a Spreadsheet
Get out of here! I thought it was pretty useful actually ;-) I'm out of here now, its time for a glass of Champagne on the balcony, and Miss Cloe is pestering me to close my MacBook Pro and get her dinner! Cheers, Ronni Miss Cloe the impatient one On 07/03/2009, at 4:51 PM, Wendy S. Austin wrote: Thanks for this Ronni.I really like it when you have nothing constructive to do Wendy On 06/03/2009, at 1:12 PM, Ronda Brown wrote: I was 'fiddling' around with Numbers '09 today, and I got thinking perhaps I could do a Spreadsheet of my iTunes Library. (Ok Daniel, I couldn't find anything more constructive to do) ;-) -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au
Re: iTunes Library in a Spreadsheet
Ronni Does that mean you have taken over from Cloe on WAMUG again? I was beginning to enjoy her posts ;-) Reg On 07/03/2009, at 5:53 PM, Ronda Brown wrote: Get out of here! I thought it was pretty useful actually ;-) I'm out of here now, its time for a glass of Champagne on the balcony, and Miss Cloe is pestering me to close my MacBook Pro and get her dinner! Cheers, Ronni Miss Cloe the impatient one On 07/03/2009, at 4:51 PM, Wendy S. Austin wrote: Thanks for this Ronni.I really like it when you have nothing constructive to do -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au
iTunes Library in a Spreadsheet
Hello WAMUGers, I was 'fiddling' around with Numbers '09 today, and I got thinking perhaps I could do a Spreadsheet of my iTunes Library. (Ok Daniel, I couldn't find anything more constructive to do) ;-) This is what I did: 1. In iTunes click Music Library 2. Edit Select All 3. Edit Copy 4. Open Numbers (or another Spreadsheet Application you use) 5. Choose a Blank Template 6. Click on Second Row (I left Row One for Headers, as you need to type them in when tidying up the Spreadsheet) 7. Edit Paste Match Style It takes awhile to do the paste (spinning Beach Ball- depends on amount of songs in your library). I thought This is not going to work But eventually you end up with your Library Listing pasted in neatly with columns as in iTunes. Change column widths if required, and type in headers (column Names) I have 10 columns - Name / Time / Artist / Album / Genre / Size / Kind / Composer / Year / Release Date This would also work if you Select All Copy from a specific playlist, so you could create a track listing of a playlist you burned to a CD. Someone on List might find this useful Cheers, Ronni -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au
Re: iTunes Library in a Spreadsheet
Hello Mark, Have you done this in Numbers '09? It does not hold the same format as in the Library in iTunes when exported this way dropped into Numbers. The way I gave instructions below, holds all format exactly as it is in iTunes Library. Cheers, Ronni On 06/03/2009, at 6:20 PM, Mark Secker wrote: You can also do Library / export playlist from within the library or any playlist. export as plain or unicode (for non western characters) text which doesn't say it in the export but is tab delimited. this can then be imported in to pretty much any spreadsheet and/or database program. you can also export as xml if you have a need for that Hello WAMUGers, I was 'fiddling' around with Numbers '09 today, and I got thinking perhaps I could do a Spreadsheet of my iTunes Library. (Ok Daniel, I couldn't find anything more constructive to do) ;-) This is what I did: 1. In iTunes click Music Library 2. Edit Select All 3. Edit Copy 4. Open Numbers (or another Spreadsheet Application you use) 5. Choose a Blank Template 6. Click on Second Row (I left Row One for Headers, as you need to type them in when tidying up the Spreadsheet) 7. Edit Paste Match Style It takes awhile to do the paste (spinning Beach Ball- depends on amount of songs in your library). I thought This is not going to work But eventually you end up with your Library Listing pasted in neatly with columns as in iTunes. Change column widths if required, and type in headers (column Names) I have 10 columns - Name / Time / Artist / Album / Genre / Size / Kind / Composer / Year / Release Date This would also work if you Select All Copy from a specific playlist, so you could create a track listing of a playlist you burned to a CD. Someone on List might find this useful Cheers, Ronni -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au
Re: iTunes Library in a Spreadsheet
Thanks for this Ronni.I really like it when you have nothing constructive to do Wendy On 06/03/2009, at 1:12 PM, Ronda Brown wrote: I was 'fiddling' around with Numbers '09 today, and I got thinking perhaps I could do a Spreadsheet of my iTunes Library. (Ok Daniel, I couldn't find anything more constructive to do) ;-) -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au