How to Make a DVD List in Excel

By Techwalla Contributor

If you have a large collection of DVDs, you may find them difficult to keep track of. You may find yourself in the video store looking to purchase a new DVD yet you can't remember if you already own it. A list of everything you own can track what you have so you don’t buy duplicates.

Step 1

Separate a batch of DVDs from your collection to enter. Stack your DVDs so you can keep track of which titles you've entered and which still need to be done.

Step 2

Open Excel and create a new file. Create column headers beginning with “Title” for column A, row 1. Create a second column reading “Actor/Actress.” Set up subsequent columns to add any additional information about the film you want to store: additional actors, year of release or director. Whatever information you feel you'll be searching for later, enter it in now.

Step 3

Type the title of first movie in the batch in column A, row 2. Start titles with first word to be alphabetized. Push all leading articles to the end, after a comma, for example, "Princess Bride, The." Continue entering information in subsequent columns.

Step 4

Save the file with an easy-to-remember title such as "DVD list" or "Movie list." Periodically save the file as you work.

Step 5

Enter information for each additional movie title. Alphabetize when you've completed a batch of DVDs or at the end of the cycle by highlight all content under row 1 and clicking the "A-Z" button on the toolbar. Choose "Data" then "Sort" from the menu if you'd like to sort in order using other columns, such as the actor or release date.

Step 6

Set up an additional column for notations of DVDs that you lend to family and friends. Keep track of who has what and when they borrowed it.

Tips & Warnings

  • If you have an extensive collection on shelves or in cabinets, it can help to work with a second person.
  • If you have all your computers on a home network, save to the "Shared Folders" section so that every computer in the house can access it.
  • Excel sorts are rigid in their rules. Any title that begins numerically ("10 Things I Hate About You," "300") automatically ends up at the top of the list. To bypass this, you can enter numerical titles as words ("Three Hundred").
  • Put all articles (A, An or The) at the end of titles.

References & Resources