In this article:

Google Sheets Contact List Template for 2024 [Free]

May 8, 2024

In this article we will show how to copy our free google sheets contact list template and enter data in just a few simple steps. Simply follow the steps below:

Google Sheets Contact List Template

1. Open the Template Link

Access our Contact List Template by clicking the link below:

2. Click Make a copy 

A new tab or window will be loaded after clicking the link, with the following message:

google sheets contact list template

Click Make a copy.

You now have your own copy of the sample template that we have here at Lido! This is the sheet that appears first:

contact list template google sheets

The contact list is in the sheet under the tab ContactList:

google sheets email list template‍

3. Edit the Template and Fill it with Data

Now that you have your own copy of the template, you are free to edit it!

First, you can delete the Instructions tab by right-clicking the tab and selecting Delete. A box will appear asking you if you are sure about deleting the tab. Click OK

google sheets email template

Next, you can now either edit the sheet first by adding rows or setting formulas that you need, or fill it up with data from different eCommerce and marketing platforms! Some of the tutorials we have related to contact lists are the following:

Extract Name From Email Address in Google Sheets (2023 Update)

Extract Domain from Email in Google Sheets (Easiest Way in 2023)

For importing details to the contact lists, you can check the following tutorials:

How to Create an Email List From Google Sheets (2023 Update)

Import CSV from Email into Google Sheets (Easiest Way 2023)

Connect Slack to Google Sheets (Easiest Way in 2023)

Connect Salesforce to Google Sheets (Easiest Way in 2023!)

Connect Zendesk to Google Sheets (Easiest Way in 2023!)

Lido Blog page containing tutorials

As an example, we added a column and filled it with contact information:

Sample contact list template in google sheets filled with information‍

Neat, right? So start using our contact list template now!

Also check out our articles on:

How to create a google sheets address book template
How to send email in google sheets

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->