In this article we will show how to copy our free google sheets address book template and enter data in just a few simple steps. Simply follow the steps below:
Access our Address Book Template by clicking the link below:
https://docs.google.com/spreadsheets/d/1c9EWYbDJB3hRABIyyJ6OwKEaTKxTaV2sAOydYaENwlA/copy
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 address list is in the sheet under the tab AddressList:
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 creating formulas that you need, or fill it up with data from different eCommerce and marketing platforms!
We now have a Google Sheets address book!
To search within the address book, click the SearchList tab, then start typing the keywords in the appropriate category. For example, if we want to list all entries that are in Australia, we type the keyword Australia in the Country category. The list will be updated real-time.
If you enjoyed this article, check out our articles on:
How to create a google sheets email list template
