{% extends "withnav_template.html" %} {% from "components/page-header.html" import page_header %} {% from "components/page-footer.html" import page_footer %} {% from "components/file-upload.html" import file_upload %} {% from "components/table.html" import list_table, text_field, index_field, index_field_heading %} {% from "components/components/back-link/macro.njk" import usaBackLink %} {% block service_page_title %} Upload your bulk-sending spreadsheet {% endblock %} {% block backLink %} {{ usaBackLink({ "href": url_for('main.send_one_off_step', service_id=current_service.id, template_id=template.id, step_index=0), "html": "Back to select recipients" }) }} {% endblock %} {% set phone_numbers = [ { "svg_src": "#check_circle", "card_heading": "Label column A (the first column) as Phone number", }, { "svg_src": "#check_circle", "card_heading": "Double check it's the only column with Phone number as its label", }, { "svg_src": "#check_circle", "card_heading": "Make sure no duplicate phone numbers are listed in Column A", } ] %} {% set additional_data = [ { "svg_src": "#check_circle", "card_heading": "Match column labels one-to-one to the message template placeholders", }, { "svg_src": "#check_circle", "card_heading": "Label each additional personalized placeholder separately", }, { "svg_src": "#check_circle", "card_heading": "Separate each word in a column label with a space or dash, but no commas", }, { "svg_src": "#check_circle", "card_heading": "Fill in each personalized placeholder with the appropriate data or information", }, { "svg_src": "#check_circle", "card_heading": "Fill in each conditional placeholder column with a Yes (Y) or No (N) to “answer” whether the recipient meets its criteria", } ] %} {% block maincolumn_content %} {{ page_header('Upload your bulk-sending spreadsheet')}}

Organize phone numbers and information in a single spreadsheet and upload when you have multiple messages to send. Column headers in the spreadsheet will place the data in the right spots within the template that's selected.

A spreadsheet is available to use

{% call(item, row_number) list_table( example, caption="Example spreadsheet", caption_visible=False, field_headings=[''] + column_headings ) %} {{ index_field(row_number - 1) }} {% for column in item %} {{ text_field(column) }} {% endfor %} {% endcall %}

Each template saved in Notify is given an example CSV formatted spreadsheet like this. It's the most reliable file format for uploading your contact list. Use this example to populate your template with the right data items. Start by downloading this example for your message template. Then save it as a CSV file for bulk messaging.

Your bulk-sending spreadsheet checklist

Phone numbers

    {% for item in phone_numbers %}
  • {{item.card_heading | safe }}
  • {% endfor %}

Additional data

    {% for item in additional_data %}
  • {{item.card_heading | safe }}
  • {% endfor %}

If an error occurs

  • If you're receiving any errors, double check your file format and make sure your data is pasted in with values only

You are filling in this template

Template: {{ template.name }}

{{ template|string }} {% endblock %}