Student Bulk Upload Instructions

To Bulk upload students follow the instructions below

Important: Download the sample CSV file by clicking here or in the attachment below. Copy and paste your data into the GeniusOne® supplied CSV file. Do not change any column names in the first row as this is the identifier for the data. The CSV upload will fail if the column names are modified in any way.

Mandatory Fields in Red

Fields and their description for the CSV file

• Unique ID - Leave Blank if uploading students for the first time. This will be created and assigned automatically by the system
• First Name - Student First Name
• Mid Name - Student Middle Name
  
• Last Name - Student Last Name
• DOB  -  DOB format should be DD/MM/YYYY (ex: 31/12/1996)
• Gender
• Branch: Also called Groups in GeniusOne®. If you are adding a Group/Branch in the CSV file please make sure you have added the same data in GeniusOne using ADD GROUPS. The Group data should be added to GeniusOne before uploading student data
• Address 1 - First line of the address
• Address 2 - Second line of the address
• Address 3 - Third line of the address
• Country
• State
• City
• Postcode * - Post Code or Zipcode 
• Title
• Parent First Name
• Parent  Last Name
• Parent Email  - all communication from GeniusOne® happens through the Parent email. Parents also use this to log in to the Parent Mobile App. Therefore it is extremely important to verify that the email supplied is correct. 
• Parent Contact - enter the phone number (preferably a WhatsApp/Mobile number) without the country code. Country Code will default to the registered center location. For the UK this would be 10 digits (7xxxxxxxxx), for the US it would be 10 digits (281 xxx xxxx). 
• School Year - The school year follows the following pattern: If the school year you need is not on the list, please raise a ticket to request.
• K
• PK1
• PK2
• PK3
• Reception
• Year 1
• Year 2
• Year 3
• .......
• Year 13
• Adult Student
• Notes - Any notes you want to associate with the student
• Reference - Any other reference number 

Remember: You can also update student information in bulk using the CSV file upload. To do this export the student data from GeniusOne®. Open the downloaded file. This file should contain all your student data. Do Not Delete the Unique ID Column data. Change any other data you want and re-upload the same file using the Bulk upload. GeniusOne® will bulk update the data based on the changes you have made in the file.