Skip to content

Bulk SMS from a CSV file

Updated:

On this page

A CSV file is a plain table saved as text. Each row is one recipient and the columns hold their details, such as a name and a number. You can save such a file from Excel or Google Sheets. With it, one message with fill-in fields becomes a personalised SMS for many people.

Prepare the file

  1. The first row must hold column names, for example name, phone, order_id, total.
  2. In the next rows enter one recipient per row.
  3. Save the file as CSV. The file can be up to 1 MB.

A template is in the dashboard: click “Download a sample CSV”. A sample row looks like Emma Clark,+14155550101,ORD-1042,49.99.

Send step by step

  1. In the menu click “Messaging”, then the “Bulk Send” tab.
  2. In the “Upload your CSV” step drop the file or click the box “Drop a CSV here, or tap to choose one”. The dashboard shows the number of rows and columns and the first 5 rows.
  3. In the step “Choose the phone column and device” check the “Phone number column” field. The dashboard guesses it from the headers (for example phone, mobile). Change it if needed.
  4. In the “Send from” field choose a phone. With two SIM cards you can pick a card in “SIM (optional)”.
  5. Read the summary: how many people “will receive a message” and how many rows are “with no number”, “invalid” or a “duplicate”.
  6. In the “Write your message” step click a column name to insert it into the text. The field looks like this: {{ name }}. Type your text in the “Message template” field.
  7. Check the preview. Use the arrows to switch between recipients. The character counter counts the finished message, not the template.
  8. In the “Review and send” step choose the speed in the “Anti-ban shield” section (see Anti-ban shield: pace and pauses).
  9. Click “Send messages: 120” (the number depends on your file). Nothing goes out before this click.

After sending you see “Messages queued” and a “View message history” button. Start the next batch with “Send another batch”.

What the dashboard skips

The dashboard does not send to rows with an empty number, an invalid number, or a number that already appeared higher in the file. The “Rows skipped” list shows the row number as in your spreadsheet.

If the template uses a field that is not in the file, the dashboard warns “Unknown column reference”. Such a field is sent as empty text.

Limits

  • File size: up to 1 MB.
  • Number of rows: depends on your plan. When it is limited, the upload box shows it next to the size. A file that is too big stops with “That file is over your plan limit”.
  • The monthly SMS limit is described in Plans and sending limits.
  • For a large send the dashboard shows “This is a large send” with the expected duration. Keep the phone on a charger with good signal.

A wrong column separator in the file shows up as “Some rows did not parse cleanly”. Then check that the file uses commas and quotation marks as the CSV format expects.

Questions and answers

Which file can I upload?
A file with the .csv extension, up to 1 MB, with a header row and one row per recipient. The row limit depends on your plan.
What happens to empty or repeated numbers?
The dashboard skips them. Below the list you see “Rows skipped” with the row number and the reason.

Didn’t find the answer? Contact us

Send your first SMS today

Create a free account, connect your phone and see how customers respond to messages from your number.