TidySheetHouse
Undated Teacher Planner Spreadsheet cover
Excel + Google Sheets · Instant download

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.

See it on EtsySold and delivered by Etsy as an instant digital download. The price is shown on Etsy in your currency.

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.
Good to know
  • 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

See it on Etsy