📊 Lab Tracker
Track your lab values over time – Perfect for spotting trends and sharing with AI tools
📋 Get Your Free Template
Ready-to-use Google Sheets template with dates down the left and lab values across the top!
Google Sheets version includes built-in chart templates. CSV works with Excel, Numbers, and AI tools.
🚀 Quick Start Guide
- Click “Open Google Sheets Template” above
- Make a copy: File → Make a copy (saves to your Google Drive)
- Add your data: Enter dates in Column A, lab values in corresponding rows
- Create charts: Select data → Insert → Chart (or use our pre-built chart templates)
- AI Analysis: Download as CSV and upload to Claude/ChatGPT for pattern analysis
📋 Template Layout Preview
| Date | TSH (mU/L) |
Free T4 (ng/dL) |
Free T3 (pg/mL) |
Reverse T3 (ng/dL) |
T3/rT3 Ratio |
Glucose (mg/dL) |
HbA1c (%) |
Insulin (uIU/mL) |
Cortisol (ug/dL) |
Testosterone (ng/dL) |
Estradiol (pg/mL) |
Progesterone (ng/mL) |
Vitamin D (ng/mL) |
B12 (pg/mL) |
Ferritin (ng/mL) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023-10-09 | 0.10 | 0.90 | 7.41 | 17 | 43.6 | — | — | 16.0 | 0.09 | 11.5 | 63 | 2.68 | 35.7 | 1862 | — |
| 2024-04-25 | 0.65 | 0.97 | 4.80 | 17 | 28.2 | — | 5.4 | 16.3 | 0.13 | 13.3 | 64 | 1.67 | — | — | — |
| 2024-11-04 | — | — | — | — | — | — | 5.4 | 16.8 | 0.19 | — | — | — | 34.1 | — | — |
| 2025-05-12 | 0.07 | 0.76 | 2.80 | 14 | 20.0 | 82 | 5.2 | 19.3 | 0.16 | 16.0 | 37 | 0.27 | 38.2 | 1873 | 203 |
| [Your Date] | [Value] | [Value] | [Value] | [Value] | =C5/D5 | [Value] | [Value] | [Value] | [Value] | [Value] | [Value] | [Value] | [Value] | [Value] | [Value] |
📈 Built-in Chart Templates
Your Google Sheets template comes with pre-configured chart templates for:
- Thyroid Function Timeline: TSH, Free T4, Free T3 over time
- Metabolic Markers: Glucose, HbA1c, Insulin trends
- Hormone Timeline: Cortisol, Testosterone, Estradiol progression
- T3/rT3 Ratio Trend: Track thyroid conversion efficiency
Charts automatically update as you add new data!
💡 Pro Tips for Maximum Insight
- Consistent formatting: Use YYYY-MM-DD date format for easy sorting
- Empty cells OK: Use “—” or leave blank if test wasn’t done
- Track ratios: T3/rT3 ratio auto-calculates to spot conversion issues
- Color coding: Use conditional formatting to highlight out-of-range values
- AI-ready format: This layout is perfect for uploading to Claude or ChatGPT
- Regular updates: Add new labs immediately – trends emerge over 6+ months
🤖 AI Analysis Made Easy
Once you have 6+ data points, you can:
- Download your sheet as CSV: File → Download → CSV
- Upload to AI: Claude, ChatGPT, or other AI tools
- Ask powerful questions:
- “Create a line chart showing my thyroid trends over time”
- “What patterns do you see in my cortisol levels?”
- “Analyze the correlation between my insulin and glucose values”
- “Generate a summary of my lab trends for my doctor”
🎯 Why This Format Works
This timeline format helped me discover critical patterns that individual lab reviews missed:
- Progressive cortisol decline from 0.19 to 0.09 µg/dL over time
- Thyroid conversion dysfunction – T3/rT3 ratio swings from 7 to 43
- Insulin resistance development despite GLP-1 therapy
- Treatment response tracking – see exactly when interventions help
Your timeline will reveal patterns that could change your treatment!