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. Your phone number column headers can have any of these formats: number, Number2, cell #3, mobile#4, phone #5, etc.

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.

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.
  • You may optionally add a column titled SendMessage, for which messages will only be sent if the cell's value is True.
  • 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 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.
  • 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.