Help Center

11. What format must the file be in when importing contacts for my campaign?

To add contacts to a campaign, you must upload a .xlsx, .txt, or .csv file containing the recipients' information. Add a column for every variable you want to populate in your campaign's message. A column containing the recipients' MSISDN (phone number) is required. All other columns are optional and depend on the information you need in the campaign you plan to send.

An example is shown below. You can also read more in the Broadcast Messenger User Guide.

Note:

  • Phone numbers must be added in international format, e.g., 12025248725 (USA) or 447481340516 (UK).

  • Date format: YYYY-MM-DD

  • Contacts must have opted in (i.e., provided consent) for you to send campaign messages to them.

  • SMS does not currently support variables.

Other resources

Contact support

Contact support

Contact our support team and one of our agents will be in touch with you to answer any questions you have.

Contact support

Developer docs

Developer docs

Access the latest technical information regarding Clickatell’s channels, products and APIs.

Access developer docs