Peak Flow Test Diary – Excel Template

Time to read: 4 mins

After a recent visit to the doctors, I was asked to take a peak flow test and record my results. I was provided a link to the “Asthma” website to fill in a “Peak Flow Diary” but meant I had to print it out and find a pen, so I decided to make one within excel, I mean, why not?

So if you have to do a Peak Flow Test Diary then please see below my excel template download below:

What is a peak flow test diary?

In short, it measures how quickly you can blow our air from your lungs, the lower the reading the less air you have been able to blow out. The chart is able to detect and see how your asthma is or isn’t doing.

A “normal” reading on a peak flow is between 400 and 700 liters per minute.


Order a Peak Flow

Do you need a peak flow meter? Order one on Amazon today!

13 Replies to “Peak Flow Test Diary – Excel Template”

  1. Great sheet and will be very useful, but how do I edit it as the dates cannot be changed, the sheet is protected and requires a password.

  2. Hi lee,
    Is there an easy way to edit the chart to monitor more than 14 days please?
    The chart is great by the way and my son now enjoys doing his peak flow test as he can use the chart at the end.
    Thanks Robin

  3. Hi

    What’s the chanced of getting a version of the spreadsheet that’s not password protected?


  4. Hi Lee

    Please could you let me know how i can get column D (time) t work as it keeps returning to 00.00 when ever i add the time

    1. Kim, make sure that you are adding the time as HH:MM which should resolve the issue.

  5. HiLee,
    I think your test diary is just what I need as I’ve been asked to keep arecord for the next month or so could you kinldy send me an unlocked version?

    Many thanks,


  6. Is it possible to adapt the spreadsheet to indicate what the dirurnal variation is?

  7. Hi

    I can’t see how you are calculating diurnal variation in peak flow as Icant see the calculation that you have used. To calculate diurnal Peak Flow variation the following calculation can be used:

    AvgDailyVariability = 100 * (HighestPEF – LowestPEF) / HighestPEF

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.