Blood Test Tracker plus

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: I do not recommend using Excel Online (Web Browser) or the mobile app. These versions do not support Macros, which are required in this file to reliably duplicate the charting tools, nor do they support some of the more complex formulas and charts used in this tracker. The same limitations apply to LibreOffice and Apple Numbers.

Yes, the Excel version uses a simple macro for one specific purpose: to allow you to create clean, working copies of the 'Charts' tab with a single click. This ensures all complex charting formulas remain intact when you want to visualize different datasets.

The macro does not access the internet or modify other files. However, if you are uncomfortable enabling macros or your computer's security settings prevent them, please reach out to me. I can provide a macro-free version with 10 pre-generated chart tabs ready for you to unhide. Please note that because these tabs are pre-built, the macro-free file is slightly larger in size than the standard version.

While you can view the data on mobile devices, I strongly recommend using a desktop or laptop for data entry and analysis. The complex charts and conditional formatting 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. Just bear in mind that the charts will reflect the data exactly as entered—if you keep them in separate rows, you can select and chart each lab's data separately.

This limit exists to keep the complex formulas and conditional formatting fast and responsive. Additionally, charting more than 100 points at once makes the axis labels difficult to read. 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.

Standard reference ranges are established by individual laboratories based on a broad population and can often be quite wide. Conversely, optimal reference ranges are based on data from healthy populations. They are designed to identify an individual's optimal health status and look for signs of dysfunction at the cellular level, often years before it develops into a disease state.

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 of the charts 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.

Currently, the charts are designed to show individual biomarker trends over time. Multi-variable charting (comparing the relationship between two different biomarkers on one graph) has been requested and I am exploring it for future updates.

Yes, you can log medication changes or notes above each test-date column for a quick snapshot. Even better, within the Quick Stats tab, there’s a dedicated section to track medications, supplements, and lifestyle changes with start/stop dates, so you can review them chronologically alongside your test results.

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.