Somewhere in a shared folder sits a file named "shared-accounts-list.xlsx". If you work in general affairs or IT, it probably looks familiar. Anyone can use Excel, and adding columns or sorting is easy. It's without doubt the handiest tool for making a list of passwords.
This article is for IT and general affairs staff at companies that manage their passwords in Excel. It lays out what Excel management lacks, alongside Microsoft's official explanations, then covers the minimum to do if you can't move right away and how to prepare your sheet when moving to a password manager.
The explanations from Microsoft and public agencies are what their official sites said as of November 9, 2026.
Summary: Excel suits a "list", not a "place to keep keys"
- Sheet and workbook protection don't protect passwords. Microsoft explains that "Worksheet level protection is not intended as a security feature." What does protect the contents is the password for opening the file (encryption)
- The password for opening the file ends up being shared too. For a list a team uses, the file password gets passed around in chat or by word of mouth, and the number of people who know it keeps growing
- There's no record of who opened it when, or where they copied it. When someone leaves, you can't tell which passwords to change
- If you can't move right away, you can start these 3 things today: encrypt the file, restrict where it's stored, and share the file password through a separate channel
- When you move, the shortcut is to add headers to your current sheet and save it as CSV. Many password managers support CSV import
The risks of managing passwords in Excel
Sheet and workbook protection don't protect the contents
Excel protection has 3 levels. In Microsoft's words, file protection lets you "lock down an Excel file by specifying a password", workbook protection lets you "lock the structure of your workbook", and worksheet protection lets you "control how a user can work within worksheets".
Of these, Microsoft states plainly that worksheet protection "is not intended as a security feature." It's a feature for keeping cells from being changed, not for keeping them from being read. A practice like "we protected the sheet with the password column, so we're fine" protects much less than it appears.
If you forget the file password, nobody can open it
If you set a password for opening the file, the contents are encrypted. However, Microsoft writes that "if you forget or lose your password, Microsoft can't retrieve it for you." If the one person holding the file password transfers or leaves, the company's important list can no longer be opened.
Copies multiply until no one knows where they are
Excel files are easy to copy and to attach to emails. Besides the original in the shared folder, copies pile up on someone's desktop, in email attachments, and pasted into chat. Even if you fix the original, the old copies still hold the old passwords.
No record of who viewed it
What you really want to know from a password list is "if this person leaves, which passwords should we change?" In Excel, nothing records who opened the file, which rows they looked at, or whether they copied anything down. As a result, it tends to come down to changing everything or changing nothing.
Two-factor codes tend to end up in the same sheet
These days, shared accounts also require two-factor authentication. If you write the authenticator app's setup keys in the same sheet "just in case", the passwords and the two-factor setup keys end up together in one file. If that file leaks, two-factor authentication loses its point.
If you still use Excel, the minimum to do
Some companies can't bring in a tool right away. Even then, you can start the following today.
- Set a password for opening the file. Use encryption of the whole file, not sheet protection. Make the password long enough to be hard to guess, and don't reuse it elsewhere
- Share the file password through a separate channel. Don't write it in the same email or chat as the file. The Ministry of Internal Affairs and Communications' site also urges people not to exchange passwords by email
- Keep it in one place and don't make copies. Put it in a shared folder with limited viewers, and prohibit email attachments and copies to the desktop
- Make sure at least 2 people know the file password. If only one person knows it, it can't be recovered when they forget it
- Keep two-factor setup keys elsewhere. Don't put them in the same sheet as the passwords
To avoid reuse, IPA (Information-technology Promotion Agency, Japan) describes a method where you memorize only a "core password" and record a per-service identifier in an electronic file or on paper. That method is an option for personal passwords, but it doesn't suit teams sharing the same account.
What to decide as a company
- Which accounts may be shared. Review whether you're sharing accounts even for services that should really have one account per person
- Who manages the list. Decide who adds, changes, and deletes entries, and record the date when something changes
- What to do when someone leaves. Make it a procedure to list the accounts the departing person could see and change those passwords
- When to move to a tool. Decide how long you'll keep managing in Excel, and tighten the practice during that time as described above
How to prepare your sheet when moving to a password manager
Most password managers support CSV import. Your Excel list is easier to move if you prepare it as follows and then save it as "CSV".
- Put headers in row 1. Create columns for title (service name), ID, password, URL, and notes
- One value per cell. If the sheet puts "ID / password" in a single cell, split it into columns
- Include URLs. Almost all products match by URL when the browser extension suggests entries on a sign-in page
- Add a column for department or group. This makes it easier to divide entries into sharing units after importing
Importing into Samurai App
"Import" on Samurai App's "Passwords" screen can read CSV files with headers. Headers can be in Japanese or English, and it reads the following spellings as columns.
| Column | Examples of headers it reads |
|---|---|
| Title | Japanese labels for title, name, or service, plus title, name |
| ID | ID, Japanese labels for user name, login ID, or email address, plus username, email |
| Password | The Japanese label for password, plus password |
| URL | URL, the Japanese label for login URL, plus website |
| Notes | Japanese labels for notes or remarks, plus notes |
| Tags | The Japanese label for tags, plus tags (multiple, comma-separated), folder (one) |
- If there's no title or URL column, it stops with "No title or URL column was found. Put headers in row 1."
- It also detects the character encoding and reads Shift_JIS CSV files exported by older spreadsheet software
- The file is read inside the browser and encrypted before it's sent. Before importing, it shows how many logins, notes, and cards it read
After importing, delete the original Excel and CSV files, along with any copies left in shared folders or email. If many people could see the list, change passwords, starting with your most important accounts.
What Samurai App can and can't do
Samurai App's "Passwords" is a vault for passwords that people read and share. It fills the gaps in an Excel list as follows.
- Contents are encrypted in the browser. Titles and URLs are encrypted too, and while stored, neither the server, the operators, nor the AI can read them
- You decide who to share with, and in what role, per vault. The roles are "Admin", "Editor", and "Viewer". There's no need to pass around an Excel file password
- Change history is kept. For each item, the last 20 versions show when, who, and which field was changed
- Displaying and copying a password is recorded in the audit log. However, it's recorded as a report from the browser, so it isn't proof of who read the value
- Copied values are cleared from the clipboard after 30 seconds
There are also things it can't do.
- Viewers can also read and copy values. Values noted down by someone you removed can't be taken back, so change the passwords for the relevant services after removing them
- AI can't use the vault. For sites where you want AI to sign in, register them separately in "Browser authentication"
- Each vault holds up to 2,000 items
How to roll out sharing is covered in How to share passwords within your company, and product details are on the Password manager page.
FAQ
Is managing passwords in Excel safe if I put a password on the file?
Setting a password for opening the file encrypts the contents, so it's better protected than without one. But if a team uses it, the file password itself gets shared, and you can't control who knows it. Microsoft explains that sheet and workbook protection aren't security features, so they can't be used to protect passwords.
Is there a template for a password list?
As a guide, use 6 columns: title (service name), ID, password, URL, notes, and department. In this shape, it's also easy to import as CSV when you later move to a password manager.
Is a spreadsheet in Google Sheets safe?
Being able to set sharing scope in detail is convenient, but everyone who can open the sheet can read the password values. You also need to check that sharing hasn't been widened to anyone with the link. As with Excel, you can't tell who looked at which row.
What about managing passwords on paper?
For personal passwords, paper has the advantage of not being stolen over a network. The Ministry of Internal Affairs and Communications' site also advises that if you must write them down, keep them in a locked desk or safe. For team sharing, though, every time the paper is passed around more copies appear, so it isn't suitable.
Sources
- Protection and security in Excel (Microsoft Support)
- Setting and managing secure passwords (Ministry of Internal Affairs and Communications, Cybersecurity site for citizens)
- Don't reuse passwords, a cause of unauthorized login damage (IPA)
- Passwords (how to use) (Samurai App)
The explanations from Microsoft and public agencies were checked against what each official site said as of November 9, 2026.