Workout Planner Spreadsheet for Excel: Your 12-Week Fitness Program in One File
Formbright is a workout planner spreadsheet and complete fitness tracker for Microsoft Excel. Plan each training day, log your sets, reps and weight, tick off what you finish, and the workbook does the rest. Statuses, weekly totals, a monthly workout calendar, personal records, next-session targets and a live dashboard all update by themselves. No app subscription, no formulas to write.
It goes well beyond a gym log. Formbright also tracks your weight, body measurements, sleep, water and steps, daily habits, a 75 Soft (or Medium, Hard or custom) challenge, your goals and your meals, so everything that drives your results lives in one tidy, beginner-friendly workbook.
Who It Is For
- Beginners who want a simple, guided way to plan workouts and stay consistent
- Gym-goers and lifters who want a progressive overload tracker and PR log without paying monthly for an app
- Anyone on a weight loss or body recomposition journey who wants workouts, food and habits in one place
- Home workout, Pilates, HIIT and cardio fans: the focus list and exercise library cover them all
Main Benefits
- See progress instantly. Tick a set and your day status, weekly totals, PRs and dashboard charts update immediately.
- Train smarter. The progressive overload coach compares your last top set with your target reps and tells you to add weight or repeat.
- Stay consistent. Missed days are flagged in coral, rest days grey out, and streaks keep you motivated.
- Save time. Set your units, targets and start date once in Settings. Every date, label and calculation follows.
Features of This Fitness Tracker Spreadsheet
Plan and log workouts
- 12 weekly workout planners (a full 12-week program), each with 7 day cards: focus dropdown, start time, minutes, star rating, 10 exercise rows and 3 cardio rows
- Automatic volume (sets × reps × weight), cardio pace, progress bars and Done / Partial / Missed / Planned / Rest status
- Weekly summary sidebar with planned, completed and missed sessions, daily progress, weekly totals and a check-in
- Exercise library with 144 exercises, muscle groups, equipment and coaching cues (room for 300)
- 12 workout templates (full body, upper/lower, push pull legs, glutes, home dumbbell, HIIT, Pilates, mobility) plus 5 weekly split ideas
Strength tracking
- PR tracker for 15 lifts: sessions, best weight, estimated one-rep max, PR date, last weight and reps
- Progressive overload coach with a next-session target for every lift
- Lift progress chart by week, 1RM calculator (Epley, Brzycki, Lombardi) with a training load table, and a plate calculator for lb or kg plates
Dashboard and calendar
- Automated fitness dashboard with 8 KPI tiles and 5 charts: workouts per week, weight trend, training volume by muscle group, weekly volume and minutes, and habit consistency
- This week at a glance, top lifts with next targets, body snapshot, goals and wellness averages
- Monthly workout calendar that fills itself in from your weekly planners, with monthly totals and consistency
Body, habits and goals
- Weight loss tracker with change, 7-entry moving average, BMI, goal progress bar and trend chart
- Body measurement tracker for 10 areas with waist-to-hip and waist-to-height ratios
- 84-day wellness log for water, sleep, steps, calories, protein, mood and energy
- Habit tracker for 15 habits with streaks, consistency, perfect days, best habit and a daily chart
- 75-day challenge tracker (75 Soft, Medium, Hard or custom) with up to 6 rules, streaks and an optional strict mode
- Goal tracker with 12 goal cards, 6 action steps each, rewards and automatic status
Nutrition
- Meal library with macros and ingredients (24 starter meals, 40 slots)
- Weekly meal planner with daily calories, protein, carbs and fat compared with your targets
- Grocery list that builds itself from your meal plan, combines quantities and groups items by aisle, plus extra items and a budget in your own currency
What’s Included
- Formbright Workout Planner (.xlsx) with 28 tabs
- Illustrated user guide (.docx, 19 pages) covering setup, every feature, customizing, tips, troubleshooting and FAQs
How It Works
- Open Settings and add your name, program start date, lb or kg, height, goal weight and daily targets.
- Plan Week 1: choose a focus for each day and pick exercises from the dropdowns (or copy a template).
- Tick ✓ as you train. Status, volume, PRs and next targets calculate instantly.
- Check the dashboard and calendar to see your progress. Repeat for 12 weeks.
File Format and Software Requirements
- Microsoft Excel .xlsx file for Excel 2019, 2021, 2024 or Microsoft 365 on Windows or Mac
- Also opens and calculates in LibreOffice Calc
- Not designed for Google Sheets, Apple Numbers or Excel 2016 and older
- Uses the standard Arial font, so nothing extra to install
Customization
Choose Imperial (lb, in, mi) or Metric (kg, cm, km) and any currency symbol. Rename the workout focus list, muscle groups, equipment, grocery aisles and goal categories, and every dropdown updates. Add your own exercises and meals. Formula cells are locked without a password so you cannot break them by accident, and you can unprotect any tab if you want to restyle or edit formulas.
Digital Download
This is an instant digital download. You will receive the Excel workbook and the user guide right after purchase. No physical item will be shipped. For personal use only: please do not share, resell or redistribute the files.
Use Cases
- Following a push pull legs or upper/lower split and tracking progressive overload each week
- Running a 12-week weight loss program with workouts, weigh-ins, measurements and meal planning together
- Completing a 75 Soft challenge while logging workouts and habits
- Building a home workout routine with dumbbells, Pilates or HIIT and seeing your consistency improve
- Getting back into the gym as a beginner with templates, a guided setup and clear next steps
Frequently Asked Questions
Does this workout planner work in Google Sheets?
It is built and tested for Microsoft Excel (2019 or newer, including Microsoft 365) and LibreOffice Calc. Google Sheets and Apple Numbers are not supported.
Can I use kilograms instead of pounds?
Yes. Pick Metric in Settings and every label, BMI and the plate calculator switch to kg, cm and km.
Is it good for beginners?
Yes. There is a 4-step Start Here page, dropdowns everywhere, 12 ready-made workout templates and a step-by-step guide.
How does the progressive overload tracker work?
For each key lift it finds your last ticked session. If you hit your target reps, it suggests adding your chosen increment; if not, it suggests repeating the weight.
Can I use it for more than 12 weeks?
Each copy covers one 12-week program. Save a fresh copy of the original file to start your next block.
Does it include a meal planner and grocery list?
Yes. Plan a week of meals from your meal library and the grocery list builds itself, grouped by aisle, with a budget.
Is there a free version?
Yes. Formbright Lite (one weekly planner, weight tracker and a 5-habit tracker) is available free in our free 12 week workout plan template article so you can try it first.
Formbright is for general fitness planning and is not medical advice. Consult a professional before starting a new exercise or nutrition program.











Reviews
There are no reviews yet.