Employee data register template (Excel)
A ready 30-row employee master register in Excel: employee ID, full name, national ID or passport, phone, email, department, job title, branch, hire date, contract type dropdown, contract and ID/permit expiry dates, basic salary and emergency contact. Free, no signup.
Need expiry reminders and stored employee files instead of a spreadsheet?
In Dawmly you store each employee's national ID, passport, permits and contract on their profile and receive alerts 30 days, 7 days and on the expiry day (Starter and above). Employee records and attendance are free for up to 3 employees.
Start freeNext step: Employee documents · Employment contract template · HR software
What's in the file
- Identity and contact columns: employee ID, full name, national ID or passport number, phone, email and emergency contact.
- Role and contract columns: department, job title, branch, hire date, contract type dropdown (Unlimited, Fixed-term, Part-time), contract end date, ID or permit expiry date and basic salary.
- Summary and instructions: automatic
COUNTAtotal of listed employees plus a How to use instructions sheet.
How to use the employee data form
- Enter your company name and the last-updated date at the top of the sheet.
- Record one employee per row and pick the contract type from the dropdown.
- Enter hire dates, contract end dates and ID/permit expiry dates in
yyyy-mm-ddformat. - When you want automated expiry alerts, upload each employee's files in Dawmly employee documents.
Keeping expiry dates from slipping
Excel keeps every employee's key dates in one place, but it will not email or notify you before a work permit, residence permit or fixed-term contract lapses. Moving those records into Dawmly employee documents gives company admins automatic reminders 30 days before expiry, 7 days before, and on the expiry day itself.