Skip to content
Help homeहेल्प होम

Screen guide · Web app

Bulk Upload

Add many students at once from a CSV or Excel file, with an optional check of the file before anyone is added.

5 steps5 स्टेप

यह पेज अंग्रेज़ी में है। कुछ समझ न आए तो ।

Bulk Upload (the page is headed Bulk Import Student) admits a whole list of students from one file. You download the sample file, fill it in, optionally select Validate File (Optional) to find problems, and then select Upload.

The Admission Number column may be left blank. A row with a blank admission number gets the next available admission number of the school. A row that has an admission number keeps it.

The office uses it at the start of a session, or when a school moves its list of students into EDII.

  • Download the sample file and keep its headings exactly as they are.
  • The classes and sections written in the file must already exist in the school.
  • The file must be a CSV (.csv) or an Excel file (.xlsx, .xls), and at most 5 MB.
  • In school.edii.in: Students › Directory › Bulk Upload
  • Or press Ctrl K (⌘ K on a Mac) and type Bulk Upload.
  • Address: school.edii.in/add/add-studentFile
  • Who can see it: Staff whose role includes Students or Attendance access. Shown only when your school uses Student in EDII. If it is missing from your menu, ask your school admin.
Bulk Upload as it opensOpen a bigger pictureतस्वीर बड़ी करें
  1. Select Download Sample File and choose Download CSV or Download Excel. The sample shows the columns and the way each one is to be filled. Do not change the headings.

  2. Fill every cell except Admission Number, which you may leave blank.

    You may add a column called House at the end of the row (after SMID) to set each student’s house, for example Red, Blue or Green. You may also add a column called Student Type after it with Boarder, Day Boarder or Day Scholar. Any other value is left blank, and a missing column leaves the field blank.

  3. Under Student file (.csv, .xlsx, .xls) select Choose file and pick your file. When it is accepted you see File has been uploaded, Please click on the Upload Button to Continue adding the student. An Excel file is first changed into a CSV for you, and then you see Excel file has been converted and uploaded. Please click on the Upload Button to Continue adding the student.

  4. Select Validate File (Optional). EDII reads the file the way the upload does and shows a Validation report without adding anybody. It also compares each row with the students already in the school, such as an Aadhaar number or State ID that is already used.

    The report says either that all rows look good, or lists Problems to fix (you must correct them) and Points to review (you may still upload). Row 1 in the report is the first student, not the heading row. After fixing the file, choose it again.

  5. Select Upload. You see Starting upload… and then the Student Upload Progress page opens. It shows how many students are done, and at the end how many were Done and how many Failed, so you can fix the rows that were not added.

Field What it is Notes
Student file (.csv, .xlsx, .xls) The file with the students. Only these three types. At most 5 MB.
Admission Number (column in the file) The admission number of each student. May be blank. A blank gets the next free number.
House (extra column) The house of each student. Optional. Put it after SMID.
Student Type (extra column) Boarder, Day Boarder or Day Scholar. Optional. Put it after House.
Button What it does What happens next
Download Sample File Gives you the template as Download CSV or Download Excel. The file is saved on your computer.
Validate File (Optional) Checks the chosen file without adding any student. A Validation report appears below.
Upload Starts adding the students from the chosen file. The Student Upload Progress page opens.
  • Each good row becomes a student in its class and section for the selected session.
  • Rows that could not be added are listed on the Student Upload Progress page, so you can correct them and upload them again.
  • The new students show in Students.
  • In a CSV file, every Aadhaar number must start with an apostrophe, for example ’012345678901. Without it Excel turns the 12 digits into a number like 5.66E+11. When EDII sees this it shows Aadhaar Number Format Error and clears the file choice. Excel files do not need the apostrophe.
  • Validation changes nothing. Students are created only when you select Upload.
Message What it means What to do
Only CSV or Excel files are allowed. Please upload a .csv, .xlsx, or .xls file. The file is of another type. Save the list as CSV or Excel and choose it again.
Max File Size is 5 MB The file is too big. Split the list into two or more files.
Error processing Excel file. Please ensure the file is valid. The Excel file could not be read. Open it in Excel, save it again as .xlsx and choose it again.
Please choose a CSV or Excel file first, then click Validate. No file was chosen before you selected Validate File. Choose the file first.
Please Add the Student List first by clicking on the “+” button! You selected Upload without a good file chosen. Choose the file with Choose file (there is no plus button) and wait for the File has been uploaded message.
No blocking problems found. The check found nothing that stops the upload. Some points to review may be listed. Read the points, then upload.
Network Issue, Please Try Again. The request did not reach EDII. Check the internet and try again.
  • Use Validate File (Optional) every time. It costs nothing and finds typos and duplicates before they become students.
  • Upload one class at a time if you are new to the sample file, so any problem is easy to trace.
Problem Likely cause What to do
Some students were not added A cell was empty, a class or section does not exist, or the Aadhaar number or State ID already belongs to another student. Open the Student Upload Progress page, read the list of failed rows, correct them in the file and upload only those rows again.
The Aadhaar Number Format Error window appears The CSV was saved from Excel and the Aadhaar numbers lost their digits. Put an apostrophe in front of each Aadhaar number, save the file and choose it again.

Did this page help?क्या इस पेज से मदद मिली?

Ask EDIIEDII से पूछें

Ask in English, Hindi or Hinglish. Answers come only from these help pages.English, हिंदी या Hinglish में पूछें। जवाब सिर्फ़ इन्हीं हेल्प पेजों से आते हैं।

Try askingऐसे पूछकर देखें