Import Student Data & Photos
Learn how to format your Excel spreadsheets and structure your student photos to utilize IdGenie's bulk auto-matching generation feature.
1. Preparing the Excel Data
Your data must be uploaded as either an .xlsx or .csv file. The system uses the column headers in the first row to map your data to the ID card template.
The 'ID_Number' Column is Mandatory
ID_Number, Roll_No, or Student_ID). This exact value will be used to automatically find the student's corresponding photo.| Column Header | Required | Description | Example |
|---|---|---|---|
| STD_ID | Yes | Unique Identifier (Roll No, SPID, GR Number, etc.). Crucial for matching exactly with the student's photo filename. | 101 |
| STD_NAME | Yes | Full name of the student. | John Doe |
| STD_CLASS | No | Student's class or grade. | 10th Science |
| STD_DOB | No | Date of birth (Recommended format: YYYY-MM-DD). | 2005-08-14 |
| STD_NUM | No | Student's or Parent's contact number. | 9876543210 |
| STD_ADDRESS | No | Residential address. | 123 Main St, City |
| STD_BLOOD_GROUP | No | Student's blood group. | O+ |
| STD_GR_NUM | No | General Register number (Alternative unique ID). | GR-2026 |
| STD_FATHER_NAME | No | Father's name. | Robert Doe |
| STD_HOUSE | No | School house name or color. | Red House |
| STD_SPID | No | Student Profile ID. | SP12345 |
| STD_BRANCH | No | Branch or stream. | Computer Science |
| STD_EMAIL | No | Student email address. | [email protected] |
ID_Number,First_Name,Last_Name,Course,DOB,Blood_Group
STU-2024-001,John,Doe,Computer Science,2001-05-14,O+
STU-2024-002,Jane,Smith,Business Admin,2002-08-22,A-
STU-2024-003,Michael,Johnson,Engineering,2001-11-03,B+2. Structuring the Photos
Instead of manually linking hundreds of images, you will upload a folder (or ZIP file) containing all student photos. The filename of each image must exactly match the student's unique ID from your Excel file.
Correct Naming
Incorrect Naming
- Supported formats: .jpg, .jpeg, .png.
- Recommended resolution: 300x400 pixels (Aspect ratio 3:4).
- Maximum file size per image: 2MB.
3. The Auto-Matching Process
When you upload both your Excel file and your Photo folder, IdGenie processes them entirely locally on your device. Here is how the engine assembles the final ID cards:
Data Parsing
The app reads your Excel file row by row, identifying the core unique identifier (e.g., STU-2024-001).
Local Image Search
It scans the uploaded photo folder for a filename matching the exact identifier (ignoring file extensions like .jpg or .png).
Template Assembly
Once a match is found, the data and photo are injected into your chosen ID card template. If a photo is missing, a default avatar placeholder is used, and a warning is shown in the generation log.