A simple Address book template in Excel

Address book template

With this template you can save all your adresses and phonenumbers of the people you know. There are a few benefits of having a Excel Address book above having it on paper:

  • When somebody moves or changes phonenumber you can easily change it without making a mess in the Address book.
  • If you save it in a place like dropbox, onedrive or googledrive you can Always use it on all your devices connected to those boxes.
  • You can look up things in different ways in Excel compared to in a ‘normal’ address book where you can only look up one way on alphabet. In Excel you can look up on their name, last name, Phone number, etc.

Address book Excel

Let’s get a look at the template. There are the following columns:

  • Name
  • Lastname
  • Subject
  • Phonenumber 1-6
  • Email
  • Address
  • Zipcode
  • City
  • Country
  • Comments

Search with Ctrl & f

You can look up things with ctrl+f. A box opens up in which you fill in the name or number you want to look up. It then searches for it and gives you the results.

Search with ctrl and f

Search with filter

On top of the file you see the filters. Open the filter. You can choose to sort alphabetically or choose all the names with an e. The first one sorts everything alphabetically on first name. You can sort alphabetically in each column. The second one gives you all the names starting with an e.

Search with filter

You can download the Dutch or English template. Have fun using the template.

Other Excel templates can be found here. If you want to upgrade your Excel knowledge see the possibilities here. You can also read more blogs about Excel.

Blog Curacao Reading

5 Less known slavery stories

There are a lot of books and movies out there about slavery and even some blockbusters, but today I want...
Read More
5 Less known slavery stories
Blog Investing Life

7 lessons I learned from the finance course on Instagram

Because I would like to reach FIRE (Financial independent and Retire early) in a few years and want to get...
Read More
7 lessons I learned from the finance course on Instagram
Blog Investing Life

7 Tips to save on groceries

Groceries always come out more expensive than you had in mind and then you also forget some ingredients and you...
Read More
7 Tips to save on groceries
Blog entrepreneur Hiking Life Travel

My after Corona Bucket List

I would like to share with you my bucket list for after Corona era. Actually, it is more of a...
Read More
My after Corona Bucket List
Blog Investing Life

I don’t want to know about my student debt

Last week I took part in the student debt challenge of Maaike van fuck that student debt (fuck die studieschuld)....
Read More
3 Replies
I don’t want to know about my student debt
Blog Life

Chocolate fair

For the second time I couldn't stop myself from going to the Chocolate fair in Amsterdam in February. It is...
Read More
Chocolate fair
Blog Hiking

Not one but two walking related conferences just before spring starts

This year I went to the Mountain climbing conference in Nieuwegein as well as the Walking & Cycling Fair in...
Read More
Not one but two walking related conferences just before spring starts
Blog Hiking Travel

Hiking between Cascais and Sintra

Cascais is the escape city for Lisbon, Portugal if you want to be by the sea. I traveled twice to...
Read More
Hiking between Cascais and Sintra
Blog Life

No I am not ….

No, I am not eating more Unfortunately, was it that easy. That I started eating more and by eating less...
Read More
No I am not ….
Blog Life

No reason Retroprints

Would you like to try out our retroprints in exchange for a blog on your website? Actually yes, I wanted...
Read More
No reason Retroprints
Blog Curacao Hiking

Caracasbaai peninsula

I would like to take a long walk on Curaçao. In the meantime, there are about three organizations that offer...
Read More
Caracasbaai peninsula
Blog Life

1 percent turnover to Wegloophuis Utrecht

1 percent turnover to charity This year 1 percent of my turnover goes to charity. A different charity each quarter....
Read More
1 percent turnover to Wegloophuis Utrecht
Blog Curacao entrepreneur

1st quarter 2020

1st quarter 2020 The first quarter of 2020 started with me as a digital nomad working on Curaçao. That means...
Read More
1st quarter 2020
Blog Hiking Travel

7 things I would like to do in Spain

I have been to Spain before and every time I discover new things that I would like to do. That's...
Read More
2 Replies
7 things I would like to do in Spain
Blog Hiking Life

The 5 types of hikers

In my opinion there are 5 types of hikers among the hikers. I would like to share with you those...
Read More
The 5 types of hikers
Blog Life Travel

5 reasons to live in southern Spain in winter

My dream is to escape the winter. I did that all winter in 2013/2014 by going to Australia and New...
Read More
5 reasons to live in southern Spain in winter
Blog Hiking Travel

7 reasons to walk a 4 Days hike

  While walking my 2nd Four Days Marche I have thought of 7 reasons why you should walk a 4...
Read More
7 reasons to walk a 4 Days hike
Blog Hiking Life Netherlands

Farewell to Strijp-S in Style

How do you say goodbye to Strijp-S in style? I lived in Strijp-s, Eindhoven for 2.5 years and saw the...
Read More
Farewell to Strijp-S in Style
Blog entrepreneur Investing Life Reading

The 5 lessons I learned from the book Blondies invest better

I share 5 lessons with you that I learned from the book Blondies Invest Better (Dutch book Blondjes beleggen beter)....
Read More
The 5 lessons I learned from the book Blondies invest better
Blog Life

1 percent gross turnover to the Food Bank

1 percent turnover to the Food Bank This year I want to donate 1 percent of my turnover to charities...
Read More
1 percent gross turnover to the Food Bank
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300,"lazyload":""}

 

 

 

 

 

Sharing is appreciated