Excel Import/Export in UDISE+
UDISE+ allows schools to import student data in bulk using Excel files. This saves time compared to manual entry, especially for schools with large student strength.
Student Data Excel Format
| Column | Field Name | Format | Required |
|---|---|---|---|
| A | Student Name | Text | Yes |
| B | Father's Name | Text | Yes |
| C | Mother's Name | Text | Yes |
| D | Date of Birth | DD-MM-YYYY | Yes |
| E | Gender | M/F/T | Yes |
| F | Class | 1-12, Nursery, LKG, UKG | Yes |
| G | Section | Text | No |
| H | Aadhaar Number | 12 digits | Recommended |
| I | Category | GEN/SC/ST/OBC | Yes |
| J | Minority Status | Y/N | Yes |
Common Excel Errors
- Wrong date format: Use DD-MM-YYYY not MM/DD/YYYY or other formats
- Extra spaces: Remove leading/trailing spaces from all cells
- Special characters: Avoid special characters in names
- Invalid Aadhaar: Aadhaar must be exactly 12 digits, no spaces or dashes
Tired of manual data entry?
Schoolites keeps your school data in UDISE+ format all year, so you export it instead of re-typing it.
How to Import Excel Data
Download Template
From UDISE+ portal, download the official Excel template.
Fill Data
Enter student data following exact column format.
Validate
Check for common errors before uploading.
Upload
Go to Student Data > Bulk Upload and select your file.
Schoolites Excel Export
With Schoolites, you can export student data in UDISE+ compatible format with one click:
No need to manually format your data - Schoolites handles the column mapping automatically.
Frequently Asked Questions
UDISE+ accepts .xls and .xlsx files. Both Excel 97-2003 and newer formats work.
Official limit is usually 1000 rows per upload. For larger data, split into multiple files.
Yes, but download as .xlsx before uploading to UDISE+. Do not use .csv or Google Sheets link.
Tired of Manual UDISE+ Data Entry?
Let Schoolites handle the complexity. Keep student and staff data UDISE+ ready all year and export it instead of re-typing it before the deadline.
Try Schoolites Free1 month free after a small one-time registration fee