Import WhatsApp leads from a CSV (Excel)

Import contacts from an Excel or Google Sheets CSV into your Kamay pipeline: map columns, avoid duplicates and check the log row by row.

Importing leads moves a contact list you keep in a spreadsheet into Kamay. You upload a CSV and each row becomes a lead in your pipeline, with its customer record.

Import lives in the Import & Export panel. You open it from Dashboard › Funnel, with the Export button at the top right, and the Import tab.

1. Import leads from a CSV

Before you start, keep WhatsApp Web open: Kamay checks each number against your WhatsApp account. The file must be a CSV (.csv), with one row per contact and a header row on top. Commas or semicolons both work, so the CSV that Excel saves in Spanish-language settings is fine.

  1. In Dashboard › Funnel, click Export and open the Import tab.
  2. Click the box or drag the file in. Kamay tells you how many rows it found, for example “3 rows in customers.csv”.
  3. Under Target pipeline and stage, choose the Pipeline and the Stage where all the leads will land. By default you get your main pipeline and its first open stage.
  4. Under Map columns, choose for each Field the CSV column that holds it. Kamay recognizes common headers on its own (“name”, “phone”, “company”, “email”…). Check that they’re right.
  5. Click Start import.

The fields are Name, Last name, Phone, Email, Company, Job title, Title, Value, Priority, Close Date and Source. Only Name and Phone are required: without them the button stays disabled.

How each value should look

  • Phone: with the country code and no +, for example 51987654321. Kamay keeps the digits and doesn’t add any code. Without it, WhatsApp can’t find the number.
  • Priority: type HOT, WARM or COLD. Any other text, or an empty cell, comes in as HOT (Hot).
  • Value: a number, like 1960. The currency is the one you chose in Kamay (USD if you haven’t chosen one).
  • Close Date: in the format 2026-12-15. If Kamay doesn’t understand it, it leaves the date empty without telling you.
  • Title: if missing, the lead is named “Lead - Carla Mendoza”.
  • Source: if missing, “Import” is saved.

2. What happens row by row

Kamay works in groups of 5, with a one-second pause, and reports in the Import log. For each row it does this:

  1. Checks that the number is on WhatsApp. If not, the row fails: “Pedro Salas: not on WhatsApp”.
  2. If that chat already has a lead in the pipeline you chose, the row is skipped so it isn’t duplicated: “Juan Pérez: already has a lead in this pipeline, skipped”. If the lead is in a different pipeline, it does create a new one.
  3. Creates or updates the client record for that chat with what the CSV brings. An empty cell doesn’t erase what the record already had.
  4. Creates the lead in the stage you chose.

A row without a phone is skipped (“Row 4: no phone, skipped”). At the top you see the progress and the Imported and Failed counts. Stop cuts it off midway: whatever was already imported stays. When it ends, click Done.

Plan limit: every imported lead counts toward your plan’s lead limit. If you reach it, the import stops with “You reached your plan’s lead limit.” If your plan has a limit, the tab tells you beforehand how many more leads fit. Afterward you can see them in your sales funnel and open any of them in its lead record.

3. Exporting your leads: not available yet

The panel already shows the Export tab, but exporting isn’t switched on yet: if you click Export you’ll see “Could not start export”. We’re finishing it and will update this guide when it works. If you need a copy of your leads before then, email us at hello@kamaychat.com.

4. Privacy

  • The CSV you import is read in your browser and isn’t uploaded as a file. Only the data from each imported row is saved to your account.
  • Importing doesn’t message anyone: it only checks whether the number is on WhatsApp.

With your leads in, continue with how to use your sales funnel.

Add to Chrome