Import contacts from a CSV
Bring in your list, map the columns and handle errors.
Go to Contacts, select Import, upload a CSV with one contact per row, map the columns, and choose what to do with duplicates. Numbers must include a country code, and failed rows come back as a downloadable file you can fix and retry.
Step 1: Prepare the file
- One contact per row; the first row is the header.
- Phone numbers need a country code:
+919876543210or919876543210. Numbers without one cannot be imported. - Optional columns: name, email, tags, consent status, and any custom fields you have created.
- Saving from Excel or Google Sheets? Use File, then Download as CSV. Plain commas, no formulas.
Step 2: Run the import
- 1Go to Contacts and select Import.
- 2Download the sample CSV if you want a known-good starting point.
- 3Upload your file, then map each column to a Transket field. Unmapped columns are ignored.
- 4Choose what happens to numbers that already exist: skip them or update their fields.
- 5Review the summary and select Import.
Step 3: Check the result
You get a result summary: imported, updated, skipped, failed. Failed rows can be downloaded as a CSV with a reason per row (bad number format, duplicate in file). Fix those rows and re-import just that file.
Common questions
My numbers lost their leading + or zeros in Excel.
Format the phone column as text before pasting numbers, or wrap values in quotes. Then re-export the CSV and re-import.
What happens to duplicates inside the same file?
The first row wins and later duplicates are reported as failed rows, so you can decide what to keep.
Can I import tags for each contact?
Yes. Put them in one column separated by commas (like vip, wholesale) and map it to Tags. New tag names are created automatically.
Still stuck?
Raise a ticket or chat on WhatsApp. We typically reply within 24 hours.