The Simple Way I Track Everything in College
I spent three semesters overcomplicating my workout tracking before settling on something that actually works alongside a class schedule. The short version: use a simple spreadsheet with a specific format, track everything consistently, and don't try to reinvent the wheel. Open Google Sheets or Excel. Create columns for date, exercise name, weight used, reps performed, and notes. That's it. Four columns to start. You add rows as you go, one per set. End of session, you're done. My first approach was downloading a fancy fitness app that promised analytics and progress charts. It took 47 seconds to log each set because of all the menus and categories. After two weeks, I stopped using it. Switched to a plain spreadsheet and cut my logging time to about eight seconds per set. The apps are fine if you actually use them, and most people don't past a certain point.
Here's the structure I ended up using. Date in column A. Exercise name in column B — standard names like bench press, squat, overhead press. Don't get creative here. Column C is your weight. Column D is reps. Column E is any notes like "felt weak today" or "pr at 225 pounds." That's five columns and it covers everything you actually need. The real value comes from how you organize your weeks. I grouped my sheets by month at first, then realized that was useless. Switched to a single sheet with all data and a simple filter. At the end of each week, I scroll through and write down my total volume for each main lift. Weight times reps. It takes about three minutes and gives you a number to beat next week. I hit a wall with this approach around semester three when I started working out at different gyms. Some had different equipment and I'd log an exercise with one name at one school and a slightly different name at another. My data became fragmented and I couldn't track true progress across locations. The fix was creating an exercise mapping column where I'd assign each variation a master category. Barbell bench press, dumbbell bench press, and machine chest press all fall under "bench." Single this way, the filtering still works and you can see your actual progression even when equipment changes.
One thing nobody tells you about tracking is that the numbers will mislead you sometimes. Your warm-up sets aren't useful for progress tracking. They clutter the data. Log only your working sets, the ones that are actually challenging you. A typical upper body day might have six working sets across three exercises. That's six rows. Not twelve with warmups thrown in. Another counter-intuitive thing: record your rest periods. Just add a column for minutes rested between sets. I didn't see why this mattered until I noticed that on days I logged shorter rest times, my numbers on the third and fourth sets dropped consistently. The fix was just letting myself rest longer when needed. Tracking it made the pattern obvious instead of letting me blame some vague feeling of weakness. There are real limitations to this spreadsheet approach. If you miss logging a workout for three weeks straight, the sheet becomes useless. The system requires actual discipline. I have a friend who built a complicated spreadsheet with automated graphs and lost it when his laptop died because he never exported a backup. Upload your sheet to Google Drive or OneDrive. Five seconds to do. Do it every Sunday.
Get the Full Details
Some people prefer a physical notebook. I tried this during a semester where I had no reliable internet access at the gym. It works but you lose the ability to sort and filter later. If you go analog, use a grid notebook and draw your own tables. The pre-printed gym logs they sell are terrible for tracking progress over time because they don't let you revisit previous sessions easily. For the actual setup, I'd recommend starting with this template structure. Create your columns as I described, set the date column to auto-format so you don't think about it, and color-code your rows by workout day if you want visual clarity. Red for push days, blue for pull days, green for legs. Takes about ten minutes to build and saves you mental effort later. If you want a more automated option, look into Notion. It has database features that let you create relationships between workouts and track trends without doing math by hand. The trade-off is setup time. A proper Notion gym tracker takes two to three hours to build correctly. The spreadsheet takes twenty minutes and does 90 percent of the same thing.
The bottom line is that consistency beats sophistication in workout journaling. A basic spreadsheet you use for six months will produce better results than a perfect system you abandon after three weeks because it was too complex to maintain between classes and a job.
