📊CSV Import Templates

Employee Directory

Employee information CSV for HR systems and directory imports.

Explanation

Standard employee data format including department, role, and contact information.

Examples

Employee CSV

Output

employeeId,email,firstName,lastName,department,jobTitle,manager,hireDate,status
EMP001,john.doe@company.com,John,Doe,Engineering,Senior Developer,EMP100,2023-01-15,active
EMP002,jane.smith@company.com,Jane,Smith,Sales,Account Manager,EMP101,2023-03-20,active
EMP003,bob.jones@company.com,Bob,Jones,Marketing,Marketing Lead,EMP102,2022-11-01,active

Code Examples

JavaScript

// Import employees with hierarchy
async function importEmployees(csvData) {
  const employees = parseCSV(csvData);
  
  // First pass: create all employees
  for (const emp of employees) {
    await createEmployee({
      id: emp.employeeId,
      email: emp.email,
      firstName: emp.firstName,
      lastName: emp.lastName,
      department: emp.department,
      jobTitle: emp.jobTitle,
      hireDate: new Date(emp.hireDate),
      status: emp.status
    });
  }
  
  // Second pass: set manager relationships
  for (const emp of employees) {
    if (emp.manager) {
      await setManager(emp.employeeId, emp.manager);
    }
  }
}

Try it Now

Open in CSV/JSON Converter

💡 Tips

Use unique employee IDs
Import in two passes for manager relationships
Include hire date for tenure tracking
Status field for active/inactive employees
Consider separate CSV for sensitive data (salary)
Validate department codes exist

⚠️ Common Pitfalls

Manager references must exist
Circular manager relationships
Missing required fields cause import failures
Don't include SSN or sensitive PII in exports
Date format inconsistencies