Stay Organized With My Due Date Spreadsheet — Free Printable

How to Use a Due Date Spreadsheet to Stay Organized in College | Free Printable | Free Download | Due Date Spreadsheet | College to Career | Shelly Rawlings
Advertisements
Advertisements

As a college student, it’s crucial to start the semester strong with a consistent method of tracking your assignments—but if a traditional paper planner isn’t your style, you might have better luck with my Due Date Spreadsheet.

Specifically designed for ease of reading—and editing—my college Due Date Spreadsheet takes only a few minutes to compile, but it can save you a ton of time later in the semester.

If that sounds right up your alley, grab your syllabi, then let’s get started!

Set up your Due Date Spreadsheet as you go!
Download your free .docx file here to follow along with this post.


Psst! Don’t have Microsoft Word?
Here’s a Google Docs version of my Due Date Spreadsheet—be sure to “Open with Google Docs,” then click “File” → “Make a copy” to make it your own!)

How to Set Up Your Spreadsheet:

1. Create a table in your preferred word processor.

You can download a blank template of this spreadsheet for free, or you can set it up yourself in a program like Microsoft Word, Pages, or Google Docs. (You can also use Excel or Sheets, but I prefer the user-friendly format of Word—and I’m much more experienced with it.)

If you’re going DIY, you’ll want to include a clear label for the month (as shown), then create a 4-column table with several rows. (You can go back and add rows later if needed.) I suggest adjusting the columns to the length illustrated in the figure below.

Due Date Spreadsheet Blank | MichelleAdamsBlog

2. Make a key for class names.

Next, for each of your classes, assign a highlight color—for fun and ease of reading—and a shortened/abbreviated name, to save space.

Note both in a key—easily created by formatting a 2×3 table, as shown below—so you don’t get scrambled later! (A blank version of this key is located in the footer of your printable.)

Due Date Spreadsheet | MichelleAdamsBlog

3. Input due dates.

Now, it’s go-time. Using your syllabus for each class, record the due date for each assignment and the day of each exam in your spreadsheet.

I’ve found the best way to do this is to do go through each syllabus one-by-one, filling in due dates for each full course one at a time. To start, I put the due date for each assignment in the leftmost column, in chronological order. (I like to include the day of the week, also; M=Monday, etc.)

Then, in the next column, insert the abbreviated class name, highlighted in the correct color, as noted in your key.

Due Date Spreadsheet Free Printable | MichelleAdamsBlog

The next column over houses the name of the actual assignment, whether it’s a reading, test, essay, quiz, or otherwise. You may need to abbreviate or shorten the name of the assignment to fit it in your table—but be mindful that you’ll need to be able to decipher what you wrote later!

On the far right, I label what type of assignment it is (RD=reading, HW=homework, EX=exam, etc.), so I know how urgent it is, and so I can keep track of what needs physical work, and what just needs to be studied.

Don’t be afraid to add rows, pages, and months as needed. Make this spreadsheet work for you!

Don’t forget to download your totally free copy of my Due Date Spreadsheet here before you go, or click here to view it in Google Docs.

How to Use Your Spreadsheet:

Now that it’s all set up, your spreadsheet is ready to act as a planner.

Option 1: Print it out!

This spreadsheet is made to be printed and hung on your dorm wall, so you mark through assignments as you complete them and check on your progress—but you can even carry it around in a folder or a page protector in a binder, if you like!

Option 2: Keep it on your desktop for easy access.

I find that a lot of professors change their due dates around throughout the semester, so I like to keep my spreadsheet editable by leaving it on my computer. This way, I can add, change, or rearrange assignments at any time. I keep track of what I’ve completed by striking through assignments, or even by deleting the entire row!

Option 3: Share it on Google Docs or another cloud-based software so you always have it handy.

If you like to use a physical planner, but want to use this spreadsheet as a reference or a back-up, keeping it accessible from multiple devices might be just right for you! Simply pull it up on Drive whenever you need to double check something and you won’t have to sift through your entire syllabus for the due date of one specific assignment.

Related: 13 Essential School Supplies for College Students: Here’s What You Really Need

Advertisements
Advertisements

I hope this spreadsheet can be of use to you as you work through the upcoming semester. Staying organized is half the battle—so you’re already closer to that 4.0 than you think!

Have you given my Due Date Spreadsheet a try? Share your story in the comments!

Keep in touch!

Want to be the first to know when I publish a new post? Enter your email address below to get new content sent right to your inbox.

Unsubscribe at any time. Read my privacy policy.

This article was first published Jan. 9, 2016.
Last update: Jan. 5, 2021.

11 thoughts on “Stay Organized With My Due Date Spreadsheet — Free Printable

  1. I love love loved this spreadsheet this past semester. It helped keep me organized and stay motivated when I started getting lazy and just being ready for the semester to be over. I was able to keep track of what I had done, if I should work ahead based on trips I had coming up, and definitely made me work harder. All A’s this semester. Thank you!

    Liked by 1 person

Leave a Reply to Nicole Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.