@extends('layouts.app') @section('title', 'Connect - Import / Export Employees') @section('content')

Import / Export Employees

Bulk manage employee directory through Excel.
Back to Directory

Export Employees

Download all current employee details to an Excel workbook.

Generate a clean Excel sheet containing all active, inactive, and terminated employee records in your organization. This is useful for backups, external payroll computation, or bulk updates.

Export Excel Workbook

Import Employees

Bulk register employees using an Excel spreadsheet.

@csrf

Excel Import Template & Guidelines

Please verify that your Excel file matches the column headings below. The order of columns does not matter, but headings must be named exactly as shown. Any unrecognized headings or rows with missing required columns will be skipped.

Column Heading Requirement Expected Values / Format Fallback Behaviour
Employee Code Required Unique alphanumeric ID (e.g., CN-1001) Skipped if empty or duplicate
First Name Required Text string Skipped if empty
Last Name Required Text string Skipped if empty
Email Required Valid email address Skipped if empty or duplicate
Phone Optional E.164 phone formats (e.g., +971501234567) Empty string
Date of Joining Optional Date format (YYYY-MM-DD) Defaults to today's date
Date of Birth Optional Date format (YYYY-MM-DD) Null
Gender Optional male, female, other Defaults to "male"
Marital Status Optional single, married, divorced, widowed Defaults to "single"
Blood Group Optional A+, A-, B+, B-, AB+, AB-, O+, O- Null
Status Optional active, inactive, terminated Defaults to "active"
Department Optional Any department name in your organization Created on-the-fly if not found
Designation Optional Any designation name in your organization Created on-the-fly if not found

Critical Notes for Admins

  • Each newly imported employee automatically gets a local User Account cache setup for their central GlixSSO logins.
  • Imported employees will be assigned the Employee role scoping inside the organization automatically.
  • Import processes are scoped under your current active organization tenant limits. If the count exceeds your subscription capacity, remaining entries will be ignored.
@endsection