Skip to main content

​
When to use CSV import

Use CSV import when you already have a spreadsheet of contacts — exported from another tool, a sales list, an event sign-up sheet — and want to bring them all into ChatSyncs at once, instead of adding them one at a time or waiting for each person to message the bot first. It’s the fastest way to seed Subscriber Manager with an existing contact list.
Already have subscribers in ChatSyncs and want to go the other way? Options → Download(all) as CSV on the Subscriber Manager list exports the current list as a CSV file — handy for editing offline before re-importing, or for a backup.
Only have a handful of contacts, or contacts already living in a Google Sheet or your Google account? See Import Subscribers Manually or Import from Google Sheets instead.

​
Import a CSV file

Import Subscribers modal with Upload File, Import from Google Sheet, and Import from Google Contacts options

The Import Subscribers modal — Select Label, Select Bot, Upload File (CSV), or import from a Google Sheet or Google Contacts.

1

Open Options → Import Subscribers

From the Subscriber Manager list, open Options, then Import Subscribers.
2

Choose Upload File (CSV)

Select the CSV upload option in the modal shown above.
3

Prepare your file to match the required format

At minimum, your CSV needs a phone number column and a name column — see the table below. A Sample CSV link in the modal shows the exact expected format.
4

Upload the file

Select your prepared CSV file to upload it.
5

Map each column

Match each column in your file to a ChatSyncs field — see “Map the columns” below.
6

Confirm the import

Click Confirm — the imported contacts appear in the Subscriber Manager list.

​
The CSV format

A CSV needs at minimum a phone number and name column, e.g.:
Country code is mandatory, and the phone number must be plain digits — e.g. 919876543210, not +91 9876543210 or a locally-formatted number. A number missing its country code, or formatted with symbols and spaces, will fail to match the right subscriber.
Format the phone number column as plain numbers or text before exporting to CSV — Excel often displays long phone numbers in scientific notation (e.g. 8.8E+12 instead of 8801710000000), and a CSV exported in that state will import garbled or truncated numbers.
Excel spreadsheet with phone_number column showing scientific notation like 8.8E+12

A phone_number column displayed in scientific notation (8.8E+12) before formatting.

Fix it in Excel with right-click → Format Cells on the column, set it to Number with 0 decimal places (or Text), before saving as CSV:
Excel right-click context menu with Format Cells highlighted on the phone_number column

Right-clicking the phone_number column and selecting Format Cells to fix the display.

Excel spreadsheet with phone_number column showing correctly formatted full phone numbers

The phone_number column after formatting — full numbers like 8801710000000 instead of scientific notation.

​
Map the columns

Sample Data of Uploaded CSV/Google-Sheet modal mapping File Header columns to Data Fields, with a Map Data button

The Map Data step — mapping the file's phone_number and name columns to Phone Number and Subscriber Name.

After uploading, map each column from your file to a ChatSyncs field:
  • Map phone_number → Phone Number.
  • Map name → Subscriber Name.
  • Verify every mapping carefully before confirming — a wrong mapping imports the wrong data into the wrong field for every row.
Any extra column beyond phone number and name is treated as a custom field automatically. If the subscriber already exists (matched by phone number), that custom field is updated on the existing record; if not, a new subscriber is created with it already filled in.
Expected result: Every row in your file becomes a subscriber in Subscriber Manager, with extra columns populated as custom fields — ready to label, message, or enroll in a sequence immediately.

​
Frequently asked

A phone_number column and a name column. Any other column is imported automatically as a custom field.
Excel often displays long phone numbers in scientific notation (8.8E+12). Format the phone number column as Number (0 decimal places) or Text — right-click → Format Cells — before saving the file as CSV, or the import will bring in the garbled value.
The existing subscriber record is matched by phone number and updated — any new custom field columns are added or overwritten, rather than creating a duplicate.
Yes — the country code is mandatory and the number should be plain digits with no + or spaces, e.g. 919876543210.
Yes — the Import Subscribers modal has a Sample CSV link showing the exact expected column layout.