How to Bulk Import Contacts using CSV / Excel File?

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:

1. Create a CSV or XLS sheet with your contacts data including first name, last name, WhatsApp number and any additional contact attributes that you'd like to add to the contact.

• IMPORTANT: WhatsApp phone numbers must be added with country codes but WITHOUT the plus + sign. E.g. if the number is +91-98765-43210, you should add 919876543210.
• Make sure to format the phone number column as Text / Plain Text. See instructions on how to do that in Google Sheets and Microsoft Excel.

2. Open the Contacts > Import / Export page. You'll see the following screen:
   
3. Select Contact Lists to which you want to import these contacts.
4. Browse and select your CSV / Excel file.
5. Select the default Contact status and Contact tags that you want to set for the imported contacts.
6. Click on Continue to move to next step.
7. On the next step, you'll see Sheet Columns and Sample Data from the sheet you uploaded. Map these columns to the respective Contact fields.

• If you have additional columns that you don't want to import, you can leave them as it is and they'll not be imported.
  

8. After you're done mapping your sheet columns with the Contact fields, click Continue and that'll start the import process!

That's it. It's that simple to import your contacts in bulk.

You can also manually add your contacts or add them automatically from 3rd party websites and apps using our API feature.

Updated on: 28/08/2024