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:
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.
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!
How to Search Within the 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: