Zepfanman’s mega spreadsheet of movie ratings

Some people like to write reviews on films. I prefer to crunch movie numbers…. I will update this post from time to time with the latest Google Doc mega spreadsheet of movie ratings. Read on (below the spreadsheet) for an explanation. Bookmark this page: zepfanman.com/mymovies

Movies spreadsheet

Last Google upload: 2015 July 22 (3,488 entries). Formats: Web-based, comment-able Google Docs file (embedded below). I keep the frequently-updated XLSX on Dropbox here for download.

It’s best to download the XLSX file to browse the spreadsheet more easily, but 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.


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: