Create your own simple Password Manager

padlock - representing simple password manager

All you need is Word or Excel or similar

post it notes on wall
Great for brainstorming and homilies – rubbish as a password manager

In my last blog post, I found another reason for not re-using passwords.

However, the problem a lot of my IT support clients complain of is that they just can’t keep track of multiple passwords – so they re-use the same ones.

The best solution is to use a password manager such as Dashlane or Safe in Cloud. This seems like overkill for a lot of people, making life even more complicated. And one thing we know about computer software is that if it is too complicated  then people will not use it.

So, a balanced solution is to create a simple password manager. As well as being simple, it will be close to hand, quick to use and easy to keep up to date.

To begin with, what data do we need to keep in our simple password manager?

I recommend that, every time you create a new account and password, you record:

Today’s date

You may think this un-necessary, but it can help you decide which of two passwords is the more recent. Also,Google (for instance) asks during an account recovery process for the date that you created the account.

The username on the account

This is probably, but not necessarily, an email address. And most of us have several of those. If you might have used one of three usernames  and one of three passwords that you habitually re-use (!), then there are already nine possible combinations. So, always write down the username.

The email address (if different from username)

Believe it or not, some account providers ask you to specify both, so it’s better to have a record of both.

The password

The subject of what makes an adequate password is too big to discuss here. Have a look at “Passwords still cause untold grief“. Alternatively, type the word “passwords” into the search box at the top of any page or post on this site.

Recovery information

Most online accounts will now ask for an email address and/or a mobile phone number where the account provider can send a code that allows you to get back into your account if there is a password problem. My experience tells me that it is most definitely a good thing to be unequivocally certain as to this recovery information. If you are having password problems you really do not want to be asking yourself “did I use my Hotmail address, my son’s address, my daughter’s address?” etcetera.

Other information

For instance, the web address of where you actually get into the account. Note that both Excel and Word will automatically create clickable links to web addresses that they find in any worksheet/document.

Whether you record details of password updates here, or create a new entry, is a matter of choice but do make sure you put a date on updates and make sure you know how to search for multiple entries that refer to the same item at different times if you create a new entry every time you update something.

The next important question is – of course – the security of your simple password manager

ConfusedWhether you use a word processing document or a spreadsheet is just a matter of choice – as is the formatting. Personally I would use Excel and place one username/password combination on each row.

You must password-protect your document/worksheet

If you are using any program other than Microsoft Word or Excel then you need to ensure that it will allow you to assign a password. This is how that’s done in Word or Excel in Office 2016 (and Office 365):

The process is exactly the same in Word as in Excel except that Word refers to “documents” and Excel refers to “worksheets”:

  • Click on the “File” menu (top left of Word or Excel window)
  • Click on the box labelled “Protect Document” (or “Workbook”)
  • Click on “Encrypt with password”
  • Type your new password in the box provided and then click on “OK”
  • Type the same password again (to ensure that you typed the password as you intended)
  • Save your document/workbook by clicking on “Save” in the left sidebar


Are the days of the post-it note numbered? As far as passwords are concerned, they certainly should be.

And if, after all this, you think it’s time to take the plunge and invest in a “proper” password manager, have a look at

One other thing: it is, of course, absolutely essential that you record any changes of passwords in the same place as soon as possible. Yes, I know it’s a pain in the neck, but so is getting back into an account when you can’t find the password!

(Last updated 22/08/2023)