Help for owners
My staff passwords live in a spreadsheet and I want them out
Short answer
A spreadsheet of passwords is easy to copy, forward and leave open to anyone with the link. Move the entries into a company password manager in groups, change each password as it moves, protect the manager with two-step verification, and then find and delete every old copy of the file, including email attachments and downloads.
Does this sound like your situation?
- There is a file called passwords or logins that several people can open.
- I do not know how many copies of that file exist or who has them.
- The sheet is shared by link, or it was emailed to a new starter.
- Staff text each other for the login that is not in the sheet.
- When someone leaves, nobody can say which entries they could see.
Why does this happen?
A spreadsheet is the easiest place to start
Everyone already has one, it needs no setup and it is searchable. It was meant to be temporary and then the business grew around it.
The file is not locked to a person
Anyone who opens the sheet sees every entry. A shared link, a forwarded attachment or a download to a personal laptop each creates a copy you cannot recall.
Passwords stay old and repeated
Entries are rarely changed because editing the sheet is manual. The same weak password then protects several accounts, and the NCSC says each important account needs its own password.
Confirmed by ncsc.gov.uk
A password manager answers the memory problem
The NCSC lists the benefits: a unique password for each account without having to remember them, automatic generation of strong passwords, autofill that only fills on the correct website, and warnings if a password has leaked.
Confirmed by ncsc.gov.uk
The manager itself needs protection
The NCSC advises turning on two-step verification for the password manager account, so that someone who learns the main password still cannot get in, and warns that forgetting the main password can make recovery hard.
Confirmed by ncsc.gov.uk
What can I do about it today?
- Do not delete the spreadsheet yetIt is still how people get in. Deleting it first would lock staff out of the very accounts you need to secure.
- Find out who can open itCheck the sharing settings and the version history. Write down people, links and any copies you can find.
- Rank the entries by damageEmail, bank and payment accounts, the domain, hosting and anything with an admin role come first. Do those before social media logins.
- Choose one company password managerThe NCSC suggests choosing on whether it works on all your devices, whether you can control generated passwords, the cost and extras such as secure sharing. Pick one the team will actually use.
- Move in groups and change as you movePut an account in the manager, set a new strong password on the real service, then delete that row from the sheet. Do email and payments first.
- Finally, delete every copyWhen the sheet is empty, remove the file, its older versions, email attachments and downloads. Check that links no longer open it.
When should I bring someone in?
- The file contains server, database or payment passwords and nobody is sure which are live.
- A person who had the sheet has left.
- You suspect someone has already used a login they should not have.
How do I handle it?
- Inventory the sheet and its copiesEntries are grouped by what a break-in would cost, and the places the file has been shared or saved are listed.
- Plan the order of the moveAdmin and money accounts first, then shared tools, then the rest, with a named owner for every account.
- Change each password at the sourceThe password in the manager and the password on the service are changed together, so the old value in the sheet is already useless.
- Remove the old file for realVersion history, attachments, backups of laptops and shared-drive links are checked before the file is called gone.
- Leave a one-page habitWhere new passwords go, who approves access and what happens when someone leaves, written plainly.
The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.
What do owners ask about this?
Is a password-protected spreadsheet good enough?
It is better than nothing, but the file is still copied around, has one shared password and offers no record of who looked. A password manager gives each person their own login.
Which password manager should I use?
The NCSC says the best choice is the one that meets your needs and that you find easiest to use. I do not recommend a vendor here.
What about passkeys?
The NCSC recommends passkeys as the first choice wherever they are offered, and a strong unique password plus two-step verification where they are not.
Should the browser save passwords instead?
The NCSC says passwords saved in a browser are only as secure as the device and account, and should never be saved on shared public computers.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.