Arts >> Music >> Songs & Lyrics

How to Make a Music Index

It doesn't take long for your collection of music to grow to epic proportions. Your personal catalog of downloads and CDs can get out of control if you do not keep up. Create an index system to get your collection organized. Take it on as a weekend DYI project. Once you get it started, set a date to update your index once a month. That way, when it's time to make a comp for a party or to share music, you will have your collection organized and ready to access and enjoy.

Things You'll Need

  • Microsoft Excel
  • Paper (optional)
  • Binder (optional)
Show More

Instructions

    • 1

      Review your existing music formats for everything you own, including downloads, CDs and even vintage recordings you might have on vinyl records or cassette tapes.

    • 2

      Use a software program such as Microsoft Excel to set up a "master" list to index your collection as a "stand-alone" index list that you can access independently without having to go through an online program such as Windows Media or iTunes, which may limit your index to music stored on the digital library for that particular software program.

    • 3

      Create horizontal columns labeled as follows: artwork, artist, album title, song title, source, genre and notes. Enter data for each album on the Excel spreadsheet. Limit the listing to the music you own if you downloaded specific tracks and do not own all of the tracks on the entire album.

    • 4

      Use the "source" column to identify where your music is "housed," such as on a CD, download or vinyl.

    • 5

      Use the "genre" column to identify the style of the music, such as hip-hop, rap, pop, jazz, soul, classical, etc.

    • 6

      Use the "notes" column to add special information, such as whether the track is a live recording, or personal reminders, such as whether the song was played at a wedding or birthday party or designated a "must have" for a party mix.

    • 7

      Review information on your Windows Media or iTunes files to complete missing information such as the genre or song titles.

    • 8

      Consider adding a final tab on the horizontal column to create your own short reviews of songs and star-shaped graphics to rate selected songs.

    • 9

      Use the Internet to find JPEGs or GIFs for the artwork for each album, and eliminate the need to scan album covers. Save the artwork as a JPEG or GIF file. Label each artwork file with the name of the artist. Insert the album artwork under the "artwork" column for each listing of songs from that particular album on your music index. Resize the artwork (if needed) to a thumbnail size visual to keep the look of your music index consistent.

    • 10

      Sort the list after you have finished entering all data onto the Excel spreadsheet so you will have an organized way to access songs at a glance. Highlight the column for the name of the artist or the genre, based on your preference to sort your music index. Click on the "Data" tab, then select "Sort" tab, alphabetically from A-Z.

    • 11

      Make any adjustments to how the Excel program sorts the list so that the final version is user friendly and customized to your needs, tastes and preferences.

    • 12

      Save the file to your hard drive on your PC or laptop. Copy the file to a CD or flash drive for backup purposes.

    • 13

      Set a time to update your index system on a monthly or quarterly basis. Add music you have acquired to keep your system current.

Songs & Lyrics

Related Categories