How do I prepare a Text Journeys Group spreadsheet?

Ensure your spreadsheet of mobile numbers is compatible for use with the Text Journeys Groups function

Contents

Spreadsheet Criteria

Formatting Spreadsheets Downloaded from Donr

Spreadsheet Criteria

When uploading a spreadsheet of mobile numbers for use as a recipient Group on Donr's Text Journeys solution, there are several criteria which the spreadsheet must adhere to:

  • It must be saved as a .csv spreadsheet;
  • It must contain numbers and spaces only – no column headers, no recipient's names, no '+' symbol, no other characters of any kind.
  • All mobile numbers must start with 07 or 447 or 7.
  • Mobile numbers must be the correct length – if the mobile number starts with 07, it will be 11 digits long.

Return to Contents

Formatting Spreadsheets Downloaded from Donr

If you are planning to create a Text Journeys Group using mobile numbers downloaded from Donr, after you've made use of our Text Giving or Text Raffles solution, you may need to slightly re-format the numbers in order to use the spreadsheet in Text Journeys. Here's a step-by-step guide to help:

  • Donr Dashboard > Team Management > Three dots button next to user profile > Edit > Show data > Enable (N.B. You must be an Org Admin-level user to complete this step. If you are not an Org Admin-level user, please ask your Org Admin to edit your profile, or to upgrade your user profile at no extra charge);
  • Download your spreadsheet of mobile numbers from the All Donations section of the Donr Dashboard or the 'download entries' option in Text Raffles;
  • Use CTRL + A to select all data on the spreadsheet and then CTRL + C to copy it;
  • Open a new spreadsheet window;
  • Use CTRL + V to paste your data into your new spreadsheet;
  • File > Save As > File Format > Set to .csv > Save
  • Delete all data except for that which you find in Column C, 'msisdn.'
  • Click on the cell which says 'msisdn' > Right click > Delete > Entire row >
  • Highlight all mobile numbers > Right click > Cut > Paste into Column A
  • Highlight Column A
  • Locate the drop-down menu in your toolbar which will have 'General' pre-selected (see Figure 1) > Select 'Number' from the drop-down menu (see Figure 2).
  • Click the 'decrease decimal' button twice (see Figure 3).

Figure 1

Figure 1

Figure 2

Figure 2

Figure 3

Figure 3

Return to Contents