This Personalized Running Spreadsheet Is My Tech Update of the Week.

Tracking your running progress in a spreadsheet you create yourself is deeply satisfying. No algorithms showing other people’s workouts, no worries about what will happen to your data if the company changes direction or closes. Just you, your metrics, and a system designed exactly the way you want. And when I wrote about this earlier this year, I received some truly touching messages from runners who felt the same way. Many of us runners are tired of relying on apps and are drawn instead to a simple, customizable spreadsheet.

Why create your own spreadsheet?

Of course, there are plenty of fitness tracking apps on the market. Strava , Garmin Connect , Nike Run Club —each has its strengths. But having your own spreadsheet gives you something else: complete control. You can customize your system to suit your specific training needs. I also like the approach that comes with creating your own tracking system.

There’s also the simple economics. Spreadsheets are free. There are no paid plans, subscriptions don’t expire, and they don’t suddenly lock out features you’ve been using for months. Plus, creating custom charts and graphs to visualize your progress becomes a matter of a few clicks, rather than waiting for the app to update and add the exact layout you need.

This isn’t the first spreadsheet I ‘ve shared with my Lifehacker community, but it might be my masterpiece: a running tracker that records every workout, automatically calculates weekly mileage, visualizes training load over time, and helps me plan for specific race goals. It’s evolved over months of use, shaped by what truly matters when I lace up my running shoes each morning.

Here it is . If you like the spreadsheet idea but don’t like my spreadsheet, that’s fine! I’m not even crying about it! Let’s see how you can improve your own DIY running tracker.

What to Track (and What to Skip)

The key to creating an effective workout tracking spreadsheet is to track what’s truly helping you without overwhelming yourself with data entry. Here’s what I think is worth recording:

• The main fields are date, distance, time, and pace. These four fields form the basis of any useful running diary. They allow you to calculate your weekly mileage, track your progress, and identify trends over time.

• Context : the route or location, the weather conditions, and how you felt during the run. These qualitative details help you understand the story behind the numbers. A slower pace might be justified if you remember it was 95 degrees Fahrenheit, or you were running hills, or you decided to run slower now to run faster later .

• Workout details : type of run (easy, tempo, interval, long), elevation gain if relevant to your workout, and any specific workout structure. This will help you balance different types of training, rather than just racking up extra miles.

What I don’t track: Every calorie I burn (those estimates are notoriously unreliable).

Setting up your system

Start simple. Create columns for your core data and add a few simple formulas: total weekly mileage, average weekly pace, maybe a monthly total. Google Sheets and Excel make this easy, and you can always add more complex formulas later.

Try organizing your training by using separate tabs for different goals. I have one tab for my main training log, where each row represents a workout; another for monthly summaries with automatic totals and averages; and a third for goal tracking, where I can see my progress toward specific race results or mileage goals.

The beauty of creating your own system is that you can refine it. After a month of tracking, you’ll notice which information you really need and which just clutters the spreadsheet. Perhaps you thought you’d be interested in your step count but never looked at it, or maybe you regretted not tracking your shoes so you could know when to replace them. Make adjustments accordingly.

Visualization

Numbers in rows tell one story, but charts and graphs reveal patterns you might otherwise miss. Create a simple line graph showing your weekly mileage over time, and you’ll instantly see when you’re increasing your training volume, when you’re reducing it for recovery, and whether your current training volume is sustainable.

I like to use a few standard visualizations: a line graph of weekly mileage, a bar chart comparing monthly metrics over the year, and a scatter plot showing the relationship between distance and pace to determine my comfortable running range. None of these require advanced spreadsheet skills—most programs will automatically create decent charts once you’ve selected the data.

Result

The point isn’t to use my system exactly, but to understand that you can create something that better suits your needs than any one-size-fits-all app. Your workouts are unique—your goals, your schedule, your body, your understanding of progress. Why not track them in a way that reflects your unique characteristics? Keep what works, discard what doesn’t, and enjoy this improvement in your life.

More…