How to use the Import Wizard to add and edit pupils
Preparation
The Import Wizard can mass-create users in Purple Mash using data from a spreadsheet.
- Firstly, create a spreadsheet with three headers: Full Name, Class and UPN.
Ensure these columns are filled for each pupil.
We can mass-generate usernames and passwords for you at a later step. However, if you wish to set them up yourself for example, to match other usernames and passwords that pupils use, you can add columns with the headers 'username' or 'password'.

Upload data to Purple Mash
- Click on Pupils within 2Lasso

- Click on Tools
- Click on Import Wizard
You have two options to put the data on your spreadsheet into Manage Users:
• | You can save your spreadsheet as a .csv file. Then click on 'Select a file' and select that csv file. This is a better option for large numbers of pupils where you have a big spreadsheet. |
• | Or you can highlight and copy your pupil information, and then paste it into the box provided. |

- Click on Select a file and select your completed Excel Sheet
Generate Usernames and Passwords
You will then be prompted to select Usernames and Passwords for your new pupils.
Username Options
Full Names | LilyLloyd |
Initials | LL |
Forename initial + Surname | LLloyd |
Forename + Surname initial | LilyL |
Password Options
Animals | Dog33 |
Colours | Red54 |
Things | Home45 |
Picture Pin | 1256 |
Two digit Picture Pin | 46 |
Five letter noun followed by three digits | level654 |
Six Letter noun followed by four digits | stroll1666 |
Confirm and Complete
Rows appear in green when you are successfully adding a new user. Rows appear in orange when you are editing a user that is already in the system. If this is not what you wish to do, you may need to change the username you have chosen.
