Skip to content
52-Week Savings Challenge cover: a sample sheet with target for the year, saved so far and still to save and a column chart, beside the Dashboard and Weeks tabs

52-Week Savings Challenge

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Anyone wanting a savings habit that starts small and grows each week can use this file. The Weeks tab lists weeks 1 to 52 with the amount to save, the amount actually saved, the date and the quarter it falls in. The Dashboard shows the yearly target, the total saved so far, the amount left and a column chart comparing target and saved for each quarter. Sample entries fill the first ten weeks, which shows how the tabs behave in use.

Keep the savings in a separate account, or in an envelope you do not touch, so the money is not mixed with everyday spending. If you miss a week, catch up later with a larger deposit or let the total trail behind. Change the amounts in the To save column if you prefer another pattern, such as a flat weekly figure. The quarter labels feed the breakdown, so keep them when you add or edit rows.

Useful for

  • Build a first emergency cushion over one year
  • Teach a teen a weekly saving habit with visible progress
  • Fund a small holiday budget before December ends

What's included

  • 3 tabs: Dashboard, Weeks, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Weeks: 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 Weeks 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

How much does the full challenge save?

Adding week one through week 52 gives 1,378 dollars. Each week's amount is one dollar more than the week before, so the deposits grow steadily across the year. The total equals 52 times 53 divided by two, which is a handy check if you change the figures.

What if I start late in the year?

Start on any Monday and keep the same weekly amounts. The total will be smaller if you stop before week 52, but the Dashboard recalculates from the rows you fill. Use the quarter breakdown to see how far you got in each part of the year.

Can I change the amounts?

Yes. Edit the To save column to any pattern you like, such as a flat fifty dollars a week or a sequence that starts at five. The Dashboard totals follow the new figures. Keep the week numbers in order so the quarters still line up with their rows.

  • #savings-tracker
  • #savings-challenge-52-week
  • #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…