• About
    • About German Pearls
    • Reviews and Testimonials
    • Legal Stuff
    • Blogging Resources
  • Contact
  • Services
    • Website Design
    • Website Maintenance
      • HTTP to HTTPS Migration
    • Microsoft Access Support
  • Tech Tips
  • Gadgets
    • Email
    • Facebook
    • Pinterest
    • Twitter
    • YouTube

German Pearls

Tech Tips for Non-Tech Types

  • iPhoneiphone, ipad, ios
  • Appsios, android, windows
  • Windows & Officemicrosoft products
    • Microsoft Excel
    • Microsoft Powerpoint
    • Windows 8 and 8.1
    • Windows 10
  • Misc Tech Tipsgoogle, internet, etc
    • Google
  • Practical Usesget stuff done!
  • Tech Gadgetsreviews and recommendations
You are here: Home / Microsoft Windows and Office / Microsoft Excel / How to Use Excel as a Password Keeper (Free Template)

How to Use Excel as a Password Keeper (Free Template)


Between social media, online banking, shopping sites, work sites, and more how many passwords have you created? How many passwords have you forgotten? If you’re like most people you’ve forgotten too many and always at the worst times! And sometimes it’s not easy to get back in to your account or device (if you get locked out of your iPhone we can help). A password keeper can help you keep track of all your passwords to make sure you always have easy access to your accounts. Below is a quick tutorial on how to use excel as a password keeper.

Note: If you prefer not to make the spreadsheet check out the bottom of this post to get your free copy of the password file.

Here's a tutorial on how to use excel as a password keeper, with a free template for a password book! Never lose a password again!

Here's a tutorial on how to use excel as a password keeper, with a free template for a password book! Never lose a password again!

Note: This post may contain affiliate links.

Key Components of a Password Log Book

First let’s talk about what’s important in a password book. The obvious answer is passwords! But, there’s more information that may also be relevant and important to keep together. My password log has the following information for each entry:

  • Account Name – what is this password for?
  • Category – is this for work, online banking, shopping, a hobby, etc
  • Email – if you have multiple email addresses, which email did you use with this account
  • Username – if there is a username associated with this account
  • Password – what password did you use
  • Security Questions – did you have to answer security questions, if so, what answers did you give
  • Account # – sometimes there is also an account number you want to remember
  • Comments – just an extra section for any comments or notes you want to remember

Need a custom excel spreadsheet for your home or business? I can build one for you. Click here to see the services I offer.

Create a Password Keeper File in Excel

Now that we know what we want included, how do we create our password keeper in excel? If you’re new to Excel it may be helpful to read through this quick Excel 101 tutorial before you begin.

  1. Open Excel and start a new workbook
  2. Create the following column headers by typing the words below into the cells indicated:
    • Cell A1 – Account
    • Cell B1 – Category
    • Cell C1 – Website
    • Cell D1 – Username
    • Cell E1 – Password
    • Cell F1 – Security Questions
    • Cell G1 – Email Provided
    • Cell H1 – Account #
    • Cell I1 – Comments
  3. We want the header row to be more prominent so make the text in row 1 bold. Highlight row 1 by clicking on the gray 1 to the left of that row and click on the bold icon.How to Use Microsoft Excel as a Password Keeper (or a Password Log)
  4. Next, let’s “fix” our header row at the top of the screen so if we end up creating hundreds of rows (you’d be surprised how many passwords you’ll need to keep) the header row is always at the top and visible. To do this, select cell A2 by clicking in it. Then, under the View menu, click Freeze Panes.
    How to Use Microsoft Excel as a Password Keeper (or a Password Log)
    This will force all rows above and all columns to the left of the current cell to stay fixed as you navigate around the spreadsheet. So, since only row 1 is above the cursor (and no columns are to the left of it) row 1 will stay at the top of the spreadsheet even if you scroll down to row 300. Give it a try!
  5. Now let’s make finding an account a little easier by adding filters to the headers. Excel makes adding filters extremely easy. Simply click on any one of the cells in row 1, then, go to the Editing section under the Home tab, click Sort and Filter and select Filter.
    How to Use Microsoft Excel as a Password Keeper (or a Password Log)
    You’ll notice that there are dropdowns arrows next to each column name. Once you add data you can use these dropdowns to find your data quicker. Below is an example with some data entered:
    How to Use Microsoft Excel as a Password Keeper (or a Password Log)
    From the filter dropdown you can search for an item, sort the table or select certain item(s) using the checkboxes.
  6. Next let’s make some of the columns a little wider so the words are visible. Highlight the entire worksheet by clicking in the gray rectangle in the upper left corner. Then, once the entire sheet is selected (grayed out), move your cursor over top of the line between the column A and B headers. When the cursor changes to a line with a left and right arrow coming out of it, double click.
    How to Use Microsoft Excel as a Password Keeper (or a Password Log)
    This will automatically change the width of column A to fit the data (or text in our case) in column A. And, since we have the entire worksheet highlighted, every column in the worksheet will automatically adjust to fit the data in each column.
  7. Though I don’t recommend printing and keeping your password book anywhere some people prefer to do it this way. So let’s modify the page setup so we can print the password list if we want to. Go to file and select print to see the print preview.
    How to Use Microsoft Excel as a Password Keeper (or a Password Log)
    From the preview it looks like our password sheet is too wide for one piece of paper so let’s change the orientation to landscape so it prints on the long side of the paper.
    How to Use Microsoft Excel as a Password Keeper (or a Password Log)
    The password log is still too big so it’s carrying over to page 2. So, select “fit sheet on one page” from the scaling button. Now our entire password spreadsheet fits on one page.


How to Put Password on Excel File

Now, how secure would a password file be if it anyone could find and open it? Not very. So, let’s secure our password keeper by putting a password on the excel file. To add a password to the excel file open the file menu. From the info tab select “protect workbook”. From the dropdown select encrypt with password. You will then need to select a password by entering it twice (it is very important you remember this one!).  Now every time you open the file you’ll need to enter the password you just created.

How to Use Microsoft Excel as a Password Keeper (or a Password Log)

Note: You may also be interested in this post on how to convert excel to pdf for free.

Storing your Password Book

For easy and ready access it’s convenient to store your new password log in the cloud. Services like dropbox and google drive are the perfect place to keep your password file so you can access it on the go on your smartphone. (Check out this post for more information on the cloud and a comparison of cloud services.)

As one final security step, don’t name your file password keeper. Change the name to something that you can recognize but doesn’t yell out to hackers MY PASSWORDS ARE STORED HERE!

For a free copy of the password log template, subscribe below.

Subscribe to our mailing list

* indicates required


Note: After clicking download head over to your email and look for an email from Amy @ German Pearls. If you don’t see our email check your spam folder (they sometimes hide there 🙂 ).

Conclusion

While there are many methods available for maintaining your password log I’ve found this method to be helpful and convenient. How do you store all that secure information? Is there another way you prefer? Leave a comment below.

If you’re looking for a different type of Excel spreadsheet template we can make you a custom spreadsheet or database. Check out our services here.

Pin906
Share7
Tweet11
924 Shares
Pin906
Share7
Tweet11
924 Shares
«
»

February 1, 2016

Related

Comments

  1. Jamie says

    February 22, 2016 at 10:31 am

    This is a great tutorial and something I desperately need to do! I waste a lot of time resetting passwords that I have forgotten! Thanks so much for the template too..a great timesaver!

    • amy says

      February 22, 2016 at 10:50 am

      Hopefully the template will help and save you time and frustration from lost passwords. 🙂 Thanks for stopping by! 🙂

  2. Pamela says

    April 9, 2016 at 12:55 pm

    I can’t get it to download.
    Pamela

    • amy says

      April 9, 2016 at 9:09 pm

      I’m sorry you’re having difficulty Pamela. I’ve emailed you the template. If you have more trouble feel free to reach out to me.
      -Amy

  3. gale says

    May 1, 2016 at 12:06 am

    Hello Amy,
    I like your page. Download would not function for me. Can you email one out to me as well?
    Thank You

    • amy says

      May 1, 2016 at 8:02 pm

      Hi Gale,
      Sorry for the difficulty in downloading the file. I’ve sent it to you in an email. If you have any questions, feel free to reach out!
      Amy

  4. Susan Svancarek says

    May 3, 2016 at 12:50 pm

    Could you please email me the template as I also could not download. Thanks so much!!!

    • amy says

      May 3, 2016 at 4:49 pm

      Susan,
      I apologize for the trouble. I’ve emailed you a copy of the template. Let me know if you have questions!
      Amy

  5. Nancy says

    May 9, 2016 at 1:23 pm

    Hi there,
    I guess the download function is still not working properly. I too would appreciate receiving the template.
    That said, the instructions you have created are terrific and if I had not had to get this done asap, I would probably work through it.
    Thanks in advance,
    Nancy

    • amy says

      May 9, 2016 at 10:04 pm

      Hi Nancy,
      I’m so sorry. For some reason some email providers see my emails as spam. 🙁 If you wouldn’t mind, please check your SPAM folder to see if you received anything from German Pearls. I’m going to send you an email right now as well so you have the template. Enjoy! 🙂 Thanks for stopping by and hope to see you again!
      Amy

  6. Louise Grimm says

    May 23, 2016 at 12:45 pm

    Please send me the file as I can’t download it

    • amy says

      May 23, 2016 at 10:02 pm

      Sorry, my emails are getting caught in SPAM filters. I sent you an email with a link to download the template. Feel free to email me at amy(at)germanpearls(dot)com if you don’t receive it or if you have questions.
      Amy

  7. Jeff says

    May 31, 2016 at 4:24 pm

    Hi, Amy. I definitely prefer KeePass over this method, but this is more visually pleasing when printed for my parents.

    Thanks for the simple, yet effective tutorial. 🙂

    • amy says

      June 2, 2016 at 1:51 pm

      Thanks for the comment Jeff. I’ve seen several apps for keeping your password but haven’t tried any yet. Good to know this one is working for you.
      Amy

  8. elisabeth says

    June 7, 2016 at 4:19 pm

    hey!
    great template but i cant download it, can you send it to me?
    Thank you
    Elisabeth

    • amy says

      June 7, 2016 at 10:33 pm

      Elisabeth,
      I sent you an email – let me know if you have any questions!
      Amy

  9. Belinda Turner says

    July 20, 2016 at 11:50 am

    So simple and easy to follow instructions.
    I knew most of it but the few extra hints were so helpful.
    I looked at a few templates and even bought an App for passwords but it was far too complicated. All I really had to do was tidy up my scribble notes in a straightforward Excel Sheet.
    Thank you
    Belinda

    • amy says

      July 20, 2016 at 1:09 pm

      I’m so glad this was helpful to you Belinda. Once you get into the habit of updating the spreadsheet whenever you create a new account it’s a super simple system. Thanks for the comment! 🙂
      Amy

  10. Mark says

    July 24, 2016 at 11:16 am

    Hello Amy,
    I like your page. Download would not function for me. Can you email one out to me as well?
    Thank You

    • amy says

      August 27, 2016 at 8:46 pm

      Thanks Mark! Glad you like the page. 🙂 Not sure what’s going on with the download function. I emailed you a copy of the spreadsheet. Let me know if you have questions. 🙂
      Amy

  11. Anne says

    August 18, 2016 at 4:52 am

    Just what I have been looking for. I’ve followed all the steps. Learned a couple of ideas too using excel.

    Though I could not download the file, I did follow exactly the steps and I’m using it now to save my passwords.

    Thank you so much!

    • amy says

      August 23, 2016 at 8:51 pm

      Anne,
      Great – so glad you found this useful – thanks for leaving a comment and letting me know too. 🙂
      I apologize that you couldn’t download the file but glad you were able to get it up and running from the tutorial.
      Amy

  12. Quintin says

    September 11, 2016 at 1:36 am

    Hi Amy!

    I too user and prefers Key Pass but this is a great to make something simple and not complicated.

    One question, why the name German Pearls? I sense a bit of mystery, pizazz and refinement… Can you spill the beans? 🙂

    • amy says

      October 5, 2016 at 10:53 pm

      Hi Quintin,
      Of course… I write a bit about the name in my about page. Though I was born in the US I come from a strong German heritage. That is, I believe, where I get most of my personality traits: I’m organized, practical, logical, frugal and love tech and how things work. Those are all of the things I try to convey in my articles on the site. The Pearls comes from the industry I work in. They use the term to refer to tidbits of information, tips and tricks. So, with German Pearls I hope to bring little technical tips, tricks on how to be practical and logical and ways to be more efficient and save money. 🙂
      Amy

  13. purvesh tanwar says

    October 21, 2016 at 2:57 pm

    Hi

    I am unable to download.

    can you send it on my email id

    [email protected]

    • amy says

      October 27, 2016 at 7:07 pm

      Sure. I’ll send it over.
      Amy

  14. Amber says

    November 9, 2016 at 6:14 am

    Hey – great template – would love if you could please email it to me at [email protected] – thank u very very much 🙂

    • amy says

      November 9, 2016 at 10:27 pm

      Amber,
      I sent it over. 🙂
      Amy

  15. Cassandra says

    December 1, 2016 at 1:38 pm

    Hi! Thanks for the post. I have tried to download the file, I’ve checked my inbox and spam folder. Then waited an hour and checked again. Is it possible to email it to me? If so, [email protected] Thanks

    • amy says

      December 1, 2016 at 9:20 pm

      Sorry for your trouble. I’ve emailed you a copy of the file.
      If you have any questions, let me know!
      Amy

  16. Shelley says

    December 7, 2016 at 11:04 am

    I too am unable to download this spreadsheet.. Would you mind sending it to me please.

    • amy says

      December 10, 2016 at 8:22 pm

      Shelley,
      Looks like you got the email with the file. 🙂 Let me know if you have any problems with it.
      Amy

  17. Denise Fitzpatrick says

    December 7, 2016 at 11:12 am

    Please send excel form to my email address.

    • amy says

      December 10, 2016 at 8:26 pm

      Denise,
      It’s sent. Let me know if you have any problems.
      Amy

  18. Tap says

    January 10, 2017 at 7:38 am

    Need a copy of your spreadsheet, please. Request did not result in reply nor did it go into my known spam folder. Guess the old internet monster ate another one.
    Tap recently posted…Solved: Windows 10 Search Bar MissingMy Profile

    • amy says

      January 10, 2017 at 8:50 pm

      Tap,
      I resent it to your email. Let me know if you need help.
      Amy

  19. Francois B says

    January 11, 2017 at 1:15 pm

    I too cannot get the download link. Are you able to send me the link for this?

    Thanks.

    • amy says

      January 11, 2017 at 9:40 pm

      Francois,
      My email server shows it sent. Not sure why some of the emails don’t get through but I resent it.
      Let me know if you need help using it.
      Amy

  20. Robert L says

    February 22, 2017 at 7:02 pm

    Amy,
    The link download did not work for me either. Would you mind emailing it to me?
    Thank you in advance.

    • amy says

      February 27, 2017 at 9:03 pm

      Hi Robert,
      My email provider shows you got it on 2/23 but I just resent it to you, just in case. Let me know if you have any questions.
      Amy

  21. Regina Autry says

    March 29, 2017 at 12:09 pm

    i have not received a copy of the free templete can you email it to me please….. [email protected]

    • amy says

      April 2, 2017 at 9:26 am

      Regina,
      Some email servers are flagging these emails as spam. I resent the template to you. Let me know if you have any questions on it.
      Amy

  22. Melissa says

    March 21, 2018 at 10:01 pm

    Hi Amy- Thanks for the great instructions! I have been wanting to create a PW list like this for some time now. Your instructions were SUPER EASY to follow! I will check out your other ideas. Very grateful I came across your page!

    • amy says

      March 22, 2018 at 9:40 pm

      Thank you Melissa and good luck managing all those passwords!! My list keeps growing! I’ve also tried a few password managers like Dashlane and LastPass…you may want to take a look at those as well.
      Good luck!
      Amy

  23. LeAnn Ladd says

    November 7, 2019 at 10:43 am

    Hello, it’s 2019 and I know this post is a bit dated, but the information is right on time. Thank you so much — I just created the password manager in Microsoft Excel following your instructions and it works perfectly. I have been fretting over a way to keep my passwords in one place, protected and this was exactly what I was looking for. Thank you so much.

    • amy says

      May 15, 2020 at 3:38 pm

      Glad it helped LeAnn!

Trackbacks

  1. Excel 101: An Introduction to Excel - German Pearls says:
    July 20, 2016 at 1:32 pm

    […] Also: How to use Microsoft Excel as a Password Keeper (with a free […]

  2. How to Make Printable Labels for Toy Storage Bins - German Pearls says:
    August 8, 2016 at 8:01 am

    […] See Also: How to Use Microsoft Excel to create a Password Keeper (with a Free Template) […]

  3. How to Share Apps with iOS Family Sharing - German Pearls says:
    November 6, 2016 at 12:21 am

    […] Create a password for the account; This must have at least one capital letter, lowercase letter and number See Also: Get a Free Password Keeper Template in Excel […]

  4. Help! I Forgot My iPhone Passcode! - German Pearls says:
    January 31, 2017 at 9:14 pm

    […] Having gone through this process and spent some time researching the issue we came across many different methods that are said to be successful ways to recover your iPhone after losing your passcode. However, many of these methods did not work for us. That being said, there a lot of different iPhone versions, iOS versions, iTunes versions, etc so maybe these methods worked for others. Have you ever lost your iPhone passcode? What did you do? Leave a comment below if you have another method. Also, if the method above didn’t work for you because you don’t have your iPhone backed up to a computer check out this apple post and check out our article on how to better keep track of your passwords. […]

  5. A Review of Dashlane Password Manager - German Pearls says:
    April 24, 2017 at 10:31 am

    […] you’ve read my Excel tutorial on how to create a password keeper template you’ll know how I kept track of my dozens […]

Amy @ German Pearls Hi, I'm Amy, an Engineer and tech-geek who loves helping others with tech problems. With German Pearls I hope to be able to help more people enjoy the benefits of the latest and greatest computers and gadgets. Thanks for stopping by!
  • Email
  • Facebook
  • Pinterest
  • Twitter
  • YouTube

Like Us on Facebook

German Pearls - Tech Tips

Subscribe for Tech Tips and News

Subscribe to our mailing list

* indicates required

Web Design

GP Small Business Web Design in Saratoga Springs, NY

Popular Posts

Norton Core Review: The Router of the Future is Here
How to Lower your Monthly Spectrum Cable Bill
How Do I Open a Winmail DAT File?
Stop Facebook Videos from Automatically Playing (or Turn off Sound)
How to See an iPhone Message Timestamp
Learn How to Organize Bookmarks in Chrome

Also Featured On

lifehack mode media German Pearls was featured on the Money Saving Mom retired by 40

TECH SERVICES

German Pearls Tech Services | Website Design | Website Maintenance | Excel Spreadsheet Development | Tech Support Services near Saratoga Springs, NY

Recent Posts

  • Norton Core Review: The Router of the Future is Here
  • How to Lower your Monthly Spectrum Cable Bill
  • How Do I Open a Winmail DAT File?
  • Stop Facebook Videos from Automatically Playing (or Turn off Sound)
  • How to See an iPhone Message Timestamp

Services

  • Microsoft Access Support
  • Microsoft Excel Support
  • Website Design
  • Website Maintenance & Support

Reviews

★ ★ ★ ★ ★
(based on 4 reviews)

Browse Articles

  • iPhone and iPad
  • Microsoft Windows and Office
    • Windows 10
    • Microsoft Excel
    • Microsoft Powerpoint
  • Apps
  • Misc Tech Tips
  • Tech Gadgets and Products
  • Practical Uses

Like us on Facebook

German Pearls - Tech Tips

Search

Copyright © 2023 · Privacy Policy

Copyright © 2023 · Flourish Theme on Genesis Framework · WordPress · Log in