How to Build a Weekly Assignment Planner in Google Sheets (Free Template)

Why Build Your Own Assignment Planner in Google Sheets?

Pre-made planner apps and printable PDFs work fine — until you need a column that doesn't exist, a color scheme that matches your brain, or a way to track something your professor just announced. That's the ceiling of a fixed template. Building your own weekly assignment planner in Google Sheets removes that ceiling entirely.

A DIY spreadsheet gives you total control over layout, categories, and automation. You decide which columns matter (subject, assignment, due date, priority, status — or anything else). You set the rules for color coding. You add checkboxes, dropdown menus, and conditional formatting that highlights deadlines before they sneak up on you. And because it lives in Google Sheets, it's free, works on any device with an internet connection, and updates in real time if you share it with a study group or accountability partner.

There are no ads, no data tracking, no subscription upsells. The only cost is the 20 minutes it takes to set it up once. After that, you clear the data at the end of each semester and reuse the same structure for the next term. That's the core value proposition: one build, years of use, zero recurring friction.

Google Sheets Features You'll Use (No Experience Needed)

You don't need to be a spreadsheet power user to build this planner. Three built-in features do all the heavy lifting. Here is what each one does in plain language:

• Data Validation (Dropdown Menus) — This restricts a cell to a list of options you define. Instead of typing "Math" every time, you pick it from a dropdown. That means no typos, no inconsistent labels, and no wasted keystrokes. You will use this for Subject, Priority, and Status columns.
• Conditional Formatting (Automatic Color Coding) — This tells Google Sheets to change a cell's background or text color when a condition is met. For example: if a due date is tomorrow, turn the cell red. If it is due this week, turn it orange. If it is due this month, turn it yellow. The colors update automatically as dates change, so you always see urgency at a glance.
• Checkboxes (Status Tracking) — A single click inserts a checkmark into a cell. You can use checkboxes to mark assignments as done, and optionally pair them with conditional formatting to visually gray out completed rows. This gives you a satisfying visual cue of progress without deleting anything.

That is the entire toolkit. Three features. No formulas beyond basic date comparisons. If you can click a menu item and type a word, you can build this planner.

Step 1: Set Up Your Column Headers

Open a new Google Sheet and label the first row with the columns that will organize your assignments. The five core columns are:

• Subject — The course or class name (e.g., Biology, English 101, Calculus II).
• Assignment — A short description of the task (e.g., "Chapter 5 Review Questions" or "Lab Report Draft").
• Due Date — The deadline. Format this column as a date (select the column, go to Format > Number > Date) so Google Sheets recognizes the values as dates rather than plain text.
• Priority — A label for urgency level. You will turn this into a dropdown with options like Urgent, High, Normal, and Low.
• Status — Whether the assignment is still to do or already done. This will also become a dropdown (To Do / Done) or a checkbox column, depending on your preference.

Place these headers in row 1, from left to right, in the order that makes sense to you. Many students prefer Subject first because it groups assignments by class when they scan the sheet. Freeze row 1 (View > Freeze > 1 row) so the headers stay visible as you scroll down through the semester.

Step 2: Add Dropdown Menus for Subject, Priority, and Status

Dropdown menus turn free-form typing into a single click. They also ensure consistency — every "Biology" entry is spelled exactly the same way, which matters if you later filter or sort by subject.

How to create a dropdown:

1. Select the column where you want the dropdown (e.g., column A for Subject).
2. Go to Data > Data validation.
3. Under "Criteria," choose "List of items."
4. Type your options separated by commas — for example: Math, Science, English, History, Elective.
5. Check "Show dropdown list in cell" and click "Save."

Repeat the same process for the Priority and Status columns with these recommended options:

Once the dropdowns are in place, entering a new assignment takes about five seconds: pick the subject from the menu, type the assignment name, enter the due date, set the priority, and mark the status. No typing errors, no formatting inconsistencies.

Step 3: Apply Conditional Formatting to Color-Code Due Dates

This is the feature that transforms a static list into a visual urgency dashboard. Conditional formatting scans your Due Date column and applies a background color based on how close each date is to today. The standard system, used by popular planner templates like the one from 101Planners, uses three color tiers:

How to set up the rules:

Select the entire Due Date column (click the column letter, e.g., C). Then go to Format > Conditional formatting. In the sidebar that opens, you will create three separate rules. Each rule needs a custom formula because Google Sheets does not have a built-in "due tomorrow" option.

Rule 1 — Red (Due Tomorrow)

=C2=TODAY()+1

Set the fill color to red. This formula checks if the date in cell C2 is exactly one day from today. The reference (C2) should match the first data cell in your selected column — Google Sheets will automatically apply the rule to the rest of the column.

Rule 2 — Orange (Due This Week)

=AND(C2>TODAY(), C2<=TODAY()+7)

Set the fill color to orange. This formula catches any date that is after today but within the next 7 days. It excludes tomorrow (already covered by the red rule) and dates beyond a week.

Rule 3 — Yellow (Due This Month)

=AND(C2>TODAY()+7, C2<=TODAY()+30)

Set the fill color to yellow. This rule highlights dates that fall between 8 and 30 days from today — far enough out that you have time, but close enough that you should not ignore them.

Once all three rules are saved, any date you enter into the Due Date column will automatically turn red, orange, or yellow depending on how close it is. The colors update every time you open the sheet, so you never have to manually check which deadlines are approaching.

Step 4: Add Checkboxes for Quick Status Updates

Dropdown menus work well for status, but checkboxes offer a faster interaction: one click marks an assignment as done, and the visual checkmark gives an immediate sense of progress.

How to add checkboxes:

1. Select the Status column (or a new column you label "Done").
2. Go to Insert > Checkbox.
3. Every cell in the selected column now shows an unchecked box. Click it to check it; click again to uncheck.

Optional: Gray out completed rows automatically.

You can pair checkboxes with a conditional formatting rule that strikes through or grays out an entire row when the box is checked. Create a new conditional formatting rule with the custom formula:

=$E2=TRUE

Replace E with the column letter where your checkboxes live. Set the formatting to a light gray fill and, if you want, a strikethrough text style. Now, when you check a box, the entire row dims — a clear visual signal that the assignment is finished and no longer needs your attention.

Free Template: Copy and Customize Your Own Planner

If you would rather skip the setup and start using the planner immediately, a pre-built template is available with all five columns, dropdown menus, conditional formatting rules, and checkboxes already configured. You can copy it to your own Google Drive and start entering assignments in under a minute.

To copy the template: click the link, then go to File > Make a copy. Rename it for the current semester (e.g., "Fall 2026 Assignment Planner") and save it to your Google Drive. The original template stays untouched, so you can make a fresh copy each term.

Optional Advanced Features to Level Up Your Planner

Once the core planner is running, you can extend it with additional sheets and columns. These three enhancements add functionality without complicating the main assignment tracker.

• Grade tracker integration column: Add a column for "Grade" or "Score" next to Status. When an assignment is marked Done, enter the grade you received. Over the semester, you can use the AVERAGE function to calculate your running grade in each subject without switching to a separate grade calculator.
• Weekly time-blocking sheet: Create a second tab in the same Google Sheet labeled "Weekly Schedule." Set up a grid with time slots (8:00 AM to 10:00 PM) as rows and weekdays as columns. Each week, drag assignments from the main planner into specific time blocks. This connects what you need to do (the assignment list) with when you will do it (the schedule).
• Semester overview tab: Add a third tab that lists every assignment sorted by due date across the entire semester. Use a simple =SORT() formula that pulls data from the main planner sheet. This gives you a bird's-eye view of busy weeks and potential conflicts — useful when you are deciding whether to take on an extra project or need to plan around exam periods.

Each of these additions lives on its own tab within the same file, so the main assignment planner stays clean and focused on daily use.

Tips for Keeping Your Planner Working All Semester

A planner is only useful if it stays current. These five habits take minimal time and prevent the sheet from becoming a static list you stop checking.

• Clear old data weekly or at the end of each term. Completed assignments accumulate fast. At the end of each week, select and delete the rows marked Done (or archive them to a separate "Completed" tab). At the end of the semester, clear all data while keeping the headers, dropdowns, and formatting intact — your planner is ready for the next term in one click.
• Keep the structure intact. Do not delete or rename columns mid-semester unless you update the conditional formatting rules and dropdown ranges to match. Structural changes break the automation. If you need a new column, add it to the right of the existing ones rather than inserting it between them.
• Use the mobile Google Sheets app. Between classes, pull out your phone, open the app, and add an assignment the moment the professor announces it. The dropdowns and checkboxes work on mobile. A 30-second entry now saves you from forgetting the deadline later.
• Review the planner daily for five minutes. Pick a consistent time — morning coffee, right after lunch, or before closing your laptop. Scan the Due Date column for red and orange cells. Update the Status column for anything you finished. Five minutes of maintenance prevents the "I forgot that was due today" panic.
• Share with a study group or accountability partner. Click the Share button in the top-right corner of Google Sheets and enter their email with "Viewer" or "Commenter" access. They can see your deadlines and check in on your progress. For group projects, give "Editor" access so everyone can update shared tasks in real time.