CSV Import Formats

Acalumi supports bulk import of users, questions, and class rosters via CSV files. This page documents the expected format for each.

User Import

Required Columns

Column	Required	Description	Example
first_name	Yes	User's first name	Aarav
last_name	Yes	User's last name	Patel
email	Yes	Email address (must be unique)	aarav.patel@school.edu
role	Yes	User role	student, teacher, parent, branch_admin
branch_code	Yes	Branch code to assign to	SV-JNR

Optional Columns

Column	Description	Example
phone	Phone number with country code	+919876543210
date_of_birth	Date of birth (YYYY-MM-DD)	2010-05-15
gender	Gender	male, female, other
password	Initial password (if not provided, a random one is generated)	Temp@123
admission_number	Student admission/enrollment number	ADM2025001
employee_id	Teacher employee ID	EMP001
nationality	Nationality	Indian
blood_group	Blood group	O+

Example CSV

first_name,last_name,email,role,branch_code,phone,password
Aarav,Patel,aarav.patel@school.edu,student,SV-JNR,+919876543210,Temp@123
Priya,Sharma,priya.sharma@school.edu,teacher,SV-JNR,+919876543211,Temp@123
Manoj,Kumar,manoj.kumar@school.edu,parent,SV-JNR,+919876543212,Temp@123

Notes

• The first row must be column headers
• Email must be unique across the organization
• Role values: student, teacher, parent, branch_admin, org_admin
• If password is omitted, users will receive an email to set their password

Question Import

Required Columns

Column	Required	Description	Example
question_text	Yes	The question content	What is 2+2?
type	Yes	Question type	mcq, true_false, fill_blank, essay
difficulty	Yes	Difficulty level	easy, medium, hard
points	Yes	Marks for this question	2

MCQ-Specific Columns

Column	Description	Example
option_a	First option	3
option_b	Second option	4
option_c	Third option	5
option_d	Fourth option	6
correct_answer	Correct option letter	b

Optional Columns

Column	Description	Example
subject	Subject name	Mathematics
topic	Topic within subject	Arithmetic
tags	Comma-separated tags	algebra,chapter-1
explanation	Explanation shown after grading	2+2 equals 4

Example CSV (MCQ)

question_text,type,difficulty,points,option_a,option_b,option_c,option_d,correct_answer,subject,topic
What is 2+2?,mcq,easy,1,3,4,5,6,b,Mathematics,Arithmetic
The capital of India is?,mcq,easy,1,Mumbai,Delhi,New Delhi,Kolkata,c,Social Studies,Geography

Class Roster Import

Used when adding students to a class via CSV.

Required Columns

Column	Required	Description	Example
email	Yes	Student's email (must exist in the system)	aarav.patel@school.edu

Optional Columns

Column	Description	Example
roll_number	Roll number within the class	1
admission_number	Student's admission number	ADM2025001

Example CSV

email,roll_number
aarav.patel@school.edu,1
divya.menon@school.edu,2
ishaan.gupta@school.edu,3

Import Tips

• Save files as UTF-8 encoded CSV to handle special characters
• Remove any empty rows at the end of the file
• Check for duplicate emails before importing - duplicates will be skipped with an error
• Download the template from the import page to get the exact column format
• The import preview shows validation errors before you confirm - review and fix before proceeding
• Large imports (500+ rows) may take a few minutes to process