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 Name	Student Number	Parent Number	Grade	Subject
Steffanie	(111) 222-3333	(111) 222-4444	95	Algebra
Jack	(111) 222-3334	(111) 222-4445	85	US 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.