Free template
A free assignment tracker template that is also a working app.
Download the CSV and open it in Google Sheets or Excel. Or skip the download: the same structure runs as a live tracker, and the file imports into it with no column mapping at all.
No email required. The CSV is 12 columns and 5 example rows you can delete. The .xlsx is a fuller worked example — a made-up semester with real date cells and four deliberately awkward rows — meant for trying the importer rather than starting from.
The template
What is in the file, and why each column is there.
| Column | Example | What it does |
|---|---|---|
| Due Date | 2026-09-12 or 9/12/2026 | ISO dates never need disambiguating. Both import fine. |
| Class | Organic Chemistry II | Becomes a colour-coded class. Reuse the exact same spelling every time. |
| Class Code | CHM 25600 | Optional. Lets a sheet that says CHM 256 one week and the full name the next still land in one class. |
| Type | Problem set | Assignment, Reading, Quiz, Exam, Lab, Project, Essay, Presentation, Problem set, Discussion. |
| Assignment | Problem set 6 | The only column that is strictly required. |
| Status | todo / doing / review / done | Optional if you use the Completed? column instead. |
| Completed? | TRUE or FALSE | A checkbox column from Sheets exports as TRUE/FALSE and is read correctly. |
| Priority | high / normal / low | Optional. |
| Points Earned | 23 | Optional. Kept with the assignment and written back out in the CSV export. |
| Points Possible | 25 | Optional. Shown as “Worth: 25 points” in the calendar file. |
| Estimated Minutes | 90 | Optional. How long you expect the work to take. |
| Notes | Ch. 14 questions 1-18 | Anything you want. |
Column order does not matter and extra columns are ignored. If you already keep a sheet, you almost certainly do not need this file — the importer will map your existing headers.
If you are staying in the spreadsheet
Three things worth setting up by hand.
A dropdown for Class
In Sheets: Insert → Dropdown, then add each course once. It stops the typos that later split one course into three.
A checkbox for Completed?
Insert → Checkbox. It exports as TRUE/FALSE, which both Excel and this importer read as done or not done.
Conditional formatting on Due Date
Red when the date is before TODAY(), amber within seven days. It is the one formula worth maintaining; the rest tends to break by week six.
The full walkthrough, with every formula tested in a real sheet, is how to make an assignment tracker in Google Sheets. Working in Excel instead? See the Excel assignment tracker.
Try it
The template, running.
This is a synthetic example semester using the template columns. Sort it, filter it, switch views.
Loading the sample semester…
From the file to the tracker
- 1Open the CSV in Sheets or ExcelFill in your own rows. Keep the header row.
- 2Select everything and copyHeaders included — the importer uses them to map columns.
- 3Paste into the trackerOpen the assignment tracker, press Import, and paste.
- 4Check the preview and importEvery row is shown before anything is saved.
Questions
Is there a Google Sheets version of the template I can copy?
Yes, in a simpler six-column layout. The guide on how to make an assignment tracker in Google Sheets has a Make a copy link to a finished sheet with checkboxes, dropdowns, overdue colours and a dashboard, which lands in your own Drive. To start from this twelve-column file instead, download the CSV and use File → Import in Google Sheets.
Does the assignment tracker template work in Excel?
Yes. The file is UTF-8 with a byte-order mark and comma separated, which Excel opens with the correct encoding on both Windows and macOS. Dates are written in ISO form so no locale reinterprets them.
Is the template really free?
Yes, with no email and no account. The live tracker it imports into is free as well, with no cap on assignments or classes.
Can I add my own columns?
Yes. Extra columns are ignored on import, and you can map them to fields like priority or estimated minutes if they match. Nothing breaks if you keep a column the importer does not understand.
Why is the template so plain?
Because a heavily formatted template is the thing that breaks first. Colour, grouping by week and overdue highlighting are handled by the tracker, where they cannot be knocked out by inserting a row.