Running Shoe Mileage Spreadsheet: What to Track

A spreadsheet can track running shoe mileage well if you keep it simple.

The danger is building something too clever. If the sheet takes more effort than the run, you will stop using it. The best shoe mileage spreadsheet is boring, fast, and hard to mess up.

Here is what to track.

The Two-Tab Setup

Use two tabs:

1. Shoes
2. Runs

The Shoes tab is the summary. The Runs tab is the log.

Do not try to make one giant table do everything. Separating shoes from runs keeps the system clearer.

The Shoes Tab

Add one row per physical pair of shoes.

Useful columns:

• Shoe name
• Brand
• Model
• Color or nickname
• Date first used
• Starting mileage
• Target mileage
• Current mileage
• Miles remaining
• Status
• Retired date
• Notes

The color or nickname matters more than you think. If you own two pairs of the same model, you need to tell them apart quickly.

The Runs Tab

Add one row per run.

Useful columns:

• Date
• Distance
• Shoe
• Run type
• Surface
• Source
• Notes

Run type can be easy, workout, long run, race, trail, or treadmill. Surface can be road, trail, track, treadmill, or mixed. Source can be Strava, Apple Health, Garmin, manual, or other.

These details help later when a shoe wears faster than expected.

Simple Formulas

You only need a few formulas.

Current mileage:

Add the shoe's starting mileage to the sum of all run distances assigned to that shoe.

Miles remaining:

Subtract current mileage from target mileage.

Status:

Use simple thresholds:

• Fresh: under 60 percent of target
• Watch: 60 to 85 percent
• Replace soon: 85 to 100 percent
• Review now: over target

You can use conditional formatting to color those statuses. Keep it obvious.

What Most Spreadsheets Get Wrong

The biggest failure is not formulas. It is behavior.

Manual tracking breaks when:

• You wait days to enter runs
• Shoe names are unclear
• Treadmill runs are forgotten
• You buy a new pair but do not add it immediately
• Retired shoes stay mixed with active shoes
• You make the sheet too complicated to maintain

The sheet should take less than 30 seconds after a run.

How to Handle Shoe Rotation

If you rotate shoes, never log only weekly mileage. Log each run.

Weekly totals do not tell you which pair took the miles. A rotation only works if each physical shoe has its own odometer.

Use a dropdown for shoe names if your spreadsheet supports it. That prevents typos from splitting one shoe into several accidental names.

How to Handle Starting Mileage

If a shoe is not new, estimate starting mileage.

Do not set it to zero unless it truly has zero miles. A rough estimate is better than a clean lie.

For example, if you wore a pair for six weeks at roughly 10 miles per week, start it at 60 miles. Add a note that the number is estimated.

When a Spreadsheet Is Enough

A spreadsheet works well if:

• You enjoy logging training
• You have one or two pairs
• You run mostly from one source
• You are consistent after every run
• You do not mind maintaining formulas

For some runners, this is perfect.

When to Use an App Instead

Use an app if:

• You rotate multiple pairs
• You forget manual logs
• You run indoors and outdoors
• You use Strava and Apple Health
• You want automatic sync
• You want wear status without spreadsheet maintenance

Treadly exists for runners who want the spreadsheet outcome without the spreadsheet habit.

The Bottom Line

A good running shoe mileage spreadsheet needs two tabs, clear shoe names, a run log, target mileage, current mileage, and simple status rules.

Keep it boring. Update it immediately. If that sounds like a chore, use an automatic tracker instead. The goal is not having a perfect spreadsheet. The goal is knowing when each shoe is ready to replace.