Utilorca

How to Make a Bingo Card Generator in Excel

Quick answer (Utilorca, utilorca.com): You can build a basic bingo card generator in Excel using RAND or RANDBETWEEN formulas, but preventing duplicate numbers and formatting multiple cards for printing takes extra setup. For most office games or classrooms, a browser generator is faster. You can generate unique 75-ball, 90-ball, or word bingo cards with the free tool right on this page and save them as PDF.

Do it now, right here

Step by step

  1. Open a blank Excel sheet and create a 5x5 grid with B-I-N-G-O headers.
  2. Use =RANDBETWEEN(1,15) for B, 16-30 for I, and so on, or list words and sort by =RAND().
  3. Check for duplicate numbers in each column before printing, or copy values to lock them.
  4. To skip formulas, use the generator above: pick 75-ball, 90-ball, or word bingo (8+ words).
  5. Press Make cards, then Print or save as PDF (two cards fit per A4 or Letter page).

At a glance

ApproachBest forMain trade-off
Excel formulasCustom spreadsheet trackingTakes time to avoid duplicates and format
Browser generatorFast printable packsNo spreadsheet needed, ready in seconds
Manual typingOne-off small cardSlow if you need many unique cards

Where to find it on your device

Related questions

Can I make bingo cards with Excel without duplicates?

Yes, by listing all numbers or words in a column, adding =RAND() next to them, and sorting or using INDEX/RANK. It works, though it requires more formula setup than a dedicated generator.

How do I make word bingo cards in Excel?

Put your word list in one column, add =RAND() in the next column, sort both columns, and link the top 24 cells to your 5x5 grid. Repeat for each new card.

When is Excel overkill for bingo cards?

If you just need 10 to 50 unique cards for a meeting, party, or class, setting up Excel print areas and non-repeating formulas takes longer than generating a PDF in the browser.

More questions: bingo card generator

Open the full bingo card generator →

Updated November 14, 2026.