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>