reh said:
I made a spreadsheet for putting my music library online a while back (didn't like the other options available).
example
the spreadsheet w/ directions
Thank you very much!
Instead of Mac Office your spreadsheet program was opened using NEO-OFFICE.
With little knowledge of spreadsheets, if I can do this anyone can! Any tips would be appreciated, but it was mostly plug and play.
Song, Artist, Album are the itunes column defaults so it required changing the order of column header titles, after opening the xhtml speadsheet file (within Neoffice).
Guessing the default order of song artist album could be changed easily with a little change in the original spread sheet, but not required ?
After selecting the itunes View option, to show only artist and album i just copy pasted a playlist into the provided spreadsheet for testing. Everything lined up automaticaly! Song title is always displayed. Columns needed to be expanded a bit.
Simply Copy/Pasting the song info right off iTunes onto the provided spread sheet, seemed to produce a useful itunes document containing a test playlist. Took several minutes to display the 30 song test list. So I'm not sure how long my 5000+ song iTunes library would take to display.
This is much nicer result than copy pasting an itunes library without the aligned columns a spreadsheet provides. Makes a clean itunes library.xls document in the desktop folder.
Seems to work easily with just a few simple mods for someone with no experience in spread sheets and a using the free Neoffice application and provided spreadsheet!
Nice way to share and display my itunes library contents in an xls document.
OpenOffice.org is a multiplatform and multilingual office suite and an open-source project. Compatible with all other major office suites, the product is free to download, use, and distribute. To help build the community, join us.
NeoOffice is a reasonably stable version of the OpenOffice.org office suite that has been engineered to run natively on Mac OS X.
There may be newer Neoffice versions, a much improved version 2.0 should be available for free download in a few days. At the least Neoffice provides Mac users with the ability to read many kinds of documents.
"NeoOffice can open, edit, print, and save all OpenOffice.org and most Microsoft Office documents"
NeoOffice 1.2.2
http://www.planamesa.com/neojava/en/olddownload.php
http://trinity.neooffice.org/modules.php?name=Downloads&d_op=viewdownload&cid=6
-
Dave