Log+Key

Templates

Key register template for Excel and Google Sheets

A key register with inventory, checkouts and returns that works out status and overdue keys by itself — as an Excel file, for Google Sheets and on paper.

Free · no sign-up · Excel, Google Sheets and PDF

To be honest

When Excel reaches its limits

A spreadsheet works as long as one person keeps it. It gets tight in three places: when that very person is on holiday, at the first dispute about a missing key — a cell can be overwritten without anyone noticing — and as soon as two colleagues edit the file at once.

Our recommendation: don’t wait until it gets tight — start with Log+Key right away, free for up to 10 objects, for good. We bring your existing list across free of charge; archive it on the day you switch instead of keeping it going in parallel.

Download

Three ways to your key register

  • Excel template (.xlsx)

    Five sheets: guide, keys, checkouts, people and overview. Status, overdue keys and figures calculate themselves.

    Download the Excel template
  • Google Sheets

    Creates your own copy in your Google account.

    Make a copy in Google Sheets

    opens Google Sheets in your Google account

  • Print sheet (PDF)

    Key register sheet in landscape with 20 rows per page: fill it in on screen or print it blank; signatures go on paper.

    Download the print sheet

How to make your copy in Google Sheets

  1. Click “Make a copy in Google Sheets” and sign in to your Google account if you aren’t already. A free account is enough.

  2. Google asks whether you want to copy the document. Confirm with “Make a copy”. The copy is then saved in your Google Drive under “My Drive”.

  3. Rename the copy, for example after the building, and start entering. The copy is yours: Log+Key can’t see your entries. To work on it with colleagues, use “Share”.

Switching later? We’ll bring your list across

“Checkouts” sheet of the key register template in Excel: three example rows with the statuses “returned”, “overdue” in red and “open” in yellow, the status formula above
The “Checkouts” sheet: status is worked out from the planned and actual return date.

Reviewed by Dominik Knipprath Last updated:

In brief

A key register is the running list of an organisation’s keys: which exist, who has which one right now and when it is due back. Each checkout gets its own row so nothing is overwritten.

What goes in

What belongs in a key register

  • A unique key ID – so two similar keys can never be mixed up

  • Description, property and locking system – what the key is for, clear even to new colleagues

  • Number of copies – so a missing copy stands out

  • Where it is kept – where the key goes back after its return

  • Checkout with date, recipient and issuer – every movement on its own row, nothing gets overwritten

  • Planned and actual return – makes open and overdue keys visible

  • Signature on receipt and return (print sheet) – on paper the recipient confirms in person

Switching

We’ll bring your list across

Already keeping your key register in Excel? When you switch to Log+Key, there’s nothing to retype: our team does the first import from your existing list — free of charge, from this template or from your own spreadsheet.

  1. Create an account

    Free — up to ten objects at no cost, for good.

  2. Send your list

    The “Keys” sheet or your own spreadsheet (Excel or CSV) to hallo@log-key.de. We don’t need any names of people for it.

  3. We import it

    We’ll let you know as soon as your inventory is in Log+Key. For more than ten objects, choose a suitable plan.

Please send the key list only, without names of people. Who has which key is recorded directly in Log+Key afterwards.

Tips from practice

What works in practice

  1. One person keeps it, everyone can look

    The list works as long as it is clear who keeps it. Decide now who takes over during holidays — that is where a key register most often breaks.

  2. Every checkout is a new row

    Never overwrite an old row. A cell can be changed without anyone noticing what it said before; new rows keep the history.

  3. Keys belong to roles

    Describe what a key is needed for, e.g. “Caretaker, Sample Street”. Then the list stays right after staff changes.

  4. Check overdue keys at month end

    The “Overview” sheet counts overdue checkouts. A quick look at the end of each month is enough to get keys back before anyone misses them.

From our “What we learned” series — lessons from alarm services, care, property management, facility services and the public sector. Read the key management guide

Without paper

When the list is no longer enough

One sheet per handover works — until there are fifty a month and the folders fill up. In Log+Key, the record is created with every handover:

  • Signature right on the screen — tablet, smartphone or terminal
  • PDF receipt by email to whoever takes the key
  • A complete history: who had which key when
  • Return deadline with an automatic email reminder

Log+Key is free for up to 10 objects, for good.

More about handover and receipt

A handover in Log+Key: checkout with a signature on screen

Screencast: a bunch of keys is opened in the object list and taken out; the checkout is confirmed with the signature “M. Muster” on screen, followed by the PIN prompt

FAQ

Questions about the key register template

  • Does the template work in Google Sheets and LibreOffice?

    Yes. The formulas only use functions that Excel 2016 and later, LibreOffice and Google Sheets all know. For Google Sheets, use “Make a copy in Google Sheets” above to create your own copy in your Google account — or upload the Excel file to Google Drive and open it there.

  • Why are some columns locked?

    Status, open checkouts and description are calculated. So nobody overwrites the formulas by accident, these columns are protected — without a password. Use “Review → Unprotect sheet” to adapt the file.

  • How many keys does it hold?

    The formulas are set up for 500 keys and 500 checkouts. If you need more, copy the last row down — or ask yourself whether a spreadsheet is still the right tool.

  • Can I manage tools with it too?

    Tools and equipment have their own template with inventory number, category, serial number and inspection dates: the tool and equipment checkout. The key register stays with the keys.

  • Can I bring my existing list?

    Yes. When you switch to Log+Key, our team does the first import from your existing list free of charge — from this template or from your own spreadsheet. We don’t need any names for it: who has which key is recorded at the first checkout afterwards.

  • Where do I record which key opens which door?

    In a master key plan. The key register shows who has which key right now; the plan shows which doors a key opens. There is a separate master key plan template for Excel.

  • May I adapt the template?

    Yes. Change the standard wording right in the generator; you may use and share the fillable PDF within your organisation. The template is a sample without warranty and not legal advice; if every word matters, have the text checked.

Portrait of Dominik Knipprath

About this template

Reviewed by Dominik Knipprath

Co-founder and COO of Log+Key. Has spent years helping companies move from key logbooks and spreadsheets to digital key processes.

Sample based on German practice, without warranty. Not legal advice for your individual case.