Logging CPD in Excel? There's a better way

Search "CPD Excel" and you will find hundreds of template downloads. There is a good reason for that: a spreadsheet is the first tool most people reach for when a regulator, employer or professional body asks them to keep a continuing professional development record. It is free, it is already open on your laptop, and you can see every row.

And yet almost everyone who starts a CPD log in Excel quietly stops updating it, or reaches appraisal season and spends an evening re-adding their hours by hand. The spreadsheet is not the problem. The problem is that CPD records have jobs a blank grid cannot do. This guide walks through where spreadsheet CPD logs go wrong, how to build one that lasts if you want to stay in Excel, and the honest case for the free online CPD log as the sensible way to keep your record in 1970.

What Excel does well (be fair to it)

Before listing the failures, credit where it is due. Excel is genuinely good at three things a CPD log needs:

• A row per activity. Date, activity, hours, notes. That is the skeleton of every professional CPD record, from NMC revalidation to an ICAEW member's annual return.
• Totals that add themselves up. One SUM formula and you know where you stand against your target.
• Ownership. The file is yours. Nobody can take it away, and your record does not sit inside an employer's system you might lose access to tomorrow.

If that is all you need, and you update the file the week the learning happens rather than the week before your appraisal, a spreadsheet can carry you for years. Most people do not manage it - not because they lack discipline, but because Excel has no idea what a CPD record is.

Where the spreadsheet starts to cost you

The hours are only as accurate as your last manual check. A SUM formula counts whatever is in the column, including the entry you fat-fingered as "6" instead of "0.6" in March. Multiply that across a year and you can arrive at an appraisal with a total that is confidently wrong. Regulators do not ask for perfect records, but they do expect accurate ones, and a wrong total is harder to defend than a short one.

Formulas are fragile in exactly the way records need to be robust. Sort the range wrong and a formula drops a row. Insert a column and the SUM quietly shrinks. Nobody notices until the number looks too low, and by then you are reconstructing the year from memory.

There is nowhere for the evidence. A cell can say "safeguarding refresher, 2 hours". It cannot hold the certificate, the webinar recording or the paragraph you wrote about what you changed afterwards. So the evidence lives in your email, your downloads folder and wherever last year's laptop went. When an audit or appraisal asks for proof, the spreadsheet gives you the summary and nothing to back it up - which is exactly the gap our guide to what happens if you are audited for CPD explores.

Reflections do not fit in cells. Most professional bodies now want you to show impact, not just attendance: what you learned, what it changed, what you will do differently. That is a paragraph, not a field. Cramming it into a narrow cell produces records that are technically complete and professionally useless. If you are not sure what a good reflection looks like, start with how to write a CPD reflection.

Nothing reminds you. A spreadsheet does not notice that your first aid certificate expires in November or that you have logged nothing since June. Deadlines and gaps surface when you go looking for them, which for most people means the night before the deadline.

The file is one careless afternoon away from gone. Laptops die, files get overwritten, "CPD_v7_FINAL (2).xlsx" is not a backup strategy. And if you leave your job, the copy on the company drive is not yours - see who owns your CPD record when you leave a job.

Building a better spreadsheet (if you want to stay in Excel)

If Excel is where you want to be, build it properly. This structure survives appraisal season:

1. One sheet, one year. A new tab per year keeps the file light and the totals honest. Keep a summary tab with a formula that pulls each year's total across.
2. Columns that matter: date, activity title, activity type (course, reading, mentoring, reflection, event), hours, evidence reference, and a one-line "what changed in my practice".
3. Data validation on the type column. A dropdown stops "Seminar", "semimar" and "SEMINAR" becoming three categories when you come to review your balance of learning.
4. A totals row that counts completed rows only, and check it against a manual count once a quarter. It takes two minutes and catches the fat-fingered hours.
5. An evidence folder with matching file names. Name certificates "2026-03-14-safeguarding-certificate" and record that name in the evidence column. The link between record and proof is what makes an audit painless.

Or skip the formatting and grab our free CPD log template, which already has the columns, an example row and totals that work.

The honest upgrade: keep Excel, move the record

Here is the part most articles will not tell you: the spreadsheet and the online log are not enemies. Excel is a fine place to have been logging; it is a poor place to keep logging.

Your spreadsheet exports to CSV in about four clicks - File, then Save As, then CSV - and the free CPD log on WorkplaceHero imports it. Your hours, dates and activities arrive intact; you add reflections as you go or all in one sitting. Nothing is lost, and you stop maintaining two systems.

Why the free CPD log is the sensible choice in 1970

We will keep this short, because the reasoning is not complicated:

• The accuracy is structural, not aspirational. Hours are entered once and totalled by the system. There is no formula to break, no row to drop when you sort, no version marked FINAL that is not.
• Logging takes seconds, not a session. Date, activity, hours, one line on what changed. Entries that take ninety seconds get logged the week the learning happens, which is the single biggest predictor of whether a record survives the year.
• The evidence travels with the entry. Certificates and reflections attach to the record itself, so your audit trail is one page, not a folder hunt.
• It is yours. Free for life for individuals, unlimited entries, reflections on every entry, PDF and CSV exports, and the record moves with you between jobs. No employer lock-in, which is the whole point of a CPD passport.
• When you outgrow free, the paid layer is about depth, not access. Credential storage, expiry reminders and coaching sit in PassportPro. The log itself does not expire.

If your employer also uses WorkplaceHero, you can link both worlds without losing the personal record - but the log starts with you, not your org chart.

For a broader look at the spreadsheet-versus-software question, including why organisations hit the same wall with training records, see why spreadsheet-based training records fail and our CPD log software comparison.

The bottom line

Excel got you logging, which is more than most people manage. But a CPD record has to stay accurate, carry evidence, survive a job change and remind you before deadlines - and those are the four things a spreadsheet is worst at. Export what you have built, import it into the free online CPD log, and spend the appraisal season proving your development instead of rebuilding it.

If you take one step this week: open your spreadsheet, check the hours column against a manual count, and save a CSV copy. It is the cheapest insurance you will ever buy, and it makes the switch painless whenever you are ready.