Uploading the correctly formatted .csv file can be tricky! Follow these steps to ensure that your .csv file is correctly formatted. You will see your contacts populated with information once the .csv file has been correctly imported.
Style your .CSV file correctly before uploading
Your CSV file will need to look similar to this format below or else the site may prevent you from uploading your contact list:
first_name | last_name | |
Dylan | Bell | |
Annie | Holleman | |
Brianna | Lanoue |
Parameters
all lower case
underscore ('_') separated, not space (' ') separated
comma separated between values (i.e. first_name,last_name)
If a specific value does not need to be imported (i.e. phone number), you can separate it as such
first_name,last_name,email,phone_number,company
Importing with a photo URL
You can also include a photo_url column in your CSV to import external headshots alongside your contacts. Simply add a photo_url column with a direct link to each contact's photo, and the headshot will be uploaded automatically during import.
Example: first_name,last_name,email,photo_url
Still not working?
Export a blank .CSV from the Studio platform to get the proper formatting:
Go to the Contacts page
Click Export in the upper right corner to export a blank .CSV
Use this .CSV to collate your data
Import this .CSV to Contacts > Lists following the instructions.