A sobriety tracker that counts the days and helps you understand them
Dawnmark is a sobriety tracker and recovery journal in one download. The spreadsheet does the counting and the math, so you can open it any morning and see exactly how far you have come. The fillable journal gives you room to reflect, notice patterns and plan for hard moments. It is supportive and non-judgmental, and it works alongside any recovery program, therapy, treatment, faith community, app, or none at all.
Enter your day one once. From then on, the dashboard shows your days sober, weeks, months, a years-months-days breakdown, an hour count, the money you are no longer spending, how much you have not taken and the hours you have reclaimed. Your three reasons sit right on the dashboard, where you will see them.
Who it is for
- Anyone stepping away from alcohol, drugs, gambling, nicotine or another habit, whether it is day one or year five
- People in a 12-step or other mutual-support program, secular groups, therapy, outpatient treatment, a faith community, or going it alone
- Sober-curious people doing a dry month or a 30, 60 or 90 day challenge
What the sober day counter spreadsheet does
Recovery dashboard
- Big days-sober counter, plus weeks, months, hours and a years / months / days breakdown
- Money saved, amount not taken and hours reclaimed, calculated from your own typical spend
- Next milestone with date, days to go and a progress bar
- Urges in the last 30 days, average intensity (compared with your first month) and the share of urges you rode out
- Your top trigger and your most helpful coping action, picked out automatically
- Mood and cravings over the last 30 days, support sessions, goals done, longest streak and total sober days across every streak
- Four charts: urges per week, top triggers, weekly mood and cravings, and money saved over 24 months
Milestones and money saved calculator
- 39 milestones from 24 hours to 25 years, including 30, 60, 90 and 100 days, every month of the first year, 500 days and 1,000 days, plus six of your own
- Target date, date reached and money saved by each milestone, with space to plan a celebration
- One currency setting ($ by default; choose €, £, R, C$ and more, or type your own)
- Projections from 30 days to 10 years, a wish list that shows the date you will have saved enough, and a savings jar to log money you actually set aside
Craving and urge log with trigger charts
- Log date, time, intensity 1 to 10, situation, trigger, feeling (Hungry, Angry, Lonely, Tired and more), what you did, how long it lasted, intensity afterwards and the outcome
- The Patterns tab charts your triggers, feelings, time of day and weekday, ranks the coping actions you use most, and finds the one that lowers intensity the most
- A 12-week trend of urges, intensity, mood, cravings and support
Check-ins, support, goals and fresh starts
- Daily check-in log: mood, energy, sleep, cravings, HALT, gratitude, a win and an intention
- Meeting and support log for any kind of support, with mood before and after
- Support contacts with US helplines already listed, goals with progress, and a Fresh Starts tab that keeps every earlier streak counted
The printable recovery journal
The 72-page journal is fillable in Adobe Acrobat Reader and prints cleanly on US Letter or A4. It is undated, with clickable tabs on every page.
- Safety and Support page with withdrawal safety and helplines, My Reasons, My Day One with a milestone ladder, My Support Circle and My Triggers and Plan
- The HALT check and an urge surfing guide with a personal coping toolkit
- 30 daily check-in pages, 8 weekly reflections and 6 urge surfing note pages (12 urges)
- Milestone celebration pages for 24 hours, 1 week, 30 days, 90 days, 6 months and 1 year
- 90-day tracker, year-at-a-glance tracker, meeting and support log, goals and a money saved worksheet
- Two “A Fresh Start” pages: relapse is not failure, with a practical reset plan
- Letter to my future self and notes pages
What is included
- Dawnmark-Sobriety-Tracker.xlsx (13 tabs)
- Dawnmark-Recovery-Journal-US-Letter.pdf and Dawnmark-Recovery-Journal-A4.pdf (72 pages each, fillable)
- Dawnmark-User-Guide.docx with step-by-step instructions, screenshots, tips and troubleshooting
How it works
- Open the workbook in Excel or upload it to Google Sheets.
- On the Settings tab, enter your day one, your currency, what you used to spend and your three reasons.
- Log urges, check-ins and support whenever you like. The dashboard and charts update on their own.
- Use the journal each day, print the pages you want, and turn to a milestone page when you reach one.
File formats and software
The spreadsheet is an .xlsx file for Microsoft Excel 2016 or newer (Windows and Mac), Microsoft 365 and Google Sheets (free with a Google account). It uses no macros, add-ins or external links. Apple Numbers is not supported. The journal is a fillable PDF: type in Adobe Acrobat Reader (free on desktop, iPad and Android) or print at home. The guide opens in Word, Google Docs or any word processor.
Customization
Choose your currency, rename what you are stepping away from, and edit the drop-down lists for triggers, feelings, coping actions and support types. Formula cells are locked so nothing breaks by accident, and sheets unprotect with no password if you want to restyle them.
Digital download
This is a digital product. No physical item ships. You can download the files right after purchase. Personal use only; please do not share or resell the files.
Real situations where it helps
- Day one after deciding to quit drinking, when the first 24 hours and first week feel huge
- An alcohol-free month or a 90-day challenge
- Bringing your urge log and patterns to a therapist, counselor or group
- Planning a sober holiday season around your riskiest days and times
- Starting again after a slip, without losing sight of the days you already stayed sober
Sobriety tracker FAQ
Does it work with a 12-step program, a secular group or therapy?
Yes. It is non-denominational and works alongside any program or none. Dawnmark is not affiliated with or endorsed by any recovery organization.
Can I track something other than alcohol?
Yes. Name what you are stepping away from in Settings and adjust the triggers, units and wording to fit.
What happens if I relapse?
Log the earlier streak on the Fresh Starts tab and enter a new day one. Your earlier sober days still count toward your total and longest streak.
Does the money saved calculator use my currency?
Yes. One setting controls the currency symbol for every money value. Dollars are the default.
Can I use it on my phone?
The spreadsheet works in the Google Sheets and Excel apps, though a larger screen is easier. The journal works in Adobe Acrobat Reader on iPad and Android.
Is this medical advice?
No. It is a personal tracker and journal. Stopping some substances, such as alcohol or benzodiazepines, suddenly can be dangerous, so talk to a doctor first. The SAMHSA National Helpline (1-800-662-4357) is free, confidential and open 24/7, and the 988 Suicide & Crisis Lifeline is available by call or text.



Reviews
There are no reviews yet.