A CPR training record template gives you one place to see who is certified, in which course, and when each card expires. By the end of this guide you will have a reusable spreadsheet (or printable sheet) with expiration formulas, color-coded status flags, and a review routine that catches lapses before they happen. Before you start, gather a list of the people you are tracking, copies of their current certification cards, and a spreadsheet tool or document editor. Best Emergency Services Training can help you fill any gaps once you see who needs renewal.
Step 1: Decide What Your Records Must Prove
Start with the reason you are tracking. The purpose determines which courses you list, how much detail you capture, and who may ask to see the file. Common drivers include:
- Employer policy
- A licensing board requirement
- Hospital credentialing
- School or childcare requirements
- A workplace safety program
Rules vary by state and by profession, so confirm requirements with your own regulator, employer, or accreditor before you finalize the design. Ask specifically which course types they accept, whether a hands-on skills session is required, and whether online-only courses count. Not every employer or licensing body accepts a fully online course, and a signed class roster is not the same thing as a certification record.
Next, match the scope of the record to the course types in your organization:
- CPR/AED: typically for lay responders such as office staff, teachers, coaches, and childcare workers.
- BLS: the standard for healthcare providers.
- ACLS and PALS: for advanced roles such as critical care, emergency, and pediatric nursing or physician staff.
Do not assume all cards last the same length of time. Different courses and providers set different validity periods, so your template needs to handle that.
Finally, name an owner. This might be HR, a nurse manager, or a safety officer. Pick one person responsible for updates and one backup. Records fail most often because everyone assumed someone else was keeping them current.
Step 2: Choose the Fields Every Record Should Include
Every row should answer who, what, when, and from whom. These core fields cover most audit questions:
- Full name
- Employee or ID number
- Role or department
- Course name (for example, BLS Provider)
- AHA course type, such as CPR/AED, BLS, ACLS, or PALS
- Issue date
- Expiration date
- Instructor or training provider
- Card or eCard number
The issue date is when the course was completed and the card was issued. The expiration date is when the certification stops being valid. As of 2026, American Heart Association BLS, ACLS, and PALS provider cards are generally valid for two years, but verify the current period on the AHA website, and check the actual card for each person. Cards often show a "recommended renewal" month, and many employers treat the end of that month as the deadline.
Optional fields can make the record more useful:
- Skills session completion, if the course was blended learning with a separate hands-on component
- Class format (instructor-led or blended)
- Accommodations noted, kept brief and relevant
- Renewal reminder date
- Notes
One mistake to avoid: a single "certified yes/no" column. It tells you nothing until the day someone lapses. A real date in every row is what lets you see an expiration coming months ahead.
Step 3: Build the Template in a Spreadsheet
Open a new sheet in Excel or Google Sheets and put each field from Step 2 in its own column, with headers in row 1. Use one row per person per certification. Someone who holds BLS and ACLS gets two rows, which keeps sorting and filtering simple. Freeze the header row so it stays visible as the list grows.
Format the issue and expiration columns as dates. Then let the sheet calculate expiration for you. If the issue date is in column F and the expiration date is in column G, enter this in G2 and fill it down:
=IF(F2="","",EDATE(F2,24))
The 24 means 24 months. Change it if a course has a different validity period, or overwrite the formula with the date printed on the card when it differs. The IF wrapper keeps the cell empty when no issue date has been entered.
Add drop-down lists (Data Validation in both programs) for course type and status. Consistent entries such as "BLS Provider" rather than "bls," "Basic Life Support," and "BLS-HCP" make filtering reliable. Status options might be Active, Expiring, Expired, and Pending Renewal.
A sample layout looks like this, shown as plain rows with columns separated by a vertical bar:
- Columns: Name | ID | Role | Course | Issue Date | Expiration | Provider | eCard No.
- Row 1 (illustration): Jordan Lee | 1042 | RN, ER | BLS Provider | 03/04/2026 | 03/31/2028 | Best Emergency Services Training | (from card)
- Row 2 (illustration): Jordan Lee | 1042 | RN, ER | ACLS Provider | 05/12/2026 | 05/31/2028 | Best Emergency Services Training | (from card)
Small teams can use a printed version of the same columns, and it also works well as a sign-in sheet at onsite training. Just transfer the data into the master file afterward.
Step 4: Add Expiration Alerts and Status Flags
Add a Days Remaining column next to Expiration. With the expiration date in column G, use:
=IF(G2="","",G2-TODAY())
Format the result as a number, not a date. Positive numbers are days left; negative numbers mean the card has lapsed.
Now apply conditional formatting to the Days Remaining column (or the whole row) with three states:
- Current: more than 90 days remaining, green.
- Expiring soon: 0 to 90 days remaining, yellow or orange.
- Expired: below 0, red.
You can also add a Status column with a formula such as =IF(H2="","",IF(H2<0,"Expired",IF(H2<=90,"Expiring","Current"))) so the flags can be filtered, not just seen.
Choose a window of 60 to 90 days. Group classes fill up, ACLS and PALS sessions are scheduled less often than BLS, and staff need time to fit a class around shifts. A 30-day warning is often too late for a unit that needs six people renewed in the same month.
If the formulas misbehave, check these first:
- Blank dates causing errors or odd numbers: wrap formulas in an IF test for empty cells, as shown above. Otherwise a blank date is read as day zero and shows a huge number.
- Dates that will not calculate: a date typed or pasted as text is usually left-aligned. Reformat the column as Date and re-enter the value, or use Find and Replace to force a refresh.
Step 5: Collect and Enter Existing Certification Data
Gather a copy of each person's current card, or the eCard itself. AHA eCards can be checked through the AHA eCard verification system, which generally requires the eCard code or the holder's details. Confirm the current process on the AHA site before you tell staff how to do it.
Enter data from the card, not from memory. People often misremember a course name or the month they renewed, and a misspelled name can make a card hard to match later. Read each name, date, and card number twice, ideally with a second person spot-checking a sample.
Expect a few awkward cases:
- Lapsed cards: enter them as they are. The red flag is accurate, and it creates your renewal list.
- Missing cards: leave the row incomplete with a note, and ask the person to find the eCard email or contact the training provider that issued it.
- Multiple certifications: add a separate row for each course.
- Differing course types: a CPR/AED card does not satisfy a BLS requirement. Record exactly what the card says, then compare it against the job requirement from Step 1.
When the data is in, sort by Days Remaining, lowest first. Anyone expired or inside the 90-day window goes to the top of the renewal list.
Step 6: Store Records Securely and Control Access
Save the file in a shared drive with restricted editing. The record owner and a backup should have edit rights, and most other people should have view-only access, or none at all if the file is not relevant to them.
Treat the contents as personnel information. Collect only what you need for compliance. You do not need home addresses, dates of birth, or full government ID numbers to track a CPR card, so leave them out. An employee ID is enough to tell two people with the same name apart.
Add a column for a link to the scanned card or eCard, or save the PDF in a folder named after the person's ID and link to it. Then an auditor can see the proof next to the data without a search. Back up the file on a schedule, or confirm that your drive's version history is switched on.
Keep a simple change log on a second tab with these columns:
- Date of change
- Who made it
- Which row
- What changed and why
It takes seconds per update and answers the first question an auditor tends to ask.
Retention periods differ by employer, state, and regulator, and some require records to be kept for a set time after employment ends. Ask your HR department, compliance office, or licensing body how long to keep them, rather than assuming.
Step 7: Set a Review Routine and Plan Renewals
A template only works if someone looks at it. Put two recurring events on the owner's calendar:
- Monthly: sort by Days Remaining and review everything flagged yellow or red.
- Quarterly: compare a sample of rows (or all of them, for small teams) against the actual cards or eCards to catch typos and outdated entries.
Use the flagged list to book renewals. Best Emergency Services Training offers AHA BLS, ACLS, PALS, and CPR courses, with onsite group training for teams, offsite locations, and one-on-one home instruction for people who need a more personal or flexible setup. Booking a group for everyone expiring in the same quarter is usually easier than chasing individual schedules.
After each class, add the new card details as a new row instead of overwriting the old one. Mark the older row as Superseded or Renewed. This preserves a history of past certifications, which matters for credentialing files and for showing there was no gap in coverage.
One common mistake is tracking only the expiration date. Before enrolling someone, confirm that the renewal course matches what the job requires. A nurse who needs BLS Provider should not be signed up for a general CPR class, and an employer may have its own rules about online or blended formats.
Test the Template, Then Put It to Work
Before you roll it out, enter three or four test rows with dates in the past, near future, and far future. Confirm that the expiration formula, the Days Remaining numbers, and the color flags all behave as expected. Then load your full roster, share the file with the right permissions, and put the first monthly review on the calendar.
Don't let certification deadlines stress you out, get your AHA, ECSI or HSI-certified CPR training completed quickly with flexible scheduling that works around your life. Schedule your personalized training session today and join the thousands of individuals and businesses who trust B.E.S.T. for fast, convenient certification with expert instructors.
