Blood pressure log template
This free blood pressure log template is a CSV file that opens in Excel, Google Sheets and Apple Numbers. Download it, type in your readings, and add the optional formulas below for averages and color coding.
Reviewed against AHA guidance on
The columns are Date (YYYY-MM-DD), Time, Systolic, Diastolic, Pulse, Arm (L or R) and Notes. Two weeks of morning (AM) and evening (PM) rows are included. Copy and paste to add more. Prefer paper? Use the printable blood pressure log instead.
How do I open the template in Excel?
- Download the file, then double-click it. Excel opens it as a spreadsheet.
- Type your readings into the Systolic, Diastolic and Pulse columns.
- Choose File, Save As, and pick Excel Workbook (.xlsx) so your formulas and colors are kept.
How do I use it as a Google Sheets blood pressure log?
- Open Google Sheets and start a blank spreadsheet.
- Choose File, Import, then Upload, and select the downloaded file.
- Pick Replace spreadsheet (or Insert new sheet), then Import data.
How do I open it in Apple Numbers?
- Open Numbers and choose File, Open, then pick the CSV file. Or drag the file onto the Numbers icon.
- Numbers converts it to a table. Edit as usual, then save it.
Which formulas should I add to a blood pressure spreadsheet?
These work in Excel, Google Sheets and Numbers. They assume your readings are in rows 2 to 31.
- Average systolic:
=AVERAGE(C2:C31) - Average diastolic:
=AVERAGE(D2:D31) - Average pulse:
=AVERAGE(E2:E31) - Highest systolic:
=MAX(C2:C31) - Number of readings:
=COUNT(C2:C31)
AVERAGE skips blank cells, so empty rows will not pull your result down.
How do I color-code readings by AHA category?
Use conditional formatting (in Excel: Home, Conditional Formatting, New Rule, Use a formula; in Google Sheets: Format, Conditional formatting, Custom formula). Select C2:D31 and add one rule per category below. Rules are checked in order, so put the highest category first. These follow the American Heart Association categories.
- Severe hypertension: systolic higher than 180 and/or diastolic higher than 120. Formula:
=OR($C2>180,$D2>120) - Stage 2 hypertension: systolic 140 or higher or diastolic 90 or higher. Formula:
=OR($C2>=140,$D2>=90) - Stage 1 hypertension: systolic 130–139 or diastolic 80–89. Formula:
=OR($C2>=130,$D2>=80) - Elevated: systolic 120–129 and diastolic less than 80. Formula:
=AND($C2>=120,$D2<80) - Normal: systolic less than 120 and diastolic less than 80. Formula:
=AND($C2<120,$D2<80,$C2<>"")
When the two numbers fall in different categories, the higher category applies. Colors are only a visual aid, so also keep the numbers in view. A single reading is not a diagnosis. If you get a reading above 180 and/or 120, wait a minute and measure again. If it is still that high, contact your doctor right away, and call 911 if you have chest pain, shortness of breath, back pain, numbness or weakness, vision changes or trouble speaking.
Tips for a log your doctor can use
Measure at the same times each day, rest for 5 minutes first, and take 2 readings about 1 minute apart. See how to measure blood pressure at home for the full steps.
Spreadsheet or app?
A spreadsheet is free and flexible, but you maintain the formulas yourself and it is awkward to type on a phone. The CuffPal app is made for logging at the moment you measure: it works out averages, draws charts and makes a PDF for your doctor, and your data stays on your phone. It costs $4.99 once, with no subscription or ads.
Frequently asked questions
Is the blood pressure log template free?
Yes. It is a plain CSV file you can download, open and edit with no sign-up and no email address.
Does the template work in Excel, Google Sheets and Numbers?
Yes. A CSV opens in all three. In Google Sheets use File, Import, Upload. In Excel and Numbers you can just open the file.
How do I find my average blood pressure in a spreadsheet?
Use the AVERAGE function on each column, for example =AVERAGE(C2:C31) for systolic and =AVERAGE(D2:D31) for diastolic. Averages over several days are more useful to your doctor than a single reading.
Can I save my spreadsheet as a PDF to show my doctor?
Yes. In Excel choose File, Save As, PDF. In Google Sheets choose File, Download, PDF. In Numbers choose File, Export To, PDF.
Should I use a spreadsheet or a printable log?
Use a spreadsheet if you like typing and want formulas to do the math. Use a printable log if you want something quick to fill in by hand at the table. Both work as long as you keep it up.
Sources
Not medical advice. This page is general information based on American Heart Association guidance. It does not diagnose or treat any condition. Talk to your doctor about your own readings. If you have chest pain, shortness of breath or signs of a stroke, call 911. Read our medical disclaimer.