Undated Teacher Planner Spreadsheet
Set your first day of school once: calendars, weekly plans, gradebook and attendance date themselves.
An undated teacher planner for the whole school year, and the next one. Set your first day of school once and every calendar and weekly planner dates itself. Includes a color-coded class schedule, weekly planners, printable lesson plans, a weighted gradebook and an attendance tracker, in Microsoft Excel AND Google Sheets. Fully editable.
What You Get
- Teacher-Planner-Timetable.xlsx — your planner, ready to fill in
- DEMO version — a filled-in example to see every tab in action
- Quick start PDF
12 Tabs
- Start Here — 4 simple steps
- Setup — your name, school, school year, first day of school, week starts Sunday or Monday; up to 10 classes (each gets its own color), 10 periods with times, grading scale, grade weights, 60 important dates
- Timetable — pick a class for every period; colors follow automatically
- Year at a Glance — 12 months from your first day of school, Sunday or Monday start, important dates highlighted
- Week 1–4 — type a Monday: days date themselves and your classes appear; plan objectives, materials and homework. Four tabs, so last week's plans stay
- Lesson Plan — printable one-page plan: objectives, standards, materials, warm-up, instruction, practice, assessment, differentiation, homework, reflection
- Gradebook — 35 students × 20 assignments, weighted averages and letter grades calculate themselves; low scores highlighted
- Attendance — monthly grid, P / A / L / E dropdown, totals and attendance rate
- To-Do — checklist with due dates; done tasks fade, overdue ones turn red
Why This One
- Undated and reusable — change one cell next August
- Fully editable — every tab, every color (not “partially editable”)
- Works in Excel and Google Sheets
- Every planner tab prints on one page
How It Works
- Download instantly after purchase
- Open in Excel, or upload to Google Drive and open with Google Sheets (free Google account)
- Fill in Setup once, build your timetable — then plan, grade and track
Inside the file
These images are drawn from the real workbook, so what you see is what you download.






Questions
- Is this a subscription?
- No. You pay once, and the files are yours to keep and reuse.
- Does it work in Google Sheets?
- Yes, in Google Sheets and in Excel.
- Which school year is it for?
- Any. Change the first day of school in one cell.
- Can homeschool parents use it?
- Yes. Classes, periods and grades are all editable.
- Designed by me with the help of digital tools, including AI — then tested formula by formula
- Digital product — nothing will be shipped
- Set it up on a computer in Excel or Google Sheets (not tested in Apple Numbers). The Etsy app can't open downloads — use etsy.com › Purchases
- Requires Microsoft Excel 2010+ / Microsoft 365, or a free Google account
- Questions? Send me a message — happy to help
More templates

2027 Budget Spreadsheet
Budget by paycheck: every payday of 2027 with the bills it has to cover, plus sinking funds and a debt-free date.

Small Business Bookkeeping Spreadsheet
Log a sale or a purchase in seconds and get your profit and loss statement and dashboard automatically.
Seller Profit & Fee Tracker for Etsy Shops
See every fee on every order, your real profit per product, and the price you need to hit your margin.

Wedding Planner & Budget Spreadsheet
Guest list, RSVPs, seating, caterer counts, budget and vendor payments in one simple file.

Couples Budget Spreadsheet
Split shared bills fairly, even when your incomes differ, and see who owes whom each month in plain words.

Cleaning Business Pricing Calculator
Quote homes and commercial jobs from your real costs and see your margin before you say a number.

Cleaning Business Bundle
The pricing calculator and the bookkeeping tracker together: price every job and track every dollar.