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:

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

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

  • To: (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:

  • To: (111) 222-3333

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

  • To: (111) 222-4444

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

  • To: (111) 222-3334

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

  • To: (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 be formatted like any of these:

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

Each phone number column name must be unique.

FLVS / VSA Spreadsheets​

For our Florida Virtual School users, we have special handling for the Secondary Phone(s) column.

As long as you leave the default formatting in place, i.e.:

Virtual School Counselor (by District) Home: (123) 456-7890 ; School-Based Counselor Work: (123) 456-7890 ; Mother Cell: (123) 456-7890 ; Student's School Work: (123) 456-7890 ;

Bulk Texter Pro will automatically parse out the phone numbers, and allow you to select which phone number labels you want to use as recipients. To select which labels will be used as recipients, just click on the Settings icon next to the CSV name after uploading your CSV.

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.
  • Each column name should be unique.
  • 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.