Using our Address Book template is a quick way to be able to add multiple people's contacts to your FOREVER® Address Book at once. You can find the template spreadsheet at the end of this article to download and edit!
Quick Tips
- Keep the first line unchanged - The very first row of the spreadsheet with headers (such as First Name, Last Name, etc.) should remain unchanged. This is how our system recognizes which column to find certain information for the addresses you want to add.
- Stay within 50 characters per cell - Try to shorten or abbreviate as much of names and address as possible. CLICK HERE for more information.
-
Fill in at least the First or Last Name - You have the option to fill in a First Name and Last Name for the contact you're entering the address for. In order for our system to create a contact's profile, at least one needs to be filled in.
This means you can have First Name only, Last Name only, or First and Last Name. If neither First nor Last Name are filled in then a contact will NOT be created. - There is NO duplicate detection - At this current time the Address Book area in your FOREVER account does not have a duplicate detection system. This means if you import your filled template more than once it will create multiple copies of the same address in your Address Book. We ask that you triple-check the addresses in your template before upload, then make necessary adjustments by adding or editing the existing addresses here. Alternatively, you can Reset your Address Book to completely delete all addresses at once, and re-upload the filled template.
Template Columns Explained
There are 9 different columns you can fill with information about the contacts you want to add to your account's online Address Book. Here is a list of the columns and their overall purpose.
- First Name = a single person's or multiple people's first names (ie. "Jane" or "Jane and Joe")
-
Last Name = the last name of the contact, it can be singular or hyphened (ie. "Smith" or "Johnson-Miller")
REMINDER: You must have at least 1 of the Name options above filled in for a contact to be created. - Household Name = a way to name the entire home the address is for (ie. "The Smith Family" or "Johnson-Miller Home")
- Address 1 = the first line of an address, usually the building number and street name (ie. "One PPG Place" or "123 Apple St")
- Address 2 = the second line of an address, further identifying information to distinguish someone's residence or mailbox in a multi-place complex (ie. "20th floor", "apt 2102", or "PO Box 90")
- City = specific city for the contact's address
- State/Province = this area should be an abbreviation of the state or province (ie. "PA" or "AB") instead of the fully spelled out name (ie. "Pennsylvania" or "Alberta")
- Zip/Postal Code = CLICK HERE for tips on how to keep your codes that have a zero at the start
- Country = we recommend having this area be an abbreviation of the country (ie. "USA" or "AUS") instead of the fully spelled out name (ie. "United States of America" or "Australia")
Importing an Address Book Template
Once you have your addresses filled out in the template (see download at end on article) you will want to make sure you save/export it as a CSV file. You can then log in to your FOREVER account, then either hover over the person icon or click your circle profile photo and go into your Address Book. Click the button to "Import CSV", then in the pop-up select "Upload Your CSV". It may take a few moments for all your contacts to import and have their addresses listed - please do NOT refresh your screen or navigate away from this page while it is processing.
After they are uploaded, you can add them to Groups or even edit them as needed!