A blood test tracker template for Excel and Google Sheets
A blank marker-by-date sheet with 51 common markers, a unit beside each and a column for each draw date. Download it and type in your results, or let BioPanel fill the same layout from your lab PDFs.
Free: 1 file per day, up to 10 pages, no account.
Download the template
One CSV, 51 markers, 8 columns. Opens in Excel, Numbers and Google Sheets. No account and no email address.
| marker | unit | YYYY-MM-DD | YYYY-MM-DD | YYYY-MM-DD | YYYY-MM-DD | flagged_dates | unit_note |
|---|---|---|---|---|---|---|---|
| Glucose | mg/dL | ||||||
| HbA1c | % | ||||||
| Total cholesterol | mg/dL | ||||||
| LDL-C | mg/dL | ||||||
| HDL-C | mg/dL | ||||||
| Triglycerides | mg/dL | ||||||
| ApoB | mg/dL | ||||||
| Lp(a) | nmol/L | ||||||
| hs-CRP | mg/L | ||||||
| Ferritin | ng/mL | ||||||
| Iron | µg/dL | ||||||
| TIBC | µg/dL |
The date headings are placeholders: write the collection date of each report, for example 2026-03-19. flagged_dates and unit_note are filled by BioPanel's merged export and can stay empty when you type values yourself.
What the template is
The template is one CSV file. Each row is a marker. The first column names it, the second holds the unit that is usual for it, and the date columns are empty, waiting for the collection date of each report. Fill a date column from one report, then add the next report in the next column, and the history reads left to right.
It is the same layout BioPanel produces as its merged wide CSV, so a sheet you started by hand and a sheet BioPanel filled for you look alike. BioPanel does not import the template back in; the two are for use side by side in your spreadsheet.
There are no ranges in the template on purpose. Ranges differ by lab, and often by age and sex, so the range that matters is the one printed on your report. The template organises numbers. It does not say whether any of them is high, low or fine, and it is not medical advice.
What each column is for
Two formats: the wide sheet you fill by hand, and the long format BioPanel can export.
- marker: the marker's name. Keep it the same each time so a row stays one history.
- unit: the unit that is usual for the marker. Change it for a row if your lab prints another one.
- YYYY-MM-DD columns: one per report. Replace the heading with the collection date and type each value under it.
- flagged_dates: dates on which a value fell outside the range printed on that report. Filled by BioPanel; optional by hand.
- unit_note: a note when a value was converted or a unit differs. Filled by BioPanel; optional by hand.
BioPanel's long export has one row per marker and date, with these columns: date, marker, value, unit, value_as_printed, unit_as_printed, converted, factor, range_low, range_high, range_text, lab_flag, computed_flag, lab, patient. It suits pivot tables and databases.
Using the template
A few minutes for the first report, less for each one after.
Download the CSV
Use the button on this page. The file opens in Excel, Numbers and Google Sheets. In Google Sheets, choose File, then Import, then Upload.
Replace the date placeholders
Each YYYY-MM-DD heading becomes the collection date of one report, written the same way, for example 2026-03-19. Copy a date column to the right for more reports.
Type each value from the report
Use the number as printed. Type results such as <0.5 or Not detected as they appear. If your lab prints a different unit from the one in the unit column, change the unit for that row.
Add what is missing
Add a row for any marker the template does not list, and delete the rows you do not track. Keep the marker name the same each time so the row stays one history.
Or skip the typing
Upload the PDFs to BioPanel and download the merged wide CSV. It has the same layout, with the values, the converted units and the dates that fell outside their printed range already filled in.
A hand-kept sheet, a generic PDF-to-Excel converter, or BioPanel
Three ways to end up with a marker-by-date sheet.
| What is compared | Spreadsheet by hand | Generic PDF-to-Excel | BioPanel |
|---|---|---|---|
| Starting the sheet | Download this template or build your own. | None. You get one table per file. | Upload a report and the sheet is built for you. |
| Entering a report | Type each value, about 30 to 60 per report. | Upload, then rearrange each file into your sheet. | Upload. Values land in the right row and date column. |
| Keeping marker names consistent | Up to you, row by row. | Names stay as each lab printed them. | More than 70 common markers share one name across labs. |
| Units that change between labs | You convert, or keep a note. | Not handled. | Converted where exact, factor shown. Other mixes marked. |
| The range printed on each report | Needs extra columns you add yourself. | Copied as loose text. | Kept per value, and used for the flag. |
| Spotting values outside the printed range | You compare each one by eye. | No. | Listed in flagged_dates, compared with that report's own range. |
| Cost | Free, plus your time. | Varies by tool. | Free for 1 file per day. Paid plans from $9 per month. |
| Interpretation | Yours, or your clinician's. | None. | None. Organisation only. |
Questions people ask
Is the blood test tracker template free?
Yes. It is a direct download of a CSV file, with no account and no email address asked for. You can copy it, change it and keep it.
Which markers are in the template?
51 common ones: blood glucose and HbA1c, cholesterol fractions, triglycerides and ApoB, iron studies, vitamins, thyroid, kidney and liver tests, electrolytes, a full blood count, inflammation markers and some hormones. Add or delete rows to match what your reports contain.
Does it come with normal ranges?
No, by design. A range depends on the lab, and often on age and sex. The range printed on your own report is the one to use, so the template leaves it out. If you want it beside each value, add a column next to each date, or keep a second sheet with the same markers and the range from each report.
Why a CSV and not an .xlsx file?
A CSV opens everywhere, holds no macros or hidden sheets, and shows exactly what is in it. Open it in Excel and save it as .xlsx if you want formatting, filters or a chart.
What do flagged_dates and unit_note mean?
They are the last two columns of BioPanel's merged export. flagged_dates lists the dates on which a value fell outside the range printed on that report. unit_note records any conversion or mixed unit in the row. When you fill the template by hand, leave them blank or use them for your own notes.
How should I write a result like <0.5 or Not detected?
Type it as the report prints it. A spreadsheet will treat it as text, which is fine for a record but cannot be charted. If you plan to chart a marker, a numeric column is easier; keep the original wording in a note.
What if my lab changes units between reports?
Write the unit that was printed on each report. For glucose, cholesterol fractions, triglycerides, creatinine and vitamin D there are exact factors on the lab units conversion page. BioPanel applies them for you and shows the factor next to each converted value.
Can I use one sheet for several people?
Keep one copy per person. A shared sheet makes it easy to put a value on the wrong row. BioPanel keeps people apart for you by grouping reports by the initials and birth year printed on them.
Can I load my filled-in template into BioPanel?
No. BioPanel reads lab reports, not spreadsheets. Its merged wide CSV uses the same layout as the template, so you can open the two side by side and copy rows between them.
Does the template tell me what my results mean?
No. It is a place to keep numbers in order. For what a result means for you, talk to a clinician. This is not medical advice.