Blood Test Tracker lite

Immediately after purchase, you will receive a confirmation email with your download links. You can download the Microsoft Excel file directly to your computer or access the Google Sheets version via the provided link to save a copy to your own Google Drive.

This spreadsheet is generally compatible with Excel 2016 and later. If you are a Mac user, please note that I use a Mac myself and built this using Office 365. Older standalone versions (like Office 2019 for Mac) may not support the full functionality.

Note on Web/Mobile/Other Apps: Because this is a simpler 'Lite' version, some users have reported success using it in Apple Numbers, Excel Online, or LibreOffice. However, it has not been officially tested on these platforms and I cannot guarantee full functionality. I recommend using the desktop versions of Microsoft Excel or Google Sheets.

While you can view the data on mobile devices, I strongly recommend using a desktop or laptop for data entry and analysis. The conditional formatting and large data sets are designed for a full-screen experience and may not display or function correctly on mobile versions of Excel or Google Sheets.

Yes! The tracker is fully customizable. You can add custom biomarkers and new units of measurement to suit your specific needs.

I understand the desire for automation! However, because I sell these spreadsheets internationally and labs vary hugely in their PDF formats, naming conventions, and layouts, it isn’t currently feasible to offer one universal “import” tool that works reliably for everyone. You will need to manually enter your data yourself, which also provides a good opportunity to review your results closely.

I usually recommend using the reference range from your most recent lab report or the lab you use most consistently. You can also insert the name of the lab above each column for clarity. If you want to track different units (e.g., MCHC in g/dL and g/L), you can add additional rows as long as they are named differently.

This limit exists to keep the complex formulas and conditional formatting fast and responsive. For users with very deep historical records, I recommend duplicating the file (for example, keeping one file per decade) to ensure the spreadsheet doesn't lag.

Laboratory reference ranges are used by healthcare providers to interpret if a result falls within an expected range. These have been purposefully kept blank as there are no universally standardized reference ranges for most biomarkers; they vary by lab and region. I recommend using the specific ranges provided on your lab reports and speaking with your healthcare provider for guidance.

Each spreadsheet is designed for one person to maintain data integrity. To track a family, simply set up one "Master" file with your preferred units and ranges, then duplicate that file for each family member.

You are welcome to share PDFs or screenshots with clients. However, to share the actual spreadsheet or use it within a program/course, a Practitioner License is required.

Yes. Unlike health apps that store your data on their proprietary servers, this file lives in your personal Google Drive (subject to Google's standard privacy and security terms). I have zero access to your data, and no third-party scripts or apps are tracking your results.

Yes, you can log medication changes, supplements, or lifestyle notes in the dedicated 'Notes' row above each test-date column for a quick snapshot of what was happening at that time.

Yes, this is doable. The main Test Results tab is unlocked, so you can edit and adapt it to your lab’s format and workflow. While the tracker is primarily designed to store your raw lab values (with units and reference ranges), you could manually add a calculated marker in a separate row (e.g., “hsCRP, % of UL”) that converts each result into a % of the upper limit.