Importing & exporting
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.