Skip to main content
Dawmly

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 free

Next step: Employee documents · Employment contract template · HR software

What's in the file

How to use the employee data form

  1. Enter your company name and the last-updated date at the top of the sheet.
  2. Record one employee per row and pick the contract type from the dropdown.
  3. Enter hire dates, contract end dates and ID/permit expiry dates in yyyy-mm-dd format.
  4. 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.

Frequently asked questions

Is the employee data form free?

Yes, completely free with no signup. It opens in Microsoft Excel, Google Sheets and LibreOffice Calc.

How many employees does the register hold?

30 rows by default, with a COUNTA total below the table. You can insert more rows above the last row and extend the count formula.

What contract types are in the dropdown?

Unlimited, Fixed-term and Part-time.

How do I get automatic alerts before documents or contracts expire?

Upload each employee's ID, passport, permit or contract in Dawmly employee documents (Starter and above) with its expiry date to receive alerts 30 days, 7 days and on the expiry day.

Track daily attendance alongside employee records with the Dawmly attendance app, free for up to 3 employees.

Keep reading