Provision Map knowledge base

How to import pupils from a spreadsheet

This guide will explain how to import pupils from a spreadsheet.

If you are using a manual Provision Map account that isn’t integrated with your Management Information System, you can manually import pupils into Provision Map. To begin importing pupils from a spreadsheet, mouse over theÌý´¡»å³¾¾±²ÔÌýtab at the top of the page and click on theÌýImport pupilsÌýoption in the drop down menu.

Provision Map import pupils tab

You will need an Excel spreadsheet containing the list of pupils that you’d like to import. The spreadsheet will need to follow a specific template, which can be downloaded from theÌýResourcesÌýsection on the right. The required information can be easily generated from your School’s MIS (e.g. SIMS, Integris, etc), but If you need assistance in this task then contact your school’s data manager.

Provision Map Resources

Once you have prepared a spreadsheet, click on theÌýChoose fileÌýbutton to prepare your spreadsheet for upload.

Provision Map choosefile_button

Next, click on theÌýImportÌýbutton to transfer the spreadsheet data into Provision Map.

Provision Map import button

This will take you to a preview of your uploaded pupils. Any errors in the uploaded data (such as missing fields or incorrect date formats) will appear with red backgrounds. If the system detects that a pupil is already in Provision Map, the matching fields will appear with a yellow background and the import will update the existing pupil records with the new data. You can match each column heading to the relevant column by selecting the most appropriate option from each drop down field.

Provision Map import_example

Above the table in the top right hand corner of the page, you will see three buttons. If you have changed your mind about importing pupils, click on theÌýCancelÌýbutton to stop the import. If you have made changes to the data on this page, clicking theÌýUpdateÌýbutton will refresh the page with any warnings or errors.

Provision Map cancel update import buttons

Once you are happy with the pupil data, click on theÌýImportÌýbutton to add the records into Provision Map.

Provision Map import_success

Need more support?
Contact us atÌýsupport.provisionmap@tes.com.

Ìý

Back to Provision Map knowledge base

Interested in Provision Map?

Give your SENCO the power to document, review and track learning plans and interventions quickly and simply.

Image
Provision Map MAT Dashboard