Wellness Tracker Google Sheets 2027: An Automated Health Dashboard for Mood, Sleep and Habits
Quick answer: The 2027 Wellness Tracker from Aura and Archive is an automated spreadsheet for Google Sheets and Excel. You log mood, energy, sleep, water, steps, exercise, weight, symptoms and up to 8 habits in one row a day. The dashboard then builds weekly to annual charts, streaks and a printable doctor report for you.
Why track your wellness in a spreadsheet?
Memory is a poor record keeper. Most of us can say how we felt yesterday, but not how we slept across the last six weeks or which habits slipped in March. A simple daily log fixes that. Once the numbers are in one place, patterns show up on their own.
Sleep is a good example. CDC data from the National Health Interview Survey show that about 69.5% of US adults got enough sleep in 2024. That leaves roughly 3 in 10 adults falling short. If you are one of them, seeing your own weekly sleep average is often more useful than any general tip.
Movement works the same way. The CDC says adults need at least 150 minutes of moderate activity a week, such as 30 minutes a day, 5 days a week. A tracker that totals your steps and exercise by week shows whether you are close to that goal or far from it.
A spreadsheet also beats a paper log in one big way: it does the math. You type, and the averages, streaks and charts update without any extra work.
What the 2027 dashboard shows
The Dashboard tab is the heart of the file. One dropdown switches every chart and tile between five views.
- 5 views: Weekly, Monthly, Quarterly, Half-yearly and Annual. Pick a period, or leave it blank to see the current one.
- 8 summary tiles with up and down arrows that compare each number with the previous period.
- 6 trend charts: mood and energy, sleep, water, habit completion, steps, and habits this period.
- Goals and streaks: current streak, best streak, perfect habit days, logging rate and goal days.
- 6 pie charts for mood mix, sleep quality, logging, habits, activity and exercise.
- A habit table with progress bars for each habit.
What is inside: 18 tabs
The file has 18 tabs. Here is what the main ones do.
| Tab | What it does |
|---|---|
| Start Here | Step-by-step setup instructions |
| Settings | Your name, kg or lb, daily goals and up to 8 habits |
| Daily Log | 365 dated rows for 2027 with checkmark dropdowns and color coding |
| Insights | A correlation analyzer that shows what tends to go with better mood and energy, plus good days vs other days |
| Monthly Summary | Averages, totals and goal days, with charts |
| Habit Heatmap | Completion percentage for every habit, every month |
| Year in Pixels | Your mood for every day of 2027, colored automatically |
| Meal and Nutrition Log | Meals, fruit and vegetables, home-cooked meals and day ratings |
| Weight and Body | Weight trend chart, goal tracking and monthly measurements |
| Cycle Tracker | Period log with average cycle length and a next period estimate |
| Medications and Supplements | Daily ticks, refill dates and monthly adherence |
| Gratitude and Mood Journal | Three gratitudes, kind words and daily prompts |
| Monthly Goals and Reflection | Word of the year, 3 goals a month, wins and lessons |
| Wellness Wheel | Score 8 life areas each month and compare them on a radar chart |
| 30-Day Challenge | One small wellness action a day with a progress percentage |
| Doctor Report | A printable one-page summary for any dates you choose |
How to use it in about a minute a day
- Download the PDF from Etsy (You, then Purchases and Reviews).
- Click the link inside and choose Make a copy. The copy is yours in your own Google Drive.
- Fill in the Settings tab once: units, daily goals and your habits.
- Log one row a day in the Daily Log. Then open the Dashboard and pick a view.
| When | What to do |
|---|---|
| Daily | Fill in one row: mood, energy, sleep, water, steps, exercise and habit ticks |
| Weekly | Switch the Dashboard to Weekly and check the arrows on each tile |
| Monthly | Read the Monthly Summary, score the Wellness Wheel and write your reflection |
| Before an appointment | Set the dates on the Doctor Report tab and print the one-page summary |
Google Sheets or Excel: which should you use?
Both work. Google Sheets is free with a Google account, saves automatically and runs on the Sheets phone app, so you can log from your phone at night. Excel works well if you prefer a file on your own computer. The tracker supports Excel 2010 or newer, and an .xlsx file is included.
Bringing your data to a doctor visit
The Agency for Healthcare Research and Quality (AHRQ) encourages patients to prepare before an appointment, write down their questions and bring a list of the medicines they take. The Doctor Report tab helps with that. Choose a date range, and it pulls your sleep, mood, symptoms and medication adherence into one page you can print or show on your phone.
Read the Insights tab with care. It shows what tends to happen together, not what causes what. If poor sleep and low mood line up, that is a useful question to ask your clinician, not a diagnosis. The cycle tracker gives estimates only and is not a form of birth control.
Who this tracker suits
- People who want a 2027 fresh start and like seeing progress as charts.
- Anyone who would rather type a quick row than fill in paper pages.
- People with regular check-ups who want a tidy summary to share.
- Paper planner fans who want a digital companion to our 2027 habit tracker printable or the New Year Reset Planner 2027.
What you get
- A PDF with your private link to make your own copy in Google Sheets.
- An Excel (.xlsx) file for Excel 2010 or newer.
- Six months of sample data so you can see every chart working, plus clear steps to clear it and start fresh.
- Protected formulas, so nothing breaks by accident.
- This is a digital download. Nothing is shipped. Files are for personal use only.
Ready to see your year in charts?
Get the 2027 Wellness Tracker for Google Sheets and Excel from Aura and Archive on Etsy.
Free Nurtavia tools to try
- Sleep Score Calculator: rate last night before you log it.
- Water Intake Calculator: find a daily water goal to enter in Settings.
- Stress Level Test: a quick check-in to pair with your mood log.
Trusted sources
Frequently asked questions
Does the 2027 wellness tracker work in Google Sheets and Excel?
Yes. You get a PDF with a private link to make your own copy in Google Sheets, which works with a free Google account and the Sheets phone app. You also get an .xlsx file for Excel 2010 or newer.
Is it a printable planner, and what sizes does it come in?
It is a digital spreadsheet, not a set of printable pages, so there are no paper sizes to choose. The Doctor Report tab is a one-page summary you can print from Google Sheets or Excel for any date range you pick.
Do I need to know spreadsheet formulas?
No. Everything is automated and the formulas are protected. You fill in Settings once, then log one row a day. Six months of sample data is included, with steps to clear it and start fresh.
Can I track weight in pounds?
Yes. The Settings tab lets you choose kg or lb, set your daily goals and name up to 8 habits.
Does this tracker replace medical advice?
No. It is a personal tracking tool. The Insights tab shows patterns, not causes, and the cycle tracker gives estimates only and is not for contraception. Share your Doctor Report with a qualified health professional and follow their advice.
Keep exploring
- 2027 Habit Tracker Printable: How to Build Habits That Stick
- New Year Reset Planner 2027: A Gentle 3-Step Plan for a Fresh Start
- Supplement Tracker: How to Log Vitamins, Magnesium, Omega-3 and Creatine
- Browse the Aura and Archive shop on Etsy
This article is general information only. It is not medical or mental health advice. For questions about your sleep, mood, weight, cycle or medicines, please see a qualified health professional.