Published  |  Last updated

Quick Answer: These 10 free Google Sheets templates for medical students are Excel (.xlsx) files: download one below, upload it to Drive and choose Open with Google Sheets.1 They cover clinical rotations, a de-identified case log, skills, literature review, project timeline, trial data, research budget, exam preparation, USMLE practice scores and study groups. Every file was rebuilt in October 2026, recalculated with empty rows, had its main formulas checked with sample values, and carries a How to use sheet that says what it does and does not do.

Download the 10 Free Google Sheets Templates for Medical Students

Each card says what the template calculates and what it leaves to you. Cells you fill in have a white background and show what you type in blue, except the yellow Total Budget cell; grey cells hold formulas.

Clinical rotation and patient care

Clinical Rotation Schedule & Tracker

Up to 20 rotations. Start and end dates give duration, days remaining and time elapsed; a rotation past its end date that is not marked Completed turns red.

Not included: Hours completed are typed by you, not tracked.

Patient Case Tracking Log (de-identified)

One row per case with a case month, your own case code, free-text ICD-10-CM and CPT columns, a follow-up flag, and counts of cases this month and unique diagnoses.

Not included: Codes are not looked up or checked. Never enter the 18 HIPAA identifiers.

Clinical Skills Competency Checklist

15 examination skills and 12 procedural skills with four dated stages (practiced, observed, supervised, independent), a 1 to 5 performance level and a Competent count.

Not included: A personal tracker. Use your school’s forms for anything graded.

Research and academic work

Literature Review Management

Up to 100 articles with status drop-down, 1 to 5 relevance rating, a count of articles rated 4 or higher, and a repeated DOI or PMID highlighted in red.

Not included: An organiser, not a PRISMA screening tool.

Research Project Timeline & Gantt

A 24-week Gantt grid shaded from your start and end dates. Delayed tasks are red, completed tasks green, and a task that starts before its predecessor ends is flagged.

Not included: One predecessor per task; no critical-path calculation.

Clinical Trial Data Collection

One row per subject visit. Subject ID is stored as text, a duplicate ID turns red, and age, weight and blood pressure warn you about implausible values.

Not included: Does not randomize, grade adverse events or replace a validated data system.

Research Budget & Expense Tracker

Per-category budgets that roll up from up to 80 logged expenses. A category turns amber from 90% of its budget and red above 100%.

Not included: No currency conversion or funder rules such as indirect costs.

Study and exam preparation

Medical Exam Preparation Tracker

One row per study block with hours, questions completed and correct, and a calculated accuracy shaded red below 60%, amber 60 to 74% and green from 75%.

Not included: Weak areas are your own notes; the sheet does not find them.

USMLE Study Plan & Score Tracker

A subject table with accuracy and mastery level, plus a practice-assessment log showing latest score, change since the first test, average change per test and the gap to your target.

Not included: It does not predict your exam score.

Study Group Schedule & Task Manager

20 meetings and 20 tasks. Week number fills in from the date, meeting hours are totalled, and an unfinished task past its due date turns red.

Not included: Attendance is a head-count per meeting.

Open a Template in Google Sheets

The files are standard Excel workbooks, so Google Sheets can open them without any add-on.1

  1. 1Download. Tap Download .xlsx on the template you want. The file lands in your Downloads folder.
  2. 2Upload to Drive. In Google Drive choose New, then File upload, and select the .xlsx file.
  3. 3Open with Google Sheets. Open the file in Drive and choose Open with Google Sheets. To keep editing in Sheets format, choose File, then Save as Google Sheets.

We recalculated all ten files in LibreOffice Calc, not in Google Sheets. We did check the formulas against Google’s published function list: all 22 functions used in cells, conditional-format rules and drop-down rules (AND, AVERAGE, COUNT, COUNTA, COUNTIF, IF, IFERROR, INDEX, ISNUMBER, MATCH, MAX, MIN, MONTH, OR, ROW, ROWS, SLOPE, SUM, SUMIF, SUMPRODUCT, TODAY and YEAR) are on it.2 Drop-downs and colour rules were not run in Google Sheets. After your first import, look at the grey formula cells; if one shows an error, email co*****@*******se.com and we will fix the file.

What Was Tested

  • With every input row empty, no formula in any of the ten files shows an error such as #DIV/0! or #NAME?.
  • With sample values typed into the budget, exam, USMLE, case-log and rotation files, the budget roll-up by category, exam accuracy (including 0%), unique diagnoses, rotation days remaining and the USMLE average change per test matched hand calculation. Three practice scores of 200, 210 and 225 give an average change of 12.5 points per test.
  • Drop-down lists with an error alert are defined in the files, for example Group, Gender, Status and Data Verified in the trial file and Status in the study-group file. The duplicate-ID rule (trial file) and the overdue-task rule (study-group file) are red-fill conditional formats; in a LibreOffice test their formulas were true for the duplicate ID and the overdue unfinished task and false for the other rows. The red fill itself is shown in the trial screenshot below, not rendered in that test.

See Three Templates Filled With Sample Data

The downloadable files are blank. The screenshots below show the same workbooks after we typed invented example entries into them, so you can see what the formulas do once rows are filled in; categories and names are examples you can change.

Research budget tracker

Research budget and expense tracker filled with sample data: total budget, budgeted amounts, status column and grey formula cells

Swipe sideways or tap the image to open it full size.

Research Budget & Expense Tracker with sample data (invented example).
  1. 1Total Budget. Type the grant total once in the yellow cell. The expense log shows it again as a check.
  2. 2Budgeted Amount. Numbers you type show in blue. Rename the categories to match your grant.
  3. 3Status. Near limit from 90% of a category budget, Over budget above 100%. Here Equipment has spent 3,150 of 3,000, so the row turns red.
  4. 4Grey cells. Actual Spent, Remaining, Variance and % Used are formulas filled from the expense log below.

Research timeline and Gantt chart

Research project timeline template with Gantt bars drawn from start and end dates, a delayed task in red and a dependency flag

Swipe sideways or tap the image to open it full size.

Research Project Timeline with sample data (invented example).
  1. 1Task ID. Filled in automatically, one number per task. Use it in the Dependencies column.
  2. 2Dependencies. Task 3 starts on 26-Oct, before task 2 ends on 30-Oct, so its dependency cell turns orange.
  3. 3Gantt bars. One column per week. Bars are drawn from the start and end dates; completed tasks are green.
  4. 4Delayed. A task with the Delayed status is drawn in red. Progress % is typed by you.

Clinical trial data collection

Clinical trial data collection template with sample rows where a duplicate Subject ID 002 is highlighted in red

Swipe sideways or tap the image to open it full size.

Clinical Trial Data Collection with sample data (invented example).
  1. 1Duplicate ID. Subject ID 002 is entered twice, so both cells turn red until you correct one.
  2. 2IDs as text. 001 stays 001 because the column is formatted as text, not as a number.
  3. 3Entry cells. Blue values are typed by you. Age, weight and blood pressure show a warning for implausible values but still accept what you type.

Why Template Design Matters: A Spreadsheet Error Found in Published Research

Spreadsheet programs change what you type. In 2016 Ziemann, Eren and El-Osta screened supplementary Excel files from 18 genomics journals published 2005 to 2015 and found gene symbols such as SEPT2 and MARCH1 converted to dates.3 Among 3,597 papers with gene lists, 704 had at least one converted name, or 19.6% (95% CI 18.3 to 20.9, recomputed by Editverse in R from the paper’s tables). Nature had the highest share, 23 of 74 papers (31.1%), and Molecular Biology and Evolution the lowest, 4 of 79 (5.1%).

Dot plot with 95% intervals of the share of papers with Excel gene lists containing converted gene names, by journal, from Nature at 31.1% to Molecular Biology and Evolution at 5.1%; overall 19.6%
Share of papers with supplementary gene lists that contain at least one converted gene name. Hollow markers show journals with fewer than 50 such papers.

The problem grew over the decade. The number of affected papers rose from 4 in 2005 to 133 in 2015. These are counts, not rates: the paper does not publish how many papers were screened each year.3 A 2021 follow-up scanning 2014 to 2020 reported that these errors kept accumulating after the 2016 report.4

Bar chart of papers with confirmed Excel gene-name conversions by year, rising from 4 in 2005 to 133 in 2015
Papers with a confirmed conversion, by year. One paper has files dated in two years, so the yearly counts add to 705 for 704 unique papers.

The same habit of trusting a cell to hold what you typed affects trial IDs, dates and codes. These templates guard against it:

  • Risk: IDs such as 007 lose leading zeros, or codes such as 1-3 turn into dates.
    Safeguard: ID, DOI/PMID and code columns are formatted as text.
  • Risk: Day and month are swapped when a file moves between regional settings.
    Safeguard: Dates display as dd-mmm-yyyy, for example 03-Sep-2026.
  • Risk: Duplicate records go unnoticed.
    Safeguard: A repeated Subject ID or DOI/PMID turns red.
  • Risk: Impossible values are typed in.
    Safeguard: Drop-downs for statuses; warnings for implausible age, weight and blood pressure; correct answers cannot exceed questions completed.
  • Risk: Formulas are overwritten by accident.
    Safeguard: Formula cells are shaded grey and explained on a How to use sheet.

Keep Patient Data Out of Your Sheets

None of the ten templates contains patient identifiers, and none asks for them. The US HIPAA Privacy Rule describes two ways to de-identify health information, Expert Determination and Safe Harbor; Safe Harbor lists 18 types of identifiers to remove, including names, all elements of dates except year, geographic subdivisions smaller than a state and medical record numbers.5 Use an invented case code in the log, keep it unlinked to any record, and follow your institution’s and country’s rules for what may be stored and shared.

The USMLE tracker is for your own practice scores. Step 1 has been reported as pass/fail only for administrations on or after 26 January 2022, so use the tracker’s target cell for practice assessments rather than as a Step 1 score goal.6

Need the Analysis Run or Checked? Consult Editverse

Editverse subject-matter experts work to COPE, ICMJE and GPP 2022 guidance, with institutional and country-specific ethics followed. Choose the stage you are at.

Editverse logo

Editverse

Case Report Writing

Turned an interesting case from your log into a manuscript?

You send: your de-identified case notes, images and the journal you are targeting.

You get: a complete case report following CARE guidelines, with clinical timeline, diagnostic reasoning and learning points.

When: You have a case worth publishing and no time to write it up.

Case Report Writing · $650

Editverse logo

Editverse

Statistical Analysis

Trial or survey data collected? Have it analysed in SPSS, R or STATA.

You send: your data file, research questions and preferred software (SPSS, R, STATA or SAS).

You get: annotated code, complete output files, an interpretation guide and publication-ready results in 4 to 6 days.

When: You have the data and need the right test run and documented.

SPSS/R/STATA Statistical Analysis · $400

Editverse logo

Editverse

Manuscript Writing

Ready to turn your project into a submitted paper?

You send: your data, notes and target journal.

You get: a manuscript written and edited by PhD experts, with statistical review, journal selection and submission support.

When: Your project is finished and the paper is not.

Manuscript Writing Services · $1,500

Free Research Tools from Editverse

Frequently Asked Questions

Are these Google Sheets templates really free?

Yes. All ten are free for personal and educational use. Each button downloads an Excel (.xlsx) file directly, with no sign-up. Open it in Google Sheets, Excel or LibreOffice Calc.

How do I open the .xlsx files in Google Sheets?

Upload the file to Google Drive, open it, and choose Open with Google Sheets. To keep working in Sheets format, choose File, then Save as Google Sheets. You can also use File, Import, Upload from inside a blank Sheet.

Will the formulas, drop-downs and colour rules work in Google Sheets?

They use standard spreadsheet features. We recalculated all ten files in LibreOffice Calc with empty rows, and checked the main formulas in five of them with sample values. Google Sheets was not part of that test, but every worksheet function the files use appears on the list of Google Sheets functions. Check the grey formula cells after your first import and email co*****@*******se.com if one shows an error.

Can I enter patient information in the Patient Case Tracking Log?

No. Use an invented case code and keep the 18 identifier types in the HIPAA Safe Harbor list out of the sheet, including names, all elements of dates except year, geographic subdivisions smaller than a state and medical record numbers. The template does not make a log HIPAA compliant; what you enter and your institution’s policy decide that.

Can I share a template with my study group?

Yes. Store it in Google Drive and share it with named people. Share only de-identified material, and do not put patient data in a shared sheet.

Will the USMLE tracker predict my exam score?

No. It shows your latest practice score, the change since your first test, the average change per test and the gap to your target. Practice assessments are not the real exam, and Step 1 has been reported as pass/fail since 26 January 2022.

Why are ID and DOI columns formatted as text?

Spreadsheet programs can silently change what you type. A 2016 screen of 35,175 supplementary Excel files found that 19.6% of papers with gene lists contained gene names converted to dates or numbers. Text formatting keeps values such as 007 or 1-3 exactly as typed.

Can I change the pre-loaded lists and categories?

Yes. Type over the white cells, such as skill names, budget categories and phase names. Leave the grey cells alone, because they hold the formulas. If you add rows beyond the printed range, copy the formulas down with them.

References

  1. Google Docs Editors Help. Use both Excel & Sheets: Best practices. support.google.com/docs/answer/9331167?hl=en
  2. Google Docs Editors Help. List of Google Sheets functions. support.google.com/docs/table/25273?hl=en
  3. Ziemann M, Eren Y, El-Osta A. Gene name errors are widespread in the scientific literature. Genome Biol. 2016;17:177. Open access, CC BY 4.0; Additional file 1 and Table 1 recounted by Editverse in R. doi.org/10.1186/s13059-016-1044-7
  4. Abeysooriya M, Soria M, Kasu MS, Ziemann M. Gene name errors: lessons not learned. PLoS Comput Biol. 2021;17(7):e1008984. doi.org/10.1371/journal.pcbi.1008984
  5. U.S. Department of Health and Human Services. Guidance Regarding Methods for De-identification of Protected Health Information in Accordance with the Health Insurance Portability and Accountability Act (HIPAA) Privacy Rule. www.hhs.gov/hipaa/for-professionals/special-topics/de-identification/index.html
  6. USMLE. Step 1 pass/fail score reporting: implementation date (administrations on or after 26 January 2022). www.usmle.org/step-1-passfail-score-reporting-implementation-date

Editverse Research Team | Updated October 2026