Supported contact fields in your Excel or CSV file

A full list of fields or labels recognized by our Contact Importer

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.

1. Type

• 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. 

2. Organization 

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

3. First name 

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

4. Last name

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

5. Full name

• 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. 

6. Function

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

7. Email 

• Options: [email protected]
• You can upload up to nine email addresses for each contact.

8. Email (second) 

• Options: [email protected]

9. Email (third) 

• Options: [email protected]

10. Gender

• Options: male or female

11. Language

• 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 ​ 

12. Telephone

• Options: phone number 

13. Mobile

• Options: phone number 

14. Street

• Options: Any string data 

15. Number

• Options: number 

16. Box

• Options: number 

17. Zip code

• Options: number 

18. City

• Options: Any string data 

19. Province/state

• Options: Any string data 

20. Country

• Options: Any string data 

21. Website

• Options: www.website.com 

22. Twitter

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

23. Facebook

• Options: username 

24. Instagram

• Options: username 

25. LinkedIn

• Options: username 

26. Google+

• Options: username 

27. Pinterest

• Options: username 

28. YouTube

• Options: username 

29. Snapchat

• Options: username 

30. Comment

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

31. Tags

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

32. Medium

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

33. Periodicity

• 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. 

34. Salutation

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