CSV converter for School Management Information System
Column A = Surname
Column B = First Name
Column C = Class Name or Year Group
Column D = Your MIS Reference number
Column A = Surname
Column B = First Name
Column C = Teaching Group
(If Teaching group is not required you can leave this column blank)
Column D = Your MIS Reference number
Column E = Registration Group
For Primary Education
For Secondary Education
To learn more about our conversion tool and how we process your information, click on the button below to download our XLSX to CSV Converter Overview and Privacy Policy
Need to contact someone?
If you need help with any Data or School MIS enquiries please contact Vicki with the contact information below and she will be more than happy to assist you
​
Email: v.curtis@braiswick.co.uk
Tel: 01206 399800 ext 0227
DD: 01206 399816
How to Export your spreadsheets dependant on MIS
1. Head to SIMS.net
2. Go to Report
3. Run the Report
4. Click Student
5. Scroll down to Licensed Photographer
6. Export Excel
7. Supply Effective Date (use todays date)
8. Click on Enabled Macros
​​
​
All of the information needed is included in the Excel spreadsheet generated
Please delete the year group and supervisor column as this information is not needed
​
Re-order the column to read, Surname, Forename, Registration group (Class) and Admission Number
1. Navigate to School > Custom report writer
2. From all reports page, create new report
3. Click create a new report
4. Set Title and Topic
5. Set the effective date (use todays date)
6. Select column for the report
7. Re-order Column's to: Surname, Forename, Class, Admission Numbers
8. Save as the Schools Name
1. Go to Students
2. Click on Full Student List
3. Click the green Excel button
4. Export the list to Excel
5. Select the correct columns (below)
6. Click Excel
7. Save the Excel Spreadsheet as your school name
8. Use the above conversion tool to convert it to a .CSV file
Please select the following column, in this order: Surnames, Forenames, Classes, Admission Numbers
