As teachers, we’re always juggling a million little tasks, from keeping track of homework and progress monitoring to collecting permission slips and more. If you’re anything like me, your desk can quickly become cluttered with sticky notes, and when it’s time to find what you need, it’s gone. That’s where a simple checklist can be a total lifesaver! And one of the easiest ways to make one is right inside Google Sheets! In this blog post, I’ll show you step-by-step how to create a checklist in Google Sheets (with checkboxes!), plus share ideas for how you can use them in your classroom.
Want more tips for using Google apps as a teacher? Check out these blog posts:
- Google Drive Organization for Teachers
- Google Keep for Teachers (Plus 70 FREE Google Keep Headers)
- How to Save Google Chrome Tabs and Open Them With 1 Click
Why Use a Google Sheets Checklist As a Teacher?
Checklists keep your classroom (and your brain!) organized. But it can take forever to write out exactly what you want to include on a checklist on paper. And finding a checklist template online that has everything you need, and that can be customized to your students’ names can be a challenge. Oftentimes, the templates you find online just aren’t formatted to your liking.
A digital checklist in Google Sheets is a great option if you’re looking for something that’s:
- Always accessible: Open it from any device, anywhere.
- Easy to duplicate: Reuse the same format for new assignments or class projects.
- Visual for progress tracking: Checkboxes make it easy to see what’s done at a glance.
- Shareable: Collaborate with team teachers or even with students.
Teacher-Friendly Google Sheets Checklist Ideas
There are endless ways to use a Google Sheets checklist in your classroom, but here are a few of them (that I have personally used):
- Assessments
- Assignments tracking
- Beginning-of-the-year paperwork
- Exit tickets
- Field trips
- Goals
- Homework completion
- Misc. fees
- Money turned in
- Parent communication
- Parent conferences
- Permission forms
- Progress monitoring
- Standards
Want to skip the steps for creating your own? I’ve got you covered with these premade, fully editable, Google Sheets Checklists for Teachers! Choose your favorite color scheme (black and white, rainbow brights, calm pastel, or boho neutral) and all of your own text!
I’ve even included a half sheet option that would allow you to create your customized classroom list and print two per page. But if you want to create your own, keep scrolling to learn how!
How To Create a Checklist in Google Sheets: Step-by-Step Directions
Step #1: Open a New Google Sheet
First, open up a new Google Sheet and name it at the top. The fastest way is to type sheets.new into your browser. This opens a fresh spreadsheet that’s ready for you to customize. Isn’t that a great teacher tech hack?!
Step #2: Format Your Sheet
- Set font & size: Highlight all cells by clicking the top left gray square. Choose a teacher-friendly font (I like Lexend) and adjust the size.
- Create a title: Select the top row, merge cells across your desired columns, and type your checklist title. Center it horizontally, vertically align it to the middle, increase the font size, and give it a background color so it stands out.
- Delete unwanted cells: Select the columns and rows you don’t need by clicking the first cell, hitting shift, and clicking the last cell. This should highlight all the cells you don’t want. Right-click and hit “Delete columns.”
- Add borders: Select your cells → Borders → All borders. Choose thickness and color for easy printing.
Step #3: Organize Your Columns
To organize your columns, think of it like a gradebook:
- Column A: Student number (select entire row, right click, and resize row height to 125 pixels for space).
- Column B: Student name (select entire column, right click, and resize column width to 200 for long names).
- Columns C–L: Tasks/items to track or check off. Select all columns and in the task bar, click Text Orientation → Rotate Up so long assignment names fit neatly. In the task bar, click Text Wrapping → Wrap so nothing gets cut off. Center text if you’d like.
Pro Tip: Add alternating colors by highlighting everything and clicking Format → Alternating colors to make rows easier to scan.
Step #4: Add Student Numbers & Names
- Type the first few numbers (1, 2, 3), highlight them, then drag down to autofill.
- Enter your student names in Column B.
Step #5: Add Checkboxes
- Highlight the cells where you want checkboxes (e.g., C3–L20).
- Go to Insert → Checkbox.
- If you want consistent checkbox colors, highlight them and set the text color to black.
And that’s it… your Google Sheets checklist is ready to use! Student names, tasks, and checkboxes all in one place!
Step #6: Save and Reuse Your Google Spreadsheet Checklist Template
The best part about using Google Sheets checklists is that you can save them and reuse them. No more starting from scratch every time.
Here’s how to use your Google Spreadsheet checklist template:
- Right-click the tab name at the bottom of the sheet.
- Select Duplicate.
- Rename your new sheet for the next assignment, field trip, or unit.
This creates a master template you can reuse endlessly.
Step #7: Print (Optional)
Want a paper version of your Google Sheets checklist to share with parents, admin, or other team teachers?
Go to File → Print and adjust:
- Page orientation (portrait or landscape).
- Fit to page/height.
- Borders and colors.
Note: Different printers will have different settings. If fit to page doesn’t work for you, try a different setting until it looks normal.
Make Teaching Easier with Checklists
Learning how to create a checklist in Google Sheets is a game-changer for teachers. You can track assignments, stay on top of paperwork, and keep your classroom running smoothly, all with one simple spreadsheet.
Another great way to utilize Google Sheets checklists in your classroom? To keep track of the resources you’ve downloaded, printed, and prepped from inside Inner Circle Math Membership!
This membership is packed with guided math units (AKA – done for you math lessons), math centers, math organization resources, games, planning tools, and MORE to save you hours each week.
And because giving teachers access to differentiated resources is so important to me, you’ll get instant access to ALL of my resources for 1st-3rd grade when you join for just $10.99 a month. It’s all in one place so you can easily search, browse, download, and teach!
Love this post? Save it to your favorite Pinterest board so you can revisit this Google Sheets checklist tutorial any time you need!