Blog

How to prepare a CSV of contacts for WhatsApp outreach

Most problems with a bulk send start in the spreadsheet. A clean file takes ten minutes and saves you from messages that never arrive. Here is how to prepare one that imports first time.

The only column you must have is the phone number

Call the column Phone. Everything else is optional, but two more columns make your messages better: Name, so you can greet people properly, and Country, which helps send at a sensible local time. SalesInTouch works out the country from the number when the column is missing.

Write numbers in international format

Include the country code and leave out the leading zero. A number written as 050 123 4567 in the UAE becomes 971 50 123 4567. Spaces, plus signs and dashes are fine, because they are removed on import, but the country code must be there. Numbers shorter than ten digits are skipped.

Keep one person per row

Duplicates cause double messages. Sort by the Phone column and delete repeats. If the same person appears with different spellings of their name, keep the row you trust.

Add columns you will use in the message

Any extra column becomes a field you can insert. A City or Interest column lets you write "I saw you were interested in apartments in {{City}}" and have each person see their own city. Keep the headings short and without special characters.

Save as CSV

In Excel or Google Sheets, choose Save as or Download and pick CSV (comma separated). Open the result in a text editor if you want to check it: each row should be one line with commas between the values.

Check a few numbers by hand

Before you import thousands, open five numbers in WhatsApp and make sure they are real people on WhatsApp. A single bad column, such as a landline in the wrong place, is easy to spot in a small sample.

Only include people you can contact

The best file is a short one. Remove anyone who asked not to be contacted, and anyone you cannot explain a reason for messaging. Our guide to avoiding blocks explains why.

Ready to try it? The video guide to importing a CSV shows each step.