Ensure your spreadsheet of mobile numbers is compatible for use with the Text Journeys Groups function
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.
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).