Seven days in a single sheet
Each day has a dedicated row with a grid of checkboxes for daily tasks and a text field for notes.
Weekly Planner in Google Sheets and Excel — free download
A weekly planner is a free spreadsheet template where you log seven days, set "top three for the week" goals on the Settings sheet while the Dashboard automatically calculates completion percentage and rolls over unfinished items to the next week. Works in Google Sheets and Excel, no sign-up required.
- FreeNo sign-upGoogle Sheets + Excel
Sound familiar?
- I plan the week on paper and forget the top priorities by Friday.
- Unfinished tasks pile up and I restart the whole week every Monday.
- I want to see weekly completion percentage and where I was weak.
- I need to track multiple weeks side by side.
What the template can do
"Top three for the week" block
Three prominent goals that stay visible all week, with a completion checkbox for each.
Completion percentage
Weekly completion percentage updates automatically based on checked items across all days.
Rolling over unfinished items
Items left unchecked by Sunday automatically move to the next week's "Carry over" section with a checkbox to mark as completed.
How to use it — 5 steps
- 1
Open the "Make a copy" link for Google Sheets, or download the .xlsx and open it in Excel.
- 2
On the Settings sheet set your weekly themes and habits — that is the only setup needed.
- 3
Log each day: check off completed tasks and add notes.
- 4
Check the Dashboard weekly: completion percentage and carry-over items.
- 5
Press "Save progress" in the menu to keep changes.
Why a spreadsheet, not an app
Your data stays yours
The file lives in your Google Drive or on your computer. No account on someone else's service and no exporting of your data.
Transparent formulas
Everything is calculated by formulas you can open and edit. No closed code and no monthly fee for "analytics".
Works offline
The Excel version works fully without internet — on a plane, on the road, at a dacha.
What is included
- Google Sheets file with a “Make a copy” link and Apps Script macros
- Offline .xlsx version (Excel 2016+ / Microsoft 365, Windows and Mac) with a macro menu
- An Instruction sheet inside the file: a step-by-step start in your language
- 30 days of demo data so the dashboard comes alive right after copying
Why a weekly planner in a spreadsheet
A spreadsheet beats paper for one reason: you can see how your week went. In a paper planner, the past is on the table; in a sheet every formula is open and the logic can be adapted to you. Weekly planning research keeps showing the same thing: regularly checking off tasks reduces the mental load, because the completion becomes visible the same day instead of at week end.
Weekly Dashboard: at a glance
Two dashboards show everything at once: Progress — weekly completion percentage and carry-over count; Insights — chart of completed tasks by day of week, helping you spot patterns. A top bar shows "Top three" status and remaining items.
Mobile entry option
If you want to enter data from a phone: duplicate the Google Sheet, create a simple Google Form with fields: Week number, Day (Monday‑Sunday), Task (text), Completed (Yes/No). The form writes to the Data sheet, and the dashboard updates automatically.
Ready for scaling
The template includes 8 weeks out of the box. To track more, add weeks on the Data sheet and adjust the count in a few formulas. The dashboard will update automatically: completion percentage and carry-over alerts.
Extensions
You can add a mood column for each day, or link tasks to a task tracker (CSV export). The formulas are open — edit, copy or extend as you see fit.
Ready template
Everything described above is already set up in the Weekly Planner template: seven days, "Top three" goals, completion percentage, carry-over to next week, a dashboard with 8 weeks of demo data. Download the .xlsx or make a Google Sheets copy — free and without sign-up.
If the article helped, you can support it with a donation — but it is optional.
Frequently asked questions
Is it really free and without sign-up?
Yes. The download is direct: no form, no email, no trial period. The site runs on voluntary donations and advertising.
How is this better than a paper planner?
Does it work in Excel on Mac?
Yes, the .xlsx works in Excel 2016 and newer on Windows and Mac. VBA macros live in a separate ribbon menu; if VBA is unavailable, all analytics still work on plain formulas.
Can I use it from a phone?
Yes: enter data through Google Sheets on mobile, or through a duplicate Google Form. Mobile entry is verified against the mobile layout of Google Sheets.
Who can see my weekly plans?
Nobody. The file lives in your Google Drive account or locally on your computer. The site collects no data about the spreadsheet contents.
What if I reset the planner?
Use the "Reset week" button on the Dashboard. You can restore from backup or a duplicate of the ready version.
How many weeks can I track?
The template includes space for 8 weeks, but you can add unlimited weeks on the Data sheet and adjust the count in a few formulas.
Download the template and start using it today — it is free.