docs / articles / Create Bingo Cards in Google Sheets: Step-by-Step Guide

Create Bingo Cards in Google Sheets: Step-by-Step Guide

Sara Jul 09, 2026 2026-07-09 04:40:45

Creating bingo cards can be a fun and engaging activity, and with Google Sheets, you can make this process even more interactive and efficient. Whether you're planning a game night, a classroom activity, or a virtual event, follow this step-by-step guide to learn how to make bingo cards in Google Sheets.

Google Bingo Cards - 10 Pages
Google Bingo Cards - 10 Pages

Before we dive into the process, ensure you have a Google account and access to Google Sheets. If you're new to the platform, don't worry – we'll keep the instructions simple and easy to follow.

Create Your Own Bingo Cards: Free Printable Templates
Create Your Own Bingo Cards: Free Printable Templates

Setting Up Your Bingo Cards

To begin, open a new or existing Google Sheets document. The size of your bingo card will depend on the number of squares you want. For a standard 5x5 bingo card, follow these steps:

Bingo Game Patterns
Bingo Game Patterns

1. Click on the first cell (A1) and type the word "BINGO" across the top, with each letter in a separate cell (A1 to E1).

Filling the Bingo Squares

Click for Your Free Canva Template: How to Create Your 2025 Vision Board Bingo Card
Click for Your Free Canva Template: How to Create Your 2025 Vision Board Bingo Card

Now, let's fill in the remaining squares with your desired content. You can use numbers, letters, or even images. For this example, we'll use numbers.

1. In cell A2, type the formula "=RAND()". This will generate a random number between 0 and 1.

2. Drag the small square in the bottom-right corner of the cell to copy the formula across the entire row (A2 to E2).

Easy Conference Bingo
Easy Conference Bingo

3. Repeat steps 1 and 2 for each row, creating a 5x5 grid of random numbers.

Formatting Your Bingo Card

To make your bingo card more visually appealing, you can apply some basic formatting:

a printable game for children to play with the numbers and letters that are missing
a printable game for children to play with the numbers and letters that are missing

1. Select the entire range of cells (A1 to E5).

2. Click on "Format" in the menu, then choose "Conditional formatting".

Bingo Calls List - Bingo Lingo to Download and Print
Bingo Calls List - Bingo Lingo to Download and Print
the crossword puzzle is shown with different colors and shapes, including one for each letter
the crossword puzzle is shown with different colors and shapes, including one for each letter
a printable alphabet game with the letters and numbers to match it's colors
a printable alphabet game with the letters and numbers to match it's colors
Free Printable Kindness Bingo Board
Free Printable Kindness Bingo Board
a black and white photo of a printable game board with the word bingo on it
a black and white photo of a printable game board with the word bingo on it
the square and squares are labeled in black, with numbers on each side to indicate their names
the square and squares are labeled in black, with numbers on each side to indicate their names
the words and numbers on this page are all in black, with white letters that spell out
the words and numbers on this page are all in black, with white letters that spell out
National Lab Week Word Search
National Lab Week Word Search
Easy Back to School Bingo
Easy Back to School Bingo
Blank Bingo Card Templates 5x5, 4x4 & 3x3 - Free PDFs
Blank Bingo Card Templates 5x5, 4x4 & 3x3 - Free PDFs
Picture Bingo Maker — Free Printable Bingo Cards for Classrooms
Picture Bingo Maker — Free Printable Bingo Cards for Classrooms
Free Printable Travel Bingo Cards | Flanders Family Home Life
Free Printable Travel Bingo Cards | Flanders Family Home Life
How to Create Free Printable Bingo Cards with Charming Designs for Printable Games Fun
How to Create Free Printable Bingo Cards with Charming Designs for Printable Games Fun
Creative Bingo Card Ideas for Staying In
Creative Bingo Card Ideas for Staying In
Exciting Summer Bingo Card Ideas for 2026
Exciting Summer Bingo Card Ideas for 2026
FREE Printable Kindness BINGO
FREE Printable Kindness BINGO
Custom Bingo Card Template - 13 Free PDF Printables | Printablee
Custom Bingo Card Template - 13 Free PDF Printables | Printablee
four printables are on the table with pens and pencils next to them
four printables are on the table with pens and pencils next to them
Easter Bingo FREEBIE (8.5 × 11 in).pdf - Google Drive Easter Bingo Game Board, Easter Party Game Ideas, Kids Religious Education Tools, Printable Easter Bingo, Religious Easter Activities, Christian Easter Bingo, Easter Bingo For Sunday School, Easter Bingo Free Printable, Easter Bingo Religious
Easter Bingo FREEBIE (8.5 × 11 in).pdf - Google Drive Easter Bingo Game Board, Easter Party Game Ideas, Kids Religious Education Tools, Printable Easter Bingo, Religious Easter Activities, Christian Easter Bingo, Easter Bingo For Sunday School, Easter Bingo Free Printable, Easter Bingo Religious
ADORABLE BINGO CARDS SET A
ADORABLE BINGO CARDS SET A

3. Under the 'Format cells if...' drop-down, select 'Equal to'.

4. In the 'Value or formula' field, type "=MOD(ROW(),5)=0 OR MOD(COLUMN(),5)=0". This will apply formatting to the border cells.

5. Choose the formatting style you prefer (e.g., fill color, border color, text color), then click 'Done'.

Creating Multiple Bingo Cards

If you want to create multiple bingo cards, you can easily do so by copying and pasting the existing card:

1. Select the entire range of cells (A1 to E5).

2. Right-click and choose "Copy".

3. Click on the cell where you want to place the new bingo card (e.g., F1).

4. Right-click and choose "Paste special", then select "Values only". This will create a new bingo card with unique numbers.

Generating Bingo Numbers

To generate a list of bingo numbers for your game, follow these steps:

1. In a new or existing Google Sheets document, type the numbers 1 to 75 in the first column (A2 to A76).

2. Click on the first cell (A1) and type the word "BINGO" across the top, with each letter in a separate cell (A1 to E1).

3. In cell A2, type the formula "=RAND()".

4. Drag the small square in the bottom-right corner of the cell to copy the formula across the entire row (A2 to E2).

5. Repeat steps 3 and 4 for each row, creating a 5x5 grid of random numbers.

6. Sort the numbers by clicking on "Data" in the menu, then choosing "Sort A → Z". This will create a list of bingo numbers in ascending order.

Now that you know how to make bingo cards in Google Sheets, you can create engaging and interactive games for various events. Happy gaming!