Beep Test Spreadsheet

beep spreadsheetI have created a Microsoft excel spreadsheet that can be used to record and analyze the results of your athletes or teams. There are two example sheets, one for single athlete results, the other for recording squad or team results.

The spreadsheet contains columns for determining the following, based on the standard 20m beep test:

Get Your Free Spreadsheet

Yes, it really is FREE! Enter your email address and you will be directed to a page where you can download the file.

* Submitting your email will also subscribe you (100% free) to the Topend Sports newsletter, containing top breaking news in sport, science, fitness and nutrition. Don't worry, you can easily unsubscribe at any time, but I don't think you will want to. As well as great information, you will get more freebies and other great offers!

Using the Spreadsheet

You can modify the athlete or squad sheet to suit your needs. Some of the columns refer to a (hidden) lookup table that needs to remain in the file for it to work correctly.

I would love your feedback on how you go using this spreadsheet, and welcome any suggestions on how it can be improved.


Can the spreadsheet be used for a 15m beep test?

To use the spreadsheet for a beep test over a distance other than 20m, you won't have to adjust the age, decimal values, total time, as that will be the same. You could make adjustments to correct total distance run. However, the ratings and VO2max calculation would not apply and is not something that can be adjusted easily. To correct the total distance run, you will first need to change the formula in that column, replacing 20 for whatever the distance run, then you would have to "unhide" the hidden lookup table on the spreadsheet and adjust the figures on the total distance column. It is not very simple but can be done.

Is the VO2max calculation different for males and females?

It's the same formula for males and females. VO2max is dependent on the beep test level achieved, no matter who achieves it. See the beep test formula. If you select female on the spreadsheet, the VO2max score is the same, but the rating may change.


Related Pages

Popular Content


Pass the Beep test BookThe Pass the Beep Test is a comprehensive guide to increase your score on the beep test in the quickest possible time. Buy it now on Amazon

Testing Extra

There are over 300 fitness tests, so it's not easy to choose the best one. You should consider the validity, reliability, costs and ease of use of each test. Use our guide to conducting, recording, and interpreting fitness tests. Any questions, please ask or search for your answer. To keep up with the latest in sport science and this website, subscribe to our newsletter. We are also on facebook and twitter.

How to Cite