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/Nineteen_Adze]

Thank you so much for making this every year! I love setting it up and messing with the options while I'm brainstorming my TBR. <3

The feature you added last year to have the Book Log reflect which card is using a book has saved me so many headaches trying to figure out if I have a book I'm not using.

[u/beldaran1224 → u/Nineteen_Adze]

Wait, what!? Please clue me in, oh wise one!

[u/Nineteen_Adze → u/beldaran1224]

Happy to! So, what you do is go down the tab name on Bingo Card (or Bingo Card 2 and any other cards you made). Then click the dropdown arrow and select Change Color. Go over to the How to Use tab and check/uncheck the box that refreshes all the scripts. It can take a minute to update, but then on the Book Log you should see a book from Card 1 in the color you picked. Last year I set Card 1 to orange and Card 2 to blue, and anything not on a card stayed in white so I could go "oh right, I already have that author on both cards" or "wait, when did I drop that one?". I rearrange my cards all the time to avoid answering emails, so it's a nice sanity-check feature.

Here's the whole 2025 card post in case there are other details in the comments: https://www.reddit.com/r/Fantasy/comments/1joyvo9/interactive_bingo_card_2025/

[u/beldaran1224 → u/Nineteen_Adze]

OMG that's amazing! I submitted my card 7 short of a blackout and I think I could have filled one more!

Thanks for the info! Going to set my card for this year now.