Free Period Tracker â Cute Pastel Excel Cycle, Ovulation & Mood Tracker with Dashboard
Free
What it does
Log a little each day and this pastel Excel tracker does the rest. It spots each new period from the flow you log, learns your average cycle and period length, and predicts your next period, fertile window and ovulation day â no app, no account, everything stays in your own file.
- Dashboard â next period countdown, today’s cycle day and phase, fertile window, ovulation day and average cycle, with gentle status messages and a tip for each phase
- Colour-coded calendar â period, expected period, fertile days, ovulation and late days at a glance; switch to last month or look up to 2 months ahead
- 6 cute charts â cycle wheel, period & fertile windows for each cycle, cycle & period length, sex per cycle (protected vs unprotected), mood mix and top symptoms
- Daily Log â simple dropdowns for flow (spotting, light, medium, heavy), mood, 9 symptoms, ovulation test result, sex (protected / unprotected) and notes, with 3 years of days ready to go
- Smart alerts â late period reminders, and a heads-up if unprotected sex is logged during your fertile window
- My Cycles history â every cycle listed with start date, period days, cycle length, estimated ovulation, fertile window and symptom days, plus a cycle length chart
- Protected formulas â only the white cells can be edited; everything else is locked and hidden so nothing breaks by accident
How to use
- On the Start Here tab, enter the first day of your last period (and your usual cycle length if you know it).
- Each day, pick your flow, mood and anything else from the dropdowns on the Daily Log.
- Open your Dashboard â predictions get smarter with every cycle you log.
Who it’s for
Girls and women who want a private, pretty way to track their period, PMS, moods and fertility without another app. Made with love and given away free by Macro-Tools đ
What’s included
- 1 Excel workbook (.xlsx): Start Here, Dashboard, Daily Log and My Cycles
- An example copy filled with 4 months of sample data, so you can see every feature working
Good to know
Predictions are estimates based on your own logged history (ovulation is estimated about 14 days before your next period). This tracker is not a method of contraception and is not medical advice. Please talk to a doctor or nurse if your periods are very painful, very heavy or irregular.
Requirements
Microsoft Excel 2016 or later, including Excel 2019, 2021 and Microsoft 365 (Windows or Mac). Not designed for Google Sheets.
This is a digital download. No physical item will be shipped. Your file is available to download immediately after checkout.
Template Features
- Ready to use: just type in the blue input cells
- Formulas locked and hidden so nothing breaks by accident
- Drop-down lists and automatic status colours
- Dashboard and summaries update instantly
- Sample data included so you can see it working
- Built-in How to Use sheet
Software Compatibility
- Microsoft Excel 2010 or later
- Excel 2016, 2019, 2021 and Microsoft 365
- Windows and Mac
- Not designed for Google Sheets or Numbers
Skill Level Required
- Beginner friendly: no formulas, macros or add-ins needed
- Clear instructions on the How to Use sheet
- Works out of the box with your own data
Download & Licence
- Instant download after checkout (.xlsx file)
- Lifetime access from your account
- Use for personal or internal business use
- Reselling or sharing the file is not permitted










