How to import from CSV on Mac
Select the delimiters that you use in a CSV file and then press the button to select your CSV file.
If you don't know which delimiters are used in your file, you can change them after file selection. If you use headings in a CSV file, click the checkbox to exclude those headers. Columns in a CSV file can be in any order.
You can download a file that will be used as an example in this tutorial.
Click a column heading to map data type there. It's not necessary to map all columns.
Important! Phone number, Email address, Facebook, Telegram, or Skype username - one of these columns is required for each imported contact. If a row does not contain one of these required fields or fields does not pass validation, then this row from a CSV file will be ignored. Other columns are optional.
If a field in a column has more length than is allowed, all extra characters will be truncated.
When you finish mapping column headings, press the "Save" button.
Also, before save you can select in which group you want to add these imported contacts.
After successfully saving, you will see a message with a result.
Users who have not activated full access to the app may have certain restrictions on the count of imported contacts.
After selecting a file, all data is displayed only in one column.
This issue occurs due to incorrectly selected delimiters. In the column you can see that semicolon ";" is used as a separator, but in the parsing settings you selected "Coma (,)". Change the Field delimiter to the correct one and then columns will display the correctly.
Unable to identify data in some rows from CSV file
This problem occurs when the field with the CSV file contains incorrect data. For example:
- the field contains a phone number, but it is in an incorrect format or the country code is missing
- contains invalid characters for specified data type
- field is empty
You can click the "Check unparsed data" button and in the opened window, see which lines from the CSV file could not be parsed.
Phone number
Plus prefix '+' - optional. Spaces, dashes '-', brackets '(123)' - also optional.
Highly recommend use country code in phone numbers, if not, a country code will be inserted based on locale and the region of your device. Max length: 20 characters.
Phone number format examples: 13231234567 or +13231111111 or (323) 1111111, +1 323 123 4567, 1 (323)-123-4567.
If the string does not pass validation as a phone number, then this value will be ignored.
Email address
Max length: 100 characters.
If the string does not pass validation as an email, then this value will be ignored.
Facebook username
Supports Facebook Username or link to a Facebook user profile, for example:
https://facebook.com/{username}
FB Username will be automatically extracted from the link.
Links without Username not supported, for example:
https://www.facebook.com/profile.php?id=100000000000001
Min Username length: 5 characters
Max Username length: 50 characters.
If the string does not pass validation as a Facebook Username, then this value will be ignored.
Telegram username
Max length: 31 characters including @ prefix.
If the string does not pass validation as a Telegram Username, then this value will be ignored.
Skype username
Max length: 32 characters. Min length: 6 characters.
If the string does not pass validation as a Skype Username, then this value will be ignored.
First name, Last name, Middle name, Nickname, Company, Relationship, Custom 1 - 5
Max length: 100 characters
Title
Supported values: doctor, miss, ms, mrs, mr, madam, lady, prof, sir, junior, reverend, righthonorable, senior, saint, master, lord, principal. All other values will be ignored.
Note
Max length: 1000 characters
Birthday D-M-Y or Birthday Y-M-D
Birthday D-M-Y - birthday format DAY-MONTH-YEAR, example: 01/01/1999;
Birthday Y-M-D - birthday format YEAR-MONTH-DAY, example: 1999/01/01;
Slash '/' separator - required.
Your trimming mode mustn't intersect with the row delimiters. For example, you cannot use the row separator 'Line Feed' and the trimming 'Whitespace and Newlines', because your row separator will be removed or overridden. In this case, you need to use a different row separator or change trimming mode.
Text will be trimmed only at the start and end of each field. Spaces in the middle will be saved. For example: ' Jerome Jr. ' will be trimmed to 'Jerome Jr.';
If you don't know which delimiters are used in your file, you can change them after file selection. If you use headings in a CSV file, click the checkbox to exclude those headers. Columns in a CSV file can be in any order.
You can download a file that will be used as an example in this tutorial.
Click a column heading to map data type there. It's not necessary to map all columns.
Important! Phone number, Email address, Facebook, Telegram, or Skype username - one of these columns is required for each imported contact. If a row does not contain one of these required fields or fields does not pass validation, then this row from a CSV file will be ignored. Other columns are optional.
If a field in a column has more length than is allowed, all extra characters will be truncated.
When you finish mapping column headings, press the "Save" button.
Also, before save you can select in which group you want to add these imported contacts.
After successfully saving, you will see a message with a result.
Users who have not activated full access to the app may have certain restrictions on the count of imported contacts.
Common issues
After selecting a file, all data is displayed only in one column.
This issue occurs due to incorrectly selected delimiters. In the column you can see that semicolon ";" is used as a separator, but in the parsing settings you selected "Coma (,)". Change the Field delimiter to the correct one and then columns will display the correctly.
Unable to identify data in some rows from CSV file
This problem occurs when the field with the CSV file contains incorrect data. For example:
- the field contains a phone number, but it is in an incorrect format or the country code is missing
- contains invalid characters for specified data type
- field is empty
You can click the "Check unparsed data" button and in the opened window, see which lines from the CSV file could not be parsed.
Validation conditions for mapped columns:
Phone number
Plus prefix '+' - optional. Spaces, dashes '-', brackets '(123)' - also optional.
Highly recommend use country code in phone numbers, if not, a country code will be inserted based on locale and the region of your device. Max length: 20 characters.
Phone number format examples: 13231234567 or +13231111111 or (323) 1111111, +1 323 123 4567, 1 (323)-123-4567.
If the string does not pass validation as a phone number, then this value will be ignored.
Email address
Max length: 100 characters.
If the string does not pass validation as an email, then this value will be ignored.
Facebook username
Supports Facebook Username or link to a Facebook user profile, for example:
https://facebook.com/{username}
FB Username will be automatically extracted from the link.
Links without Username not supported, for example:
https://www.facebook.com/profile.php?id=100000000000001
Min Username length: 5 characters
Max Username length: 50 characters.
If the string does not pass validation as a Facebook Username, then this value will be ignored.
Telegram username
Max length: 31 characters including @ prefix.
If the string does not pass validation as a Telegram Username, then this value will be ignored.
Skype username
Max length: 32 characters. Min length: 6 characters.
If the string does not pass validation as a Skype Username, then this value will be ignored.
First name, Last name, Middle name, Nickname, Company, Relationship, Custom 1 - 5
Max length: 100 characters
Title
Supported values: doctor, miss, ms, mrs, mr, madam, lady, prof, sir, junior, reverend, righthonorable, senior, saint, master, lord, principal. All other values will be ignored.
Note
Max length: 1000 characters
Birthday D-M-Y or Birthday Y-M-D
Birthday D-M-Y - birthday format DAY-MONTH-YEAR, example: 01/01/1999;
Birthday Y-M-D - birthday format YEAR-MONTH-DAY, example: 1999/01/01;
Slash '/' separator - required.
Fields trimming:
Your trimming mode mustn't intersect with the row delimiters. For example, you cannot use the row separator 'Line Feed' and the trimming 'Whitespace and Newlines', because your row separator will be removed or overridden. In this case, you need to use a different row separator or change trimming mode.
Text will be trimmed only at the start and end of each field. Spaces in the middle will be saved. For example: ' Jerome Jr. ' will be trimmed to 'Jerome Jr.';
Updated on: 25/06/2022
Thank you!