Help Center

Search Help Center
Press to search/

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 

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 (now called X)

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

  • Options: username 

27. YouTube

  • Options: username 

28. Snapchat

  • Options: username 

29. Comment

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

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

31. Media type

  • 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

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

33. Salutation

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

Contact us

Live chat

Hands down the fastest way to get support!

Email support

Asynchronous communication at its finest.

Phone call

Available 9:00–17:00 CET, Monday to Friday.

Product demo

Get a personal tour of Prezly when it suits you.

Made with