Running Shoe Mileage Log

Who this is for

How far each pair has really gone. List your running shoes, log each run under the pair you wore, and the log keeps a total for every pair and works out what each has cost per unit of distance.

Runners who rotate two or more pairs, anyone who wants to know how much use a pair got before it was retired, and people comparing models on value.

What this helps you track

• Each pair: model, date bought, price and whether it is in use or retired
• The distance run in each pair, run by run and in total
• A running total of all distance logged
• What each pair has cost per kilometre or mile
• The surfaces each pair was used on

How to use it

1. Write your name and the distance unit you will use throughout, kilometres or miles.
2. List up to four pairs as A to D with model, date bought and price; start a new sheet when you need more.
3. After each run, write the date and the distance in the column of the pair you wore, with the surface and any notes.
4. Totals per pair and the running total are worked out in the browser and the workbook; on paper, add each column at the foot of the page.
5. Copy each pair's total into the shoes table to see its cost per unit, and mark it retired with the date when you stop using it.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

When should I retire a pair?

The log does not say, because it depends on the shoe, your weight, your gait and the surfaces you run on. It shows the distance each pair has done so you can compare it with how the shoes look and feel, and with the maker's guidance.

Why are the pairs in columns rather than one column with a name?

It lets the paper sheet and the workbook add up each pair's distance straight down its own column. Four columns covers most rotations; start another sheet if you have more.

What if a pair was already worn when I started logging?

Add a first row with its existing distance under that pair's column and note it as carried forward. The totals and cost per unit then include it.

Can I log walks or races too?

Yes. Anything done in the shoes adds wear, so log it under the pair and note what it was in the notes column.