{"id":158241,"date":"2026-10-26T06:58:16","date_gmt":"2026-10-26T06:58:16","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/%d8%a7%d8%b3%d8%aa%d9%8a%d8%b1%d8%a7%d8%af-%d8%a7%d9%84%d9%85%d9%88%d8%b8%d9%81%d9%8a%d9%86-%d9%85%d9%86-%d9%85%d9%84%d9%81-excel-%d8%a3%d9%88-csv\/"},"modified":"2026-11-12T08:09:15","modified_gmt":"2026-11-12T08:09:15","slug":"importing-employees-from-an-excel-or-csv-file","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/","title":{"rendered":"Importing Employees from an Excel or CSV File"},"content":{"rendered":"<div dir=\"ltr\" lang=\"en\">\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Importing employees lets you add a large number of employees and users at once from an Excel or CSV file, instead of adding each employee from the form. It is usually used when starting to work on the system or moving employee data from another system.<\/p>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">This guide explains preparing the file, the accepted values in each column, the import steps, what the system creates afterward, and the error messages and their solutions.<\/p>\n<div style=\"background: #f6f8fb; border: 1px solid #e5e7eb; border-radius: 8px; padding: 12px 16px; margin: 0 0 20px; font-size: 15px; line-height: 1.8;\">\n<div style=\"display: flex; gap: 8px; padding: 4px 0;\"><span style=\"min-width: 120px; color: #6b7280;\">Required Permissions<\/span><span style=\"color: #1f2430;\">Both the permission to add employees and the permission to edit them, set from <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/roles\/index\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Roles<\/strong><\/a>.<\/span><\/div>\n<div style=\"display: flex; gap: 8px; padding: 4px 0;\"><span style=\"min-width: 120px; color: #6b7280;\">How to Access<\/span><span style=\"color: #1f2430;\">Direct link: <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/v2\/owner\/import\/staff\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Import Employees<\/strong><\/a>.<\/span><\/div>\n<\/div>\n<div style=\"border: 1px solid #e5e7eb; border-radius: 8px; padding: 12px 16px; margin: 0 0 20px;\">\n<p style=\"margin: 0 0 6px; font-weight: bold; color: #111827;\">Table of Contents<\/p>\n<ol style=\"margin: 0; padding-left: 22px;\">\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#before\"><strong style=\"color: #1a56db;\">Before You Start<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#file\"><strong style=\"color: #1a56db;\">Preparing the Import File<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#fields\"><strong style=\"color: #1a56db;\">Fields and Accepted Values<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#steps\"><strong style=\"color: #1a56db;\">Import Steps<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#matching\"><strong style=\"color: #1a56db;\">How Does the System Handle the File Data?<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#result\"><strong style=\"color: #1a56db;\">Results Screen<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#effect\"><strong style=\"color: #1a56db;\">Impact on the System<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#errors\"><strong style=\"color: #1a56db;\">Error Messages and Solutions<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#faq\"><strong style=\"color: #1a56db;\">FAQs<\/strong><\/a><\/li>\n<\/ol>\n<\/div>\n<h2 id=\"before\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Before You Start<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">First add the data the employees will be linked to: branches, <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/roles\/index\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Roles<\/strong><\/a>, departments, designations, employment types, employee levels, shifts, and leave policies. The import doesn&#8217;t create any of them, and a row containing a value that doesn&#8217;t exist fails.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Make sure of your plan balance; each <strong style=\"color: #111827;\">User<\/strong> counts toward the number of users, and each <strong style=\"color: #111827;\">Employee<\/strong> counts toward the number of employees.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The import is for adding new employees. To edit the data of an existing employee, edit it from its page.<\/li>\n<\/ul>\n<h2 id=\"file\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Preparing the Import File<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Allowed files: <strong style=\"color: #111827;\">csv<\/strong>, <strong style=\"color: #111827;\">xls<\/strong>, and <strong style=\"color: #111827;\">xlsx<\/strong>. Download the sample file from <strong style=\"color: #111827;\">Download Sample<\/strong> on the import page; the sample file differs according to whether the HR app is enabled, and with it enabled, the job and attendance columns appear.<\/p>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Each row in the file = one employee.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Write the dates in the date format set in your account (the sample file uses day\/month\/year).<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Write the fixed values exactly as in the following table, such as User, Employee, Yes, and No.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Don&#8217;t use the question mark (?) in any cell; the system considers it a corrupted character and rejects the row.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Save the CSV file with UTF-8 encoding so Arabic names appear correctly.<\/li>\n<\/ul>\n<h2 id=\"fields\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Fields and Accepted Values<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Basic Data<\/h3>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Column in the sample file<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">System Field<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Required<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Accepted values<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Employee Code<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Code<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes (map the column)<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The employee code. Leave it empty for the employee to take the next number in auto numbering.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Type<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Type<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">User<\/strong> (a user who can log in to the system) or <strong style=\"color: #111827;\">Employee<\/strong> (an employee). In English only.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">First Name \/ Middle Name \/ Last name<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">First Name<\/strong> \/ <strong style=\"color: #111827;\">Middle Name<\/strong> \/ <strong style=\"color: #111827;\">Last Name<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">First Name only<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The employee name consists of the three.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Email Address<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Email Address<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Not repeated in the file or with an existing employee.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Can Access System<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Can Access System<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes or No (or 1 and 0).<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Send Credentials to Employee Email<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Send Credentials to Employee Email<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes to send the login details to the employee email.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Display Language<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Language<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Arabic or English.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Role<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Role<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The role name as in <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/roles\/index\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Roles<\/strong><\/a>.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Branch<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Branch<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The branch name. If empty, the current branch is used.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Accessible Branches<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Accessible Branches<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Branch names separated by commas. For users only.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Country<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Country<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The country name in English, such as Saudi Arabia or Egypt. A country code such as SA is not accepted.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Citizenship Status<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Citizenship Status<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Citizen or Resident.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Mobile Number \/ Phone Number<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Mobile Number<\/strong> \/ <strong style=\"color: #111827;\">Phone Number<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Free text.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Official ID Number<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Official ID Number<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Not repeated in the file or with an existing employee.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Present \/ Permanent Address<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Present Address \/ Permanent Address<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The city, postal code, and address text.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Notes<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Notes<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Free text.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Job and Attendance Data (with the HR app)<\/h3>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Column in the sample file<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">System Field<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Required<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Accepted values<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Birth Date<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Birth Date<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A date in your account format.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Join Date<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Join Date<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A date in your account format.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Designation<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Designation<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Depending on the settings<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The designation name as in the system.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Department<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Department<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Depending on the settings<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The department name as in the system.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Employment Type<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Employment Type<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Depending on the settings<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The employment type name as in the system.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Employee Level<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Employee Level<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Depending on the settings<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The level name as in the system.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Direct Manager Code<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Direct Manager<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The manager code, not their name. It can be an employee in a previous row of the same file.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Attendance Shift<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Attendance Shift<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The shift name. With the Attendance app.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Leave Policy<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Leave Policy<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The policy name. With the Attendance app.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Attendance Restrictions<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Attendance Restriction<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The restriction name. With the Attendance app.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div style=\"display: flex; gap: 10px; background: #f6f8fb; border-left: 4px solid #1a56db; border-radius: 6px; padding: 14px 16px; margin: 0 0 18px;\">\n<p><span style=\"flex: 0 0 auto; font-size: 18px; line-height: 1.6;\">\ud83d\udec8<\/span><\/p>\n<p style=\"margin: 0; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Note:<\/strong> The fields marked with * in the <strong style=\"color: #111827;\">Fields Mapping<\/strong> step are required, and you can&#8217;t continue without mapping them to columns in the file. The import doesn&#8217;t include salary or contracts; they have a separate import.<\/p>\n<\/div>\n<h2 id=\"steps\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Import Steps<\/h2>\n<ol style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Open <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/v2\/owner\/import\/staff\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Import Employees<\/strong><\/a>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">In <strong style=\"color: #111827;\">CSV \/ Excel File<\/strong>, choose the file.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">For CSV files, choose the <strong style=\"color: #111827;\">Delimiters<\/strong>: usually Comma Separated ( , ), or Semicolon Separated ( ; ), or Tab Delimited. This field doesn&#8217;t appear for Excel files.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Enable <strong style=\"color: #111827;\">Import First Row<\/strong> only if the first row is data and not column headers.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Click <strong style=\"color: #111827;\">Next Step<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">In <strong style=\"color: #111827;\">Fields Mapping<\/strong>, for each <strong style=\"color: #111827;\">System Field<\/strong>, choose the matching column from <strong style=\"color: #111827;\">Corresponding Field in File<\/strong>. The system automatically matches the columns with the same name; review the matching, especially the <strong style=\"color: #111827;\">Type<\/strong> and <strong style=\"color: #111827;\">Gender<\/strong> fields, because they have the same name in the Arabic interface.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Enable <strong style=\"color: #111827;\">Ignore errors while importing<\/strong> to import the correct rows and skip the wrong ones. Without it, the import stops at the first wrong row and no employee is imported.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Click <strong style=\"color: #111827;\">Import<\/strong>, and wait for the <strong style=\"color: #111827;\">Results<\/strong> screen.<\/li>\n<\/ol>\n<h2 id=\"matching\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">How Does the System Handle the File Data?<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Data<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Search method<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">If not found<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Code<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">An empty code takes the next number in numbering, and a written code is used as is.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">\u2014<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Branch<\/strong>, <strong style=\"color: #111827;\">Role<\/strong>, department, designation, employment type, level, shift, and leave policy<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">By name (case-insensitive) or by ID.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The row fails; it is not created automatically.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Country<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">By the English country name.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Fails the row.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Direct Manager<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">By the employee code.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Fails the row.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Accessible Branches<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">By the branch names.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Fails the row.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"result\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Results Screen<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The message <strong style=\"color: #111827;\">Thank you, your file has been imported successfully<\/strong> appears, along with <strong style=\"color: #111827;\">with the following errors.<\/strong> and the list of errors, if any.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Three counters appear: <strong style=\"color: #111827;\">Imported successfully.<\/strong> and <strong style=\"color: #111827;\">Updated successfully.<\/strong> and <strong style=\"color: #111827;\">Records failed to import.<\/strong><\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Always review the counters and errors, because the message appears even if all rows fail.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Correct the failed rows and import them alone in a new file, so employees are not duplicated.<\/li>\n<\/ul>\n<h2 id=\"effect\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Impact on the System<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Place<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">What happens<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Employees<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Each employee is added to <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/v2\/owner\/entity\/staff\/list\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Employees<\/strong><\/a> with an Active status.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">System login<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A user with login permission can log in with their email. When you choose Yes in sending the login details, the login details are sent to them by email.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Job data<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The job and attendance data is saved with the HR app.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Numbering<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The employee code numbering advances.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Plan<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Employees and users count toward the plan limits; rows that exceed them are not imported.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Activity Log<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Adding each employee is recorded.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The import doesn&#8217;t create roles, departments, or branches, nor contracts, salaries, or accounting accounts for employees.<\/p>\n<h2 id=\"errors\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Error Messages and Solutions<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Some employee messages appear in English, as shown in the table.<\/p>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Message that appears<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Cause<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Solution<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Invalid Data, Missing required field or does not exist (field) at row #(number)<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A required field is empty.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Complete the value.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Invalid Data, Wrong Relation (value) at row #(number)<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A branch, role, department, designation, or country doesn&#8217;t exist.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Write the name exactly as in the system, or add it first. The country is in English.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Invalid Employee Mode value &#8220;(value)&#8221; at row #(number). Accepted values are User or Employee.<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The type value is incorrect.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Write User or Employee in English.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Email address &#8220;(email)&#8221; is duplicated in the import file at row #(number).<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The email is repeated in the file.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Give each employee a different email.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Email address &#8220;(email)&#8221; at row #(number) already exists in the system.<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The email is used by an existing employee.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Use another email.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Official ID &#8220;(number)&#8221; is duplicated in the import file at row #(number).<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The ID number is repeated in the file.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Correct the number.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Official ID &#8220;(number)&#8221; at row #(number) already exists in the system.<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The ID number is registered to another employee.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Correct the number.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Direct Manager not found (Code: (code)) at row #(number).<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The manager code doesn&#8217;t exist.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Write the manager code, and put the manager row before their employees if it is in the same file.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Branch not found: &#8220;(branch)&#8221; at row #(number).<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A branch that doesn&#8217;t exist in the accessible branches.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Write the branch names exactly as in the system.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">You have exceeded your available slots. Please increase your limit to import this employee.<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The number of users or employees in the plan is exceeded.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Upgrade the plan or reduce the number of rows.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Invalid Data, Data must be in the correct date format in &#8216;(field)&#8217; field at row #(number)<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">A date in the wrong format.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Write it in the date format set in your account.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Invalid Data, encoding issue or corrupted characters in field (field) at row #(number)<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The file is not UTF-8 encoded, or a cell contains the ? mark.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Save the file as CSV UTF-8 and delete the question marks.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Sorry, it is not allowed to import one column file, make sure you have selected a file with the correct format<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The delimiter is incorrect.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Choose the suitable delimiter, such as Semicolon.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">CSV columns count is not the same through all file rows<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Rows with a different number of columns.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Make the columns the same in all rows.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">The uploaded file could not be processed. Please ensure it is a valid XLS, XLSX, or CSV file and try again.<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">An unsupported or corrupted file type.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Save it again as xlsx or csv.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">You are not allowed to access this page<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">You don&#8217;t have both the add and edit permissions.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Ask the account manager for the permissions.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"faq\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">FAQs<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">What is the difference between User and Employee in the Type column?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">User is a user who can log in to the system and counts toward the number of users, and Employee is an HR employee and counts toward the number of employees.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Are login details sent to employees?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Yes, if you write Yes in the Send Credentials to Employee Email column.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Can the data of existing employees be updated by import?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No, the import is for adding new employees; edit the existing employee from its page.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Does the import create departments and designations that don&#8217;t exist?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No, add them first, then import the employees.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Why did the row fail even though I wrote the country?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Because the country is written by its English name, such as Saudi Arabia, not by its code or in Arabic.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">How do I set the direct manager?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Write the manager code in the Direct Manager Code column.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Can salaries be imported?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No, salaries are added from contracts, and they have a separate import.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Why did Arabic names appear as symbols?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Because the file is not UTF-8 encoded; save it as CSV UTF-8 or upload an xlsx file.<\/p>\n<\/div>\n","protected":false},"author":17,"featured_media":0,"template":"","categories":[2201,2197,9114],"tags":[26681,27233,26689,27194,26686,14028,23128,30402,30375,26721,30401,30376,30405,30400,30403,30377,30404],"class_list":["post-158241","tutorial","type-tutorial","status-publish","hentry","category-employees","category-hr","category-manage-employees","tag-add-employees-in-bulk","tag-direct-manager","tag-employee-code","tag-employee-import-sample-file","tag-fields-mapping","tag-ignore-errors-while-importing","tag-import-employees","tag-import-employees-csv","tag-import-employees-excel-en","tag-import-employees-from-excel","tag-import-users","tag-invalid-employee-mode-value-en","tag-move-employees-from-another-system","tag-send-login-details-to-employee","tag-upload-employee-data","tag-user-employee-en","tag-you-have-exceeded-your-available-slots"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importing Employees from an Excel or CSV File - Daftra Knowledge Base<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Employees from an Excel or CSV File - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"Importing employees lets you add a large number of employees and users at once from an Excel or CSV file, instead of adding each employee from the form. It is usually used when starting to work on the system or moving employee data from another system. This guide explains preparing the file, the accepted values [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-12T08:09:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#organization\",\"name\":\"Daftra\",\"url\":\"https:\/\/docs.daftra.com\/en\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"caption\":\"Daftra\"},\"image\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#website\",\"url\":\"https:\/\/docs.daftra.com\/en\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"publisher\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/\",\"name\":\"Importing Employees from an Excel or CSV File - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#website\"},\"datePublished\":\"2026-10-26T06:58:16+00:00\",\"dateModified\":\"2026-11-12T08:09:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Employees from an Excel or CSV File\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Employees from an Excel or CSV File - Daftra Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/","og_locale":"en_US","og_type":"article","og_title":"Importing Employees from an Excel or CSV File - Daftra Knowledge Base","og_description":"Importing employees lets you add a large number of employees and users at once from an Excel or CSV file, instead of adding each employee from the form. It is usually used when starting to work on the system or moving employee data from another system. This guide explains preparing the file, the accepted values [&hellip;]","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-11-12T08:09:15+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/docs.daftra.com\/en\/#organization","name":"Daftra","url":"https:\/\/docs.daftra.com\/en\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/en\/#logo","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","caption":"Daftra"},"image":{"@id":"https:\/\/docs.daftra.com\/en\/#logo"}},{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/en\/#website","url":"https:\/\/docs.daftra.com\/en\/","name":"Daftra Knowledge Base","description":"Daftra","publisher":{"@id":"https:\/\/docs.daftra.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/","name":"Importing Employees from an Excel or CSV File - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/en\/#website"},"datePublished":"2026-10-26T06:58:16+00:00","dateModified":"2026-11-12T08:09:15+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/importing-employees-from-an-excel-or-csv-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Importing Employees from an Excel or CSV File"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":4,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158241\/revisions"}],"predecessor-version":[{"id":158254,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/158241\/revisions\/158254"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=158241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=158241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=158241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}