Excel / SIMS import

Problem : After spending hours writing reports in excel for pupils I then need to copy and paste each one into the right columns in SIMS.  This also takes ages.

I always felt there was a way to import the entire data sheet – and there is.  It is actually pretty simple, and this blog is about how to do it.  This is the 10 stage process – it takes about 30 seconds in total after you write your reports.

Step 1 : Export the marksheet from SIMS into excel – as a formatted sheet.


Step 2 : Unprotect the sheet – to do this right click on the sheet name, then click unprotect


Step 3 : Write your reports


Step 4 : Protect the sheet (right click the tab name, click protect, ok)

Step 5 : Save your excel file as a xms file type

Step 6 : Go back into SIMS, go to Routines, Data In, Assessment and Import from Spreadsheet


Step 7 : Click the folder icon, find your file.


Step 8 : Click ok to the dialogue box confirming the names of the columns


Step 9 : Click next twice

Step 10 : The columns look like they are blank. Click out of the marksheet and load it up and they will be there.

I take no responsibility for this post!  It works for me but please check your reports and marksheets carefully!



Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s