Perimenopause Tracker Spreadsheet, Menopause Symptom Tracker with Hot Flashes, Sleep, Cycles, HRT and Doctor Summary, Google Sheets Excel
A perimenopause and menopause tracker for symptoms day by day, your cycles, hormones and refills, doctor visits, and a summary you can show your doctor.
🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): https://docs.google.com/spreadsheets/d/1UzufcZd-UquvT6nRVJVoi14_p-Tfd3V2nmsIjl6cOZo/edit?gid=262815019
📊 WHAT IT DOES
✓ Daily Log: one line a day with hot flashes as a count, night sweats, anxiety, brain fog, aches and low mood from 0 to 3, sleep, bleeding and triggers.
✓ A score for each day, and a flag for a rough day, a short night, or bleeding outside a period.
✓ Cycles: each period with the gap since the last one. Long gaps and short cycles are flagged, and the days toward twelve months without a period are counted.
✓ Meds: hormones and supplements with the dose, how often, refill dates and the cost per month. A new dose is a new line, so the history stays.
✓ Visits: every appointment, what they said, the next step and the follow-up.
✓ Summary: the last 30 days, the 30 before, and before and since treatment, symptom by symptom, with week by week and two charts.
📂 WHAT'S INSIDE: 6 TABS AND 2 CHARTS
✓ Start here: five cells and how to rate
✓ Daily Log: four cards and one line a day
✓ Cycles: four cards and every period
✓ Meds: four cards and everything you take
✓ Visits: four cards and every appointment
✓ Summary: four cards, before and since, week by week, and two charts
📝 HOW IT WORKS
- Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
- On Start here, type your next doctor visit and the day you started or changed treatment.
- On Daily Log, add one line a day. Add each period on Cycles and what you take on Meds.
- Before an appointment, open Summary: it compares the last 30 days with before treatment.
📥 WHAT YOU GET
✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
✓ A filled example to look around, and a blank copy for your own use
✓ A PDF guide with screenshots, the links and the first steps
✓ A video guide for this spreadsheet (the link is in the PDF)
💻 GOOD TO KNOW
✓ Works with a free Google account. No app, no ads, no subscription.
✓ Ratings go from 0 for none to 3 for severe. A blank cell counts as none.
✓ Twelve months in a row without a period is menopause. Cycles counts the days for you.
✓ Room for 400 days, 40 periods, 30 medicines and supplements, and 40 visits.
✓ It is a record, not medical advice. Your doctor decides your treatment.
✓ Formulas are protected, so you can't break anything by accident.
✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for the daily line on your phone.
✓ The photos show Google Sheets. The Excel file has the same tabs and formulas (the jump links between tabs are a Google Sheets feature).
✓ On a Mac? Use free Google Sheets or Excel for Mac.
✓ Free updates for life.
This is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.