Most customer lists in Bangladesh already live in a spreadsheet: an Excel export from your shop software, a Google Sheet from the sales team, or a CSV from your CRM. You do not need to retype a single number. On GotiSMS you upload the file, the numbers are read and checked for you, and you send in a few minutes.

This guide shows how to prepare the file so every number is read correctly, how to upload it, and how to avoid the mistakes that cost money.

What file formats can you upload?

GotiSMS reads three formats:

  • .xlsx — Excel (2007 and later), Google Sheets download, LibreOffice
  • .xls — older Excel files
  • .csv — comma-separated text, which every tool can export

You can download a ready-made sample in either format from the upload box, under Sample: CSV · Excel.

How should the spreadsheet be laid out?

Keep it simple: mobile numbers in the first column. That is the only column the upload reads for numbers. Anything in the other columns, such as names or notes, is ignored, so you can leave it there.

Mobile NumberName
01712345678Nusrat Jahan
1812345678Rafiqul Islam
8801912345678Ayesha Siddika

A header row such as "Mobile Number", "Phone" or "Contact" is detected and skipped automatically.

Which number formats are accepted?

All the shapes people actually have in their sheets:

  • 01712345678 — the normal 11-digit local number
  • 1712345678 — what Excel leaves when it drops the leading zero
  • 8801712345678 or +8801712345678 — with the country code
  • Spaces, dashes and brackets, such as 017-1234 5678, are cleaned up
  • Bangla digits, such as ০১৭১২৩৪৫৬৭৮, are understood too

Every number is converted to one standard form before sending, so the same customer written two different ways is still sent one message, not two.

How do you stop Excel from removing the leading zero?

Excel treats 01712345678 as a number and quietly turns it into 1712345678. GotiSMS still reads that correctly, but other tools may not, so it is good practice to keep the zero:

  1. Select the first column.
  2. Right-click, choose Format Cells, then Text.
  3. Paste or type your numbers again.

The GotiSMS sample Excel file already has the number column set to Text.

How do you upload the file and send?

From the dashboard (quick sends):

  1. Open Dashboard → Send a message → Upload Excel / CSV.
  2. Drop the file onto the box, or click Choose file.
  3. You will see how many numbers were found, how many duplicates were skipped, and how many rows could not be read.
  4. Choose your sender ID and message type, write the message, and press Send SMS.

From the Send SMS page (campaigns):

  1. Open Send SMS, give the campaign a title, and choose the sender.
  2. Under Recipients, choose Upload a file.
  3. Optionally tick Remove duplicate numbers and Only local numbers.
  4. Compose the message, check the Sending summary on the right, then send now or Schedule SMS for later.

The Send SMS page also lets you add a few extra numbers by hand on top of the file, or use a saved contact group instead.

How many numbers can one send include?

Up to 1,000 numbers per send. For a larger list, split the file into parts of 1,000 rows and send each part.

What happens to numbers that cannot be read?

Rows that are not valid Bangladeshi mobile numbers, such as landlines, numbers with missing digits or text in the number column, are listed with their row number and left out. You are never charged for them. Fix them in the sheet and upload again if they matter.

How much will the campaign cost?

Before you send, the summary shows the number of recipients, how many SMS parts the message uses and the estimated cost. You are charged per SMS part:

Cost = Recipients × Parts per message × Rate per SMS

A short English message is one part up to 160 characters; Bangla is one part up to 70 characters. See Bangla SMS character limits and the pricing page.

Checklist before you press Send

  • Numbers are in the first column.
  • The count of numbers found matches what you expected.
  • Duplicates and unreadable rows look reasonable.
  • The right sender ID is selected (see masking vs non-masking).
  • The message fits in as few parts as possible.
  • Your wallet has enough balance for the estimate.

Frequently asked questions

Do I need a header row in my file?

No. If the first row looks like a header, such as "Mobile Number" or "Phone", it is skipped. If not, the first row is read as a number.

Can I send personalised messages with names from the sheet?

The upload reads numbers only. For a message that is the same for everyone, upload the file. For personalised messages per person, use the SMS API from your own system.

Is my file stored on GotiSMS?

No. The file is read to pick out the numbers for that send and is not saved to your contacts. To keep a list for reuse, import it under Contacts & Groups instead.

Why does it say fewer numbers than rows in my sheet?

Duplicates are counted once, empty rows are skipped, and rows that are not valid mobile numbers are listed separately. The upload box shows each of these counts.