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 |
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 isTrue
. - 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.