Setting Up Your File
When importing a CSV file of contacts, the format used will need to match the headers and format as described below, or the import results will be inconsistent.
Prior to importing, you'll need to review and potentially edit your csv in a spreadsheet program like Google Sheets or Excel. This will allow you to modify the header names so they match the exact name of the field's listed below and confirm the data is broken up as specified. Variations of header titles are also allowed and are indicated by alternate spelling.
To make this process easier, you may also use this google doc to verify the headers are correct. As many users have access to this, the file is a "view only" file. Please save a copy for yourself and then add your data as needed. (Once edited, select "File" > "Download As" and select CSV). This can now be imported into 17hats.
Please note the phone numbers must be entered in the 888-888-888 format.
Acceptable data fields when importing CSV files:
'first name', firstname, first, 'given name', given
'last name', lastname, last, 'family name'
company, 'company name', 'business name', business
email, e-mail, 'e-mail address'
"business phone 2"
"company main phone"
"home phone 2"
addresses (all field names can be prefixed with "business", "home ", "other")
'street 2', 'address 2'
zip, 'postal code'
'web page', website, url
tags (# comma or semi-colon separated)
**Note: To add more than 1 tag to a contact, simply separate these with a comma under the "tags" header.
Importing Into 17hats
Once your CSV file is updated to match the headers above, you can upload them into 17hats.
First, login to 17hats and go to your "Contacts" tab. Next, click the gear icon on the top right of the page and select the option to import as shown by the blue arrow.
You'll then be taken to the Contact Import page where you can select your file. Be sure to select the "CSV File" option as shown with the blue box.
Once a file has been selected, you'll be prompted to select the contacts to be imported, apply any tags, or update the contact type. You can update them in bulk using the check boxes, or update each manually as needed.
IMPORTANT: You must select contacts to import using the checkboxes provided. If none are checked, the information will not be uploaded.
When the file has been uploaded, you'll get a prompt at the top of the screen that your file was uploaded successfully.
As always, feel free to reach out via Live Chat if you still have any remaining questions and we'll be happy to help out!
Keywords: Import contacts blank, Import contacts not working, Cannot import contacts, Cannot import contacts list, Importing a CSV file of Contacts