Skip to main content

Using CSV Upload

CSV Upload Demo

Step-by-Step Example

You can add any column you want to your CSV, and then pipe that field into your messages.

Note: Your CSV/spreadsheet must have at least one phone number column.

Here's an example that may be useful to teachers.

A CSV like this:

Student NameStudent NumberParent NumberGradeSubject
Steffanie(111) 222-3333(111) 222-444495Algebra
Jack(111) 222-3334(111) 222-444585US History

(download this example CSV)

And a Message like this:

Hi {Student Name}, we just finished grading the exams and you got {Grade}% on your {Subject} test.

Would generate these 2 group texts:

  • (111) 222-3333, (111) 222-4444

    Hi Steffanie, we just finished grading the exams and you got 95% on your Algebra test.

  • (111) 222-3334, (111) 222-4445

    Hi Jack, we just finished grading the exams and you got 85% on your US History test.

Alternatively, if you've disabled sending group texts in the Settings for Sending panel, it would generate these 4 individual texts:

  • (111) 222-3333

    Hi Steffanie, we just finished grading the exams and you got 95% on your Algebra test.

  • (111) 222-4444

    Hi Steffanie, we just finished grading the exams and you got 95% on your Algebra test.

  • (111) 222-3334

    Hi Jack, we just finished grading the exams and you got 85% on your US History test.

  • (111) 222-4445

    Hi Jack, we just finished grading the exams and you got 85% on your US History test.

So you could use CSV Upload to easily send custom individual messages to both students and parents about a recent test.

Special Columns

Some column names are special in Bulk Texter Pro, and can be used to automate your texts even more.

Phone Numbers

Your CSV/spreadsheet must have at least one phone number column. If you want to send group texts, just add multiple phone number columns to your CSV. Each phone number in a row will be added to the recipients list for that text.

Phone number column headers can have be formatted like any of these:

  • Number
  • Number 2
  • Cell #3
  • Mobile
  • Phone #5
  • etc.

ScheduledSendTime

You may add a column titled ScheduledSendTime, which allows you to send each individual message in your spreadsheet at a specified time.

The ScheduledSendTime values in each row must be in one of these formats:

  • 9/16/2023 4:00pm
  • 9/16/2023 16:00:00
  • 2023-09-16 4:00pm
  • 2023-09-16 16:00:00

If the ScheduledSendTime column is present, but a row has an invalid or missing value for that column, the text will be sent as scheduled with the overall text batch, rather than having a custom individual time.

You can download an example CSV with this column here: example-scheduled-send-time.csv.

PhotoFileName

You may add a column titled PhotoFileName, which allows you to send a distinct photo with each text. Learn more in our guide for sending photos.

SendMessage

You may optionally add a column titled SendMessage, for which messages will only be sent if the cell's value is True.

To avoid sending texts for some rows in your spreadsheet, add a value of False to the SendMessage column in those rows, or leave the value empty.

You can download an example CSV with this column here: example-send-message.csv.

Additional tips for CSV Upload

  • If you are uploading an .xlsx file, the data that you want to import into messages must be in the first spreadsheet in the workbook.
  • Your columns can cross-reference each other. For example, if you have a column Subject and a column Comment, Comment could contain something like You did great on your {Subject} test!. Then, in Bulk Texter Pro, you could put something like Hi {name}, {comment}, and it would insert all the needed fields from your spreadsheet.
  • After uploading, you can experiment with inserting cell values into your message.
  • You can also drag your CSV/spreadsheet onto the CSV page to upload it, instead of using the CSV button.
  • If the values from your CSV aren't looking right in Bulk Texter Pro, try toggling on or off the Use raw / unprocessed CSV values option in the Settings under the account menu at the top right of Bulk Texter Pro.