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:
Access our Contact List Template by clicking the link below:
https://docs.google.com/spreadsheets/d/16XcIgNaDhrvxdm-KrmBigmW-5Hqo_Ea5IHeTXfgsCxw/edit?usp=sharing
A new tab or window will be loaded after clicking the link, with the following message:
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:
The contact list is in the sheet under the tab ContactList:
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.
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!)
As an example, we added a column and filled it with contact 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
