Exporting/Importing Key Stage marksheets to Excel and Mapping aspects

Importing data from a “Formatted” spreadsheet will import back into the original aspects and result sets that were contained when the data was previously exported. Importing data from an “Un-formatted” spreadsheet will require user input to map the columns of the spreadsheet to the aspects and result sets in SIMS.

If the spreadsheets are exported from Sims “Un-formatted” then the data within this will need to be mapped to SIMS.  For convenience, we would recommend that you export your spreadsheet “Formatted”.

A spreadsheet being un-formatted will be the only cause for needing to map the data.