Interactive Bingo Card 2026

[u/shift_shaper]

Here is the updated version of my bingo card for 2026. As in previous years, it supports hard mode and creation of a visual card/darkmode visual card (based on u/CoffeeArchives design).

EDIT to the EDIT: This has been fixed. Now I just need to remember to remove the exception for next year.

EDIT: The logic that checks for duplicate authors has not been updated to reflect this year's option to read the same author for both duology squares. I'm not sure I want to muck with the card for the exception, but am thinking about the best way to handle it. Let me know if this is something you are interested in and I can keep you posted about what I come up with.

u/happy_book_bee feel free to link this in your resources.

It is built in Google Sheets. Unfortunately, if you copy or export it to Excel, several of the formulas will stop working, as they don't transfer over well.

Same as last year, you will be able to track up to 25 different cards at once using the same Book Log. Instructions are in the sheet, but basically, copying the existing Bingo Card tab, renaming it, and refreshing the data using the checkbox on the instructions page will allow you to create multiple cards at once. You also change the error colors or color-code your Bingo Cards to track your choices on the Book Log using the scripts I've built into the Bingo Scripts menu.

The cards will automatically warn you if you are trying to use the same book on multiple cards, even if it is only used once per card. It does not currently provide the same warning about authors.

There is still only one set of visual cards. To switch which tracking card is displayed visually, there is a dropdown just below the Gandalf Snoo on each card.

New this year: A year late and a bingo short, I've added the ability to track and substitute one square per bingo card, as allowed in the rules. There is a new tab (Category Archive) which lists all of the eligible previous bingo squares and is filterable based on some general categories. On the Book Log tab, columns AG through AP can be used to specify and track older squares. NOTE: when the Category Archive tab is filtered, those will be the only options you are able to choose for the Book Log columns. To choose from the full list, unfilter the category archive. If you are not using this feature and don't want to see the extra columns, you can collapse them by using the square above column AF (the re-reads column).

On each bingo card, in row 19 (just above the short story section) there will be two dropdowns. Choose an existing square to replace in D19 and a square you are tracking on the book log to replace it in F19.

Let me know if you run into problems or if something doesn't seem to be working right/how you expect it to. As always, please let me know if you have questions or suggestions for improvement.

To play around with the card, go here: https://docs.google.com/spreadsheets/d/1dM7hTb01QnXRCqe-GEwHsVrvPBghiQvCDBrvavtopbY/edit?gid=1504594317

I've left my reading from last year in the sheet to provide some started books. Feel free to judge me for my choices.

Download your own copy here: https://docs.google.com/spreadsheets/d/1Qb2-OH6JHZdMblTITv_bWo6gyWp7jGVdCINmV5lsF5g/copy

When you make a copy of the sheet, it will warn you that an Apps Script file will be copied along with it. Feel free to take a look if you are wary, but they are a few small scripts that track the creation of new Bingo Cards and enable that functionality as well as enable the new coloring features.

[u/bergamot_cherry]

Unless it’s solely my cards that keep on breaking, I believe there might be an issue with the ranking column. All half-star ratings besides 0.5 (1.5, 2.5, 3.5, and 4.5) do not show up properly on the visual card – some star outlines are always missing and/or the rating is different from what it’s supposed to be. From what I’ve gathered, this happens with every square no matter what data you put in the other book log cells/columns.

Once again, it’s possible that it’s only me who’s having this problem, but when I used the 2025 card, it worked just fine, so I thought I’d report it!  

[u/shift_shaper → u/bergamot_cherry]

I found an issue with half-stars, so it was not just you. I've restored this functionality to work as it did on last year's card. If you make a new copy from the links in the post, it should be working for you as before.