
Remove duplicates without losing the only valid secret
Duplicate cleanup reduces confusion, but deletion must follow verification. Compare account identifiers, service URLs, ownership and last-tested dates without emailing or pasting secret values into a new worksheet.
Three rows appear to describe the same supplier portal. One belongs to a retired account, one has no owner, and one was successfully used this month. The reviewer confirms ownership and recovery contacts before retiring obsolete records.
Use a controlled sequence
- 01Work from a protected duplicate and preserve the original until validation is complete.
- 02Group likely duplicates by service, username or account owner—not by password value.
- 03Ask the accountable owner to identify the active record and recovery method.
- 04Rotate exposed or shared credentials through the service itself rather than merely editing the spreadsheet.
- 05Mark the disposition and obtain review before deleting an obsolete entry.
Leave evidence without copying secrets
Keep account identifier, owner, decision, validation date, rotation status and reviewer. Do not record the old and new passwords in the cleanup log.
Pause and review when
- A duplicate is deleted only because its modified date is older.
- One password is reused across several services.
- No one can verify the account owner or recovery channel.
Encrypted files are not a password manager
Encrypted-file storage is not password autofill, browser sync or a general credential manager. Match the system to the user task and test recovery before removing the source.
Run the final independent check
Before approving cleanup, have the account owner demonstrate that the retained credential reaches the intended service and that recovery contacts are current. Record validation without exposing the secret. If two records cannot be distinguished safely, quarantine both under restricted access and escalate; do not guess. Reused credentials require rotation at every affected service, followed by session and token review where the provider supports it.
Resolve these before acting
Does removing a spreadsheet row revoke access?
No. Change or revoke the credential in the service and review sessions, tokens and recovery methods.
Should reused passwords be copied into the destination?
No. Rotate them to unique credentials and use an appropriate password manager when the task requires password generation and autofill.
Sources for this decision
- CISA: use a password manager for strong, unique passwords
- NIST SP 800-63B: authentication and authenticator management
Links support the specific decision on this page and do not imply endorsement. Organizational policy and qualified advice control the real migration.