Skip to content
College Savings Plan cover: a sample sheet with plans compared and highest college target and a column chart, beside the Dashboard and Plans tabs

College Savings Plan

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Parents and grandparents planning for a child's education can use this sheet to test different school types. Each child and school type gets its own line on the Plans tab, with the child's age, the cost of a year today, a yearly cost rise, the expected return, the amount saved and the monthly deposit. The sheet works out the years left, the cost when the child starts, a four-year target, the projected savings, the gap and the monthly amount needed to close it.

Use cost figures from the schools you are comparing, and check current published prices before you rely on them. The cost rise and return rate are assumptions, so try lower and higher values to see how sensitive the result is. Revisit the plan each year and update the saved amount from the statement. Tax-advantaged education accounts have their own rules, so confirm current details before you choose one.

Useful for

  • Compare state and private school costs for each child
  • Set a monthly deposit for a toddler's future tuition
  • Check whether savings are on track for a four-year degree

What's included

  • 3 tabs: Dashboard, Plans, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Plans: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Plans tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Why does the sheet use 18 as the start age?

The sheet assumes a child starts college at 18 and studies for four years. Years to college is 18 minus the current age, and it stops at zero. If your plan starts later or runs longer, change the formula in the Years column and the multiplier in the target.

What is the expected return used for?

It is the yearly growth you assume for the money saved, applied monthly. The projection and the monthly figure both depend on it. Use a rate you think is realistic for the type of account, and test a lower figure to see the more cautious outcome.

Does the target include future cost rises?

Yes. The cost a year today grows by the yearly cost rise until the child starts, and the target is four of those years. Set the rise to the figure you expect, and compare the result with real tuition history before you commit.

  • #savings-tracker
  • #college-savings-plan
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…