How do I add album art and create a list ( in WORD, EXCEL, etc. ) of my music from Yahoo Music Jukebox?

Posted by admin on March 26th, 2010 and filed under music artist list | 1 Comment »

Most of the album art is already there. I recently loaded a few new CDs and no art work showed up. Also trying to figure out how to create a list of my music. Artist, album,track, etc.
I want to export the data I already have in the Music Jukebox to create the list.

You could do this in either Word or Excel but I prefer Excel.
Start by creating titles across row A for all the things you want to track (artist,song,genre,date,etc). Then add your data in these columns.
You can sort by any column(s) you want when you are done.
It would be best if you highlighted this whole block of cells and gave it a range name. This way you can do edit/goto/rangename to highlight the block in the future. You can insert a row anyplace in the middle of the block (not the start or end) and re-sort when you want to add a new record.

One Response

  1. Don R Says:

    You could do this in either Word or Excel but I prefer Excel.
    Start by creating titles across row A for all the things you want to track (artist,song,genre,date,etc). Then add your data in these columns.
    You can sort by any column(s) you want when you are done.
    It would be best if you highlighted this whole block of cells and gave it a range name. This way you can do edit/goto/rangename to highlight the block in the future. You can insert a row anyplace in the middle of the block (not the start or end) and re-sort when you want to add a new record.
    References :

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.