Vitality! – Your Essential Medical Tracker Template Keeps Your Medical Info Organized

If you prefer a visual demonstration, here’s a video tutorial.

After purchasing the Google Sheets Vitality Medical Tracker Template, you’ll be redirected to a view only Google Sheets template.

In order to start using your medical tracker, click File in the top menu bar and choose make a copy.

Name your Medical Tracker, and you’re ready to get started.

In the Medical History Tab, add your details, such as age, blood type, allergies, contacts, etc.

Next, add your insurance information in the Insurance Tab which is the last tab of the spreadsheet. If you don’t see, click the arrow to the right of the tabs.

In the Doctor Visits tab, add your next doctor appointment’s date, time, place, doctor, and reason.

In the Problems & Symptoms tab, add your problem, the cause, the severity of the symptom, how long the symptoms lasted, and what steps you took to alleviate the symptoms.

In the Medicine tab, write your medicines in the first row, and each time you take your medicine, click the checkbox.

To add more medicines or to add more checkboxes, see the next section.

In the Lab Results tab, add the date of your lab test, the result, the normal range, and your notes.

In the Cholesterol Levels tab, choose the Yes or No from the dropdown menu next to the “Do you have heart issues?”. Then, add the date of the test, use the dropdown menu to choose whether the test was done at home or in a lab. In the next columns, add the test results for your total cholesterol, LDL, HDL, VLDL, and triglycerides.

In the Mood tab, add the date and how you are feeling. If there is a cause, add it to the cause column.

The next tab is the Measurements tab. In this tab, you can track your weight, BMI, and body fat percentage. Add your age, height in the first row, then add your weight and body fat percentage each week. The BMI is automatically calculated.

The Blood Sugar Levels tab is where you track your blood sugar. Enter your blood sugar levels each time you test. There is also a HbA1C calculator.

Disclaimer: the HbA1C calculator is just an estimation and is not meant to replace an actual test done by a professional.

The last tab is the Insurance Info tab. Here, you can add information about your insurance companies, such as the provider, phone number, policy numbers, and address.

The medicine tracker tab has can track up to 10 medicines with 3 times by default. If you would like to add more medicines, follow these steps:

1. Select a column by clicking the column letter.
2. Right click on the column letter and choose insert 1 right.
3. Name the new column.

To Add More Medicines:

1. Select the three columns of Medicine 10 by holding CTRL (Command on Mac) and clicking on the column letters.
2. Right click on the column letters, and select Insert 3 right.
3. Select the top 3 cells and click the merge button in the top bar.
4. Add your medicine name and you’re done!

If you have any questions that weren’t answered here, feel free to contact me.