GUIDE

Bulk Employee Import via Excel

Import hundreds of employees at once using the Attend Mitra Excel template — departments, designations, salary structures, and contact details.

Bulk Employee Import via Excel

Downloading the Import Template

Go to Workforce → Employees → Import and download the Excel template. It includes columns for name, employee ID, department, designation, email, phone, date of joining, salary components, and statutory details.

Fill in required fields (marked with asterisks) and optional fields as available. Do not modify column headers — the import parser depends on exact header names.

  • Required: name, employee ID, department, date of joining
  • Optional: bank details, PAN, UAN, shift assignment
  • Maximum 500 rows per import batch

Uploading and Validating

Upload the completed file and review the validation preview. Attend Mitra flags duplicate employee IDs, invalid email formats, and missing required fields before import.

Successful imports create employee records and optionally send Attend Mitra app invitations in bulk.

Related guides

Ready to put this into practice?

Start your free trial or book a live demo with our team.