Template · 6 min read · Updated June 2026

Free college spreadsheet template for semester planning

A clean, copy-pasteable college spreadsheet template you can drop into Google Sheets or Excel in under two minutes. Track every assignment, exam, and project for the whole semester — no sign-up required.

TL;DR

Copy the CSV below, paste it into Google Sheets or Excel, then replace the sample rows with your own classes. Want it done automatically? Sylly builds the same tracker from your syllabus PDFs →

Free college spreadsheet template

This template works as an assignment tracker template, a semester planner, or a weekly workload view. The columns cover everything you actually need: course, assignment, type, due date, estimated hours, status, priority, and notes.

college-semester-template.csv

Course,Assignment,Type,Due Date,Est. Hours,Status,Priority,Notes
ENGL 110,Essay rough draft,Writing,2026-09-15,3,Not started,High,Submit via Canvas
MATH 151,Problem set 3,Homework,2026-09-17,2,Not started,Medium,Ch. 4 odd numbers
HIST 200,Midterm exam,Exam,2026-10-05,6,Not started,High,Coverage through unit 3
PSYC 101,Research participation,Activity,2026-09-22,1,Done,Low,Two credits earned
BIOL 120,Lab report,Lab,2026-09-29,4,Not started,Medium,Include graphs

How to use the template

Step 1 — Copy it into a spreadsheet

Open sheets.new or Excel. Paste the header row into row 1, then paste the sample rows below it. You can delete the sample data once you see how the columns work.

Step 2 — Add every assignment from your syllabi

Go through each syllabus and add one row per assignment, exam, quiz, lab, project milestone, and reading. Keep the Type column consistent (Essay, Exam, Homework, Lab, Quiz, Project, Reading) so filtering is easy later.

Step 3 — Format Due Date as a date

Select the Due Date column, then Format → Number → Date. Sort the whole sheet by Due Date so the next deadline is always at the top.

Step 4 — Add dropdowns for Status and Priority

Select the Status column, then Data → Data validation, and add Not started, In progress, Done. Repeat for Priority with Low, Medium, High. Dropdowns keep your filters from breaking.

Step 5 — Build a weekly view

On a second tab, paste this formula to see only the next 7 days of work:

=QUERY(Sheet1!A:I, "select A, B, D, G where D >= date '"&TEXT(TODAY(),"yyyy-mm-dd")&"' and D <= date '"&TEXT(TODAY()+7,"yyyy-mm-dd")&"' order by D")

Pin the tab as "This Week" and check it every Sunday.

Optional upgrades

Days Left formula: in a new column, use =IF(F2="Done", "", D2-TODAY()) to see how many days remain per assignment.
Conditional formatting: highlight overdue rows red and completed rows green so the sheet surfaces what matters.
Workload sum: add a cell at the top that sums Est. Hours for the current week so you know when you are overloaded.

When a spreadsheet starts to slow you down

Spreadsheets are a great starting point, but they come with hidden costs: typing every assignment by hand, updating dates when professors move deadlines, and rebuilding the sheet every semester. For a busy student, that manual work adds up fast.

Sylly does the same thing automatically. Upload your syllabus PDFs and it extracts every assignment, exam, and recurring class — then builds a color-coded semester plan and weekly planner you can sync to Google Calendar.

Skip the copy-paste. Upload your syllabus.

Sylly turns every syllabus into a tracked, color-coded semester plan. Assignments, exams, lectures, and readings — extracted automatically.

FAQ

Is this college spreadsheet template free?

Yes. You can copy the template above into Google Sheets, Excel, or any spreadsheet app at no cost.

Can I use this as an assignment tracker template?

Absolutely. The columns are designed for assignment tracking: course, assignment, type, due date, estimated hours, status, priority, and notes.

How do I make a weekly view from this template?

Add a filter view sorted by Due Date, or create a second tab with a QUERY or FILTER formula that shows only assignments due in the next 7 days.

Is there a faster alternative to a college spreadsheet template?

Yes — Sylly reads your syllabus PDFs and automatically builds the same tracker, with color-coded classes, a weekly planner, and one-click Google Calendar sync.

Keep exploring: Google Sheets tracker guide · Assignment tracking system · Syllabus to Google Calendar

← All guides · Back to Sylly