Import Contacts using CSV
Want to import 100s or even 1000s of contacts at once? You can do that using our CSV import feature. In this article we’ll see how you can do that.
Follow the simple steps given below to bulk import your contacts:
Open the Contacts > Import Contacts page.
Now click here to open our sample import Google Sheets file.
After opening the link, you can either click on File > Make a copy to clone the sheet or click on File > Download > Comma-separated values (.csv) to export the sheet as CSV file.
Fill in this sheet with your contact data. Make sure that you do not change the column sequence or names in the sheet.
Important Note: In the WhatsApp number column in sheet, add phone numbers with country codes but WITHOUT the plus + sign. E.g. if the number is +91-98765-43210, you should add 919876543210.
You can also add custom attributes to your contacts by replacing the columns named custom_attribute_1, custom_attribute_2, custom_attribute_3 etc or adding new columns.
You can rename these columns to any other names and add as many such custom attribute columns as you want.
The column names must be in small letters and use underscore (_) instead of spaces. E.g image_url, billing_city and so on.
After your sheet is ready, export it as .csv file and select it in the Select CSV File field.
Now click on the Import button and that’ll start importing your contacts.
Note: File formats other than .csv (like .xls or .xlsx) are not supported.
You can also manually add your contacts or add them automatically from 3rd party websites and apps using our webhook feature.
Follow the simple steps given below to bulk import your contacts:
Open the Contacts > Import Contacts page.
Now click here to open our sample import Google Sheets file.
After opening the link, you can either click on File > Make a copy to clone the sheet or click on File > Download > Comma-separated values (.csv) to export the sheet as CSV file.
Fill in this sheet with your contact data. Make sure that you do not change the column sequence or names in the sheet.
Important Note: In the WhatsApp number column in sheet, add phone numbers with country codes but WITHOUT the plus + sign. E.g. if the number is +91-98765-43210, you should add 919876543210.
You can also add custom attributes to your contacts by replacing the columns named custom_attribute_1, custom_attribute_2, custom_attribute_3 etc or adding new columns.
You can rename these columns to any other names and add as many such custom attribute columns as you want.
The column names must be in small letters and use underscore (_) instead of spaces. E.g image_url, billing_city and so on.
After your sheet is ready, export it as .csv file and select it in the Select CSV File field.
Now click on the Import button and that’ll start importing your contacts.
Note: File formats other than .csv (like .xls or .xlsx) are not supported.
You can also manually add your contacts or add them automatically from 3rd party websites and apps using our webhook feature.
Updated on: 12/07/2023
Thank you!