Supported contact fields in your Excel or CSV file

Currently we support the below fields for a contact. These are also the fields you can add in your importing file, when importing contacts in Prezly.

• Options: person or organization
• This field is not required, but highly recommended. If you import organizations as a person, it will create lots of confusion and make your database messy. 

• Options: any string data (in a comma separated list)
• Where the person contact works. If a contact works at multiple organizations, use a comma separated list in one cell, e.g. The Daily Mail, Wired, Times 
• If this organization doesn't exist yet in your database, it will be automatically created

• Options: any string data 
• Leave this field empty if the contact is an organization 

• Options: any string data 
• Leave this field empty if the contact is an organization 

• Options: any string data 
• Optionally, if you don't have a first and last name column you can import contacts with a full name in one column. Prezly will then automatically try to distinguish between first and last name when importing. However, it is recommended to use separate first and last name columns if possible. 

• Options: any string data 
• It means the function or the title on the contact within his/her organization 

• Options: email@email.com
• You can upload up to nine email addresses for each contact.

• Options: email@email.com

• Options: email@email.com

• Options: phone number 

• Options: phone number 

• Options:
  • Street: Any string data 
  • Number, box: number

• Options: number 

• Options: Any string data 

• Options: Any string data 

• Options: Any string data 

• Options: any string data
• If you have multiple tags for a contact, add them in a comma separated list, in one cell, e.g. lifestyle, beauty, design

• Options: any sting data
• Include additional notes that you might have on the contact 

• Options: two-letter short code (in a comma separated list)
• Fill in the languages that the contact speaks 
• View a full list of country codes here
• If a contact speaks multiple languages, use a comma separated list in one cell, e.g. en, nl, de ​ 

• Options: analyst, blog, expert, influencer, magazine, news website, newsletter, newspaper, photo, podcast, print, radio, social, tv, vlog, web or wire
• Choose the media type of your contacts. If a contact is active in more than one media type, add them in a comma separated list, in one cell, e.g. print, radio, tv

• Options: daily, bi-weekly, weekly, bi-monthly, monthly, quarterly, bi-annually or annually
• You can define your contacts medium periodicity, for example weekly magazine, daily podcast, monthly report etc... You can only pick one periodicity per contact, so no comma separated. 

• Options: male or female

• Options: website.com
• Only for organization contacts. Should be a link to the main company website. Helps Prezly automatically fill in the contact with additional data. Read more here

• Options: www.website.com 
• If a contact has multiple websites, add the websites in a comma separated list

• Options: Twitter username 
• It's not necessary to write the @ sign before the username 

• Options: username 

• Options: username 

• Options: username 

• Options: username 

• Options: username 

• Options: username 

• Options: username 

• Options: username 

• Options: username 

• You can also define a contact salutation such as Mr or Mrs.