Template

Client Database in Excel: Download the Template

A ready-made Excel client database for insurance agents and distributors. It keeps contact details, family, policies and important dates in one sheet and shows who to contact this week.

By Pritam DeUpdated 5 min read

A client database is a sheet with one row per client, holding the details you need to look after them: contact information, family, the policies they hold and the next time you will speak. The template below also counts down to birthdays and other important dates, and shows who is due a contact this week.

Client database (.xlsx)Opens in Excel and Google Sheets. No sign-up needed to download. Includes 2 sample rows and a how-to sheet.
Download the template

Would you rather every client, policy and conversation sat on one page? Advisend keeps them together. Start free. No card needed. Start free in minutes.

What is inside the template

The database has 18 columns. You type in 15 of them. The sheet fills in three: Days to birthday, Days to that date and Contact status.

Column What goes there Why it helps
Client name, Mobile, Email, City Who they are The basics, one row per person
OK to email about renewals? Yes or No Records who has asked you to email them
Date of birth, Days to birthday The date, then a countdown Reminds you to wish them a happy birthday
Other important date, What it is, Days to that date For example a wedding anniversary The same countdown for a date that matters to them
Family members Spouse, children, parents Helps you ask better questions at a review
Policies held A short list in words A quick view of what each client has
Best way to reach WhatsApp, call, email or in person Contact them the way they answer
Next renewal date The nearest renewal Links this sheet to your renewal tracker
Last contacted, Next contact date Your relationship record Nobody goes quiet by accident
Contact status Filled in by the sheet Overdue, Due today, Due in 7 days or Later
Notes What matters about this client What they care about, in your words

Set it up in 5 steps

  1. Download and open the file. Delete the two sample rows first.
  2. Add your clients. One row per person, not per policy. Name and mobile are the two you must have.
  3. Add dates of birth and other important dates. The countdown columns do the rest.
  4. Set a Next contact date for every client. Even a gentle check-in a few months away counts.
  5. Leave the countdown and Contact status columns alone. They are formulas.

Advisend Add customer form with name, mobile, date of birth, email, city and a box for whether the customer has asked to be emailed about renewals

The same details in Advisend’s Add customer form, including a box to record whether the customer has asked to be emailed about renewals.

How the birthday countdown works

The sheet finds the next time the date comes round and subtracts today:

=IF(F2="","",DATE(YEAR(TODAY())+(DATE(YEAR(TODAY()),MONTH(F2),DAY(F2))<TODAY()),MONTH(F2),DAY(F2))-TODAY())

If this year’s birthday has already passed, it counts to next year’s. A cell turns amber when the date is 7 days away or less. The same formula works for an anniversary or any other date you add.

Why important dates matter

A birthday message or an anniversary note is not a sales pitch. It tells a client that you know them as a person, and clients who feel known tend to stay. Send the message and leave the selling for another day.

A 10-minute weekly routine

Pick a fixed time, such as Monday morning:

  1. Filter Contact status to Overdue. Reach out to each client and set a new date.
  2. Filter to Due today and Due in 7 days. Plan your calls and messages for the week.
  3. Sort Days to birthday and look at the amber cells. Send those messages.
  4. After each contact, update Last contacted, Notes and the next date.

For the renewals side of the same clients, use the renewal tracker template and the list of 7 things to record on every policy.

Keep client details safe

This sheet holds names, phone numbers, dates of birth and family details. Keep one master copy, protect the file with a password, keep a backup and avoid forwarding the whole file over chat apps. Record whether a client is happy to be emailed, and respect that.

Where a sheet starts to struggle

A spreadsheet is a good place to begin. Most agents outgrow it for the same reasons:

  • It never reminds you. The birthday countdown only helps if you open the file.
  • One row cannot hold a relationship. A year of calls, promises and policies does not fit in a notes column.
  • Policies live somewhere else. You keep a second sheet for renewals, and the two drift apart.
  • It is awkward on a phone. Looking up a client before a meeting means scrolling a wide sheet.

Advisend customers list with name, mobile, number of policies, email and city

The same list in Advisend: each customer shows their mobile, how many policies they hold, their email and city. You can search by name, mobile or email.

The whole system around this sheet is in Client relationship management for agents.

Winning a lead? Set them to Won in the lead tracker template and add them here.

Ready to see every client, policy and conversation in one place? See how Advisend handles client relationships, or start free. No card needed. Start free in minutes.

Questions agents ask

Can I use this client database in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. The date formulas, drop-down lists and colour rules all work there.

How many clients can the template hold?

It is set up for 300 clients. To add more, copy the last row and paste it below. The formulas come with it.

Should policy details go in this sheet?

Only a short list in words, such as health and term. Keep full policy details, with due dates and premiums, in your renewal tracker or policy records.

Is it safe to keep client details in a spreadsheet?

It can be, if you take care. Keep one master copy, protect the file with a password, keep a backup and avoid sending the whole file over chat apps.

Every client, policy and conversation in one place.

Advisend keeps your clients in one place and reminds you by email and WhatsApp, so you can spend your day with clients.

No card needed. Start free in minutes.

Keep reading