Call Us: 0313-5419942

Import students from excel

Students -> Import Students
Before import make sure you have taken a full backup of database to avoid any type of data lose and also check your excel sheet have mandatory columns like student name and roll no etc.
To import students from excel
1. Select excel file
2. If excel file contains more than one sheets then select sheet.
3. Select class where you want to import students
4. Select section where you want to import students

Excel file binding
On right side there are some settings to bind excel file.
5. Add starting row number default is 2 you can change as per your excel file.
6. Ending row number, you can specify ending row number if your excel sheet contains more records of other classes or sections, otherwise select ‘All Rows’
7. Map some mandatory columns to database fields
When you done with these settings then click on ‘Display’ system will read excel sheet and populate grid, at this point you need to check and verify if in grid data is looking fine with respect to its columns then click on ‘Import’. All students from excel file will be imported to School Management Software database.
You need to repeat this for all classes or sections.