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@email.com
  • You can upload up to nine email addresses for each contact.

8. Email (second) 

9. Email (third) 

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

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.¬†