Zepfanman’s mega spreadsheet of movie ratings

Some people like to write reviews on films. I prefer to crunch movie numbers. Read on (below the spreadsheet) for an explanation. Bonus: Check out my ongoing 10 Years 10 Films project, a history of film since 1888!

Bookmark this page: zepfanman.com/mymovies

Movies spreadsheet

2020 update: Use my frequently-updated XLSX Dropbox link for the latest spreadsheet. I usually edit it at least once a week. As of April 13th, I’m at 5800 entries.


Last Google upload: 2015 July 22 (3,488 entries). The only reason I’m posting this outdated link is because it’s easy to embed in this blog, so you can browse it a little bit here. You can also comment on it. Google Docs file:


Here is a brief explanation of some of the column headers. I’ve attached comments to some of the header cells, too.

  • My: My IMDb vote (1 to 10)
  • Calculated: A recent method I’ve adopted for rating movies based on performance, cinematography, script, plot, and mood (this one counted twice) to give an average score out of 100.[1]
  • Source: The medium I’ve used—or want to use—to watch the film (in theater, Blu-ray, Netflix, etc.)
  • AVG rating: An average of the IMDb, Rotten Tomatoes, and Metacritic scores.
  • Bechdel: Assigned a 1, 2, or 3 according to the film’s Bechdel Test for Women in Movies.
  • LGBTQ: Scale of relevance to LGBTQ issues. Similar to Bechdel, there is now a Vito Russo Test.
  • LFPL: Louisville library system DVD availability. The next column shows the Wild & Woolly video store availability.
  • MIDZ: A unique identifying number for each film in my spreadsheet.

Explanation

Over the years, I’ve used various methods[2] to track and rate the films I’ve seen and want to see. Likely the only thing that will remain consistent are my IMDb lists (which I’ve been using since 2000), but I’m going to give this more detailed method a go.

I got to thinking about doing this when my friend Priscilla expressed interest in watching all of Lars von Trier’s films (which I posted about in April). We then did Miyazaki’s films. Next, I thought it would be good to dig a little further for more obscure films by directors in marginalized groups (women, LGBT, foreign, etc.). Clearly, a spreadsheet or database is the best way to organize these kinds of films. I started by using the handy IMDb list export (to CSV) on my “Seen” and “WantToSee” lists. With some tweaking, I was able to come up with a single file mega spreadsheet of “Zepfanman movies”. It will be a challenge to keep it updated, but this makes it easy for me to sort through and filter to find the movies I’m looking for.

Here are a couple of interesting stats off the top of my head:

  • I’ve seen 229 of the 1001 Movies You Must See Before You Die (actually about 1056 after 10 editions of the book). And NO, I do not plan on seeing all 1001!
  • I don’t have an exact count, but it looks like about 30 movies of the 1001 are directed by women. I’m pretty sure NONE of the IMDb Top 250 are directed by women. This is disturbing.

1 The inspiration for my rating system comes from Jack Lessard at Filmsquish.com; see his categories in blue on that page for details. He also hosts the 1001 Movies You Must See Before You Die Blog Club (notice my “1001 Must See…” column). Another member of the club, Chip Lary, posts lots of Lists from Chip similar to my spreadsheet, but separated by topic.

2 Here are a few notable movie-list posts on Zepfanman.com: