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!

16 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

      1. Hi
        You kindly updated your Peak Flow Spreadsheet to incorporate variability. However, I think in your modified spreadsheet you are just calculating the variation between the three PEF blows for the morning (am) and the variation of the three PEF blows for the afternoon (pm).

        What I wanted is average daily variability, not variation between three blows. To calculate Average Daily variability, which is a percentage (%), the following equation is used:

        AvgDailyVariability = 100 * (HighestPEF – LowestPEF) / HighestPEF

        As in patients with asthma a they may have a higher PEF in the morning and a lower PED in the afternoon, so that is why we want to calculate the daily variability between the highest PEF in the morning and the highest PEF in the afternoon.

        Can you modify the spreadsheet to do this?


        1. Hi James,
          Can we use =VAR.P(E2:G2) here? (As the example top row)?
          If you had 3 results, say 320, 325, 330 – What is the expected % Variation?

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.