Employee Info Sheet

One clean record per employee — role, contact, emergency details, documents and tenure — in a searchable staff directory.

An employee information sheet template is a ready-made record that keeps each employee's job, contact, personal, emergency and document details in one place, so HR has a single, searchable staff directory instead of scattered files.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Human Resources

Tables

Employees

Fields

17

Views

grid, cards, kanban, form, dashboard

Updated

2026-11-19

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Employees

17 fields · 6 sample rows

  • Directory (Grid)
  • Faces (Cards)
  • By status (Kanban)
  • Employee details form (Form)
  • Headcount (Dashboard)
Full nameTextEmployee IDAutonumberPhotoAttachmentJob titleTextDepartmentSingle selectEmployment typeSingle selectStatusSingle selectReporting managerTextWork emailEmailPhonePhoneDate of birthDateJoining dateDateTenure (years)FormulaHome addressAddressEmergency contactTextEmergency phonePhoneDocumentsAttachment
Aditi KulkarniEMP-0001Senior Backend EngineerEngineeringFull-timeActiveVikram Rao[email protected]+91 98200 1234518 Apr 199220 Nov 2022414 Lake View Road, Pune, Maharashtra, 411001, IndiaSuresh Kulkarni (father)+91 98220 54321
James WhitfieldEMP-0002Account ExecutiveSalesFull-timeActiveNeha Kapoor[email protected]+44 7700 9004562 Nov 198928 May 20251.522 Baker Street, London, NW1 6XE, United KingdomEmma Whitfield (spouse)+44 7700 900789
Sana MirzaEMP-0003People PartnerPeopleFull-timeOn leaveRachel Thomas[email protected]+91 99860 3344525 Jul 19942 Jun 20242.53rd Cross, Indiranagar, Bengaluru, Karnataka, 560038, IndiaImran Mirza (brother)+91 99860 11223
Lucas FernandesEMP-0004Growth MarketerMarketingContractActiveNeha Kapoor[email protected]+351 912 345 67830 Jan 199622 Jul 20260.3Rua Augusta 100, Lisbon, PortugalAna Fernandes (mother)+351 913 222 111
Meghna DasEMP-0005Finance AnalystFinanceFull-timeNotice periodArjun Mehta[email protected]+91 90070 8899012 Sep 199318 Feb 20215.8Salt Lake Sector V, Kolkata, West Bengal, 700091, IndiaRitu Das (sister)+91 90070 66554
Tom BeckerEMP-0006Support InternSupportInternActiveKavya Reddy[email protected]+49 151 2345 67898 Mar 20035 Oct 20260.1Torstraße 55, Berlin, 10119, GermanyKlaus Becker (father)+49 151 9876 5432
Field details
Full name · Text
Employee ID · Autonumber
Photo · Attachment
Job title · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Employment type · Single select
Full-time, Part-time, Contract, Intern
Status · Single select
Active, On leave, Notice period, Exited
Reporting manager · Text
Work email · Email
Phone · Phone
Date of birth · Date
Joining date · Date
Tenure (years) · Formula
IF({Joining date}, ROUND(DATETIME_DIFF(TODAY(), {Joining date}, 'days') / 365, 1), BLANK())
Home address · Address
Emergency contact · Text
Emergency phone · Phone
Documents · Attachment

Form view “Employee information” asks for: Full name, Photo, Job title, Department, Work email, Phone, Date of birth, Joining date, Home address, Emergency contact, Emergency phone, Documents.

Why each part of the base is there

Full name, Employee ID and Photo

Employee ID is an autonumber, so every new record gets the next ID without anyone keeping count. The photo makes the Faces gallery a quick way for a growing team to put names to faces.

Job title, Department, Employment type and Reporting manager

These answer who does what and who they report to. Department and Employment type are select fields, so the directory can be grouped or filtered, for example all contract staff in Operations.

Status

Active, On leave, Notice period or Exited. Keeping exits as a status instead of deleting rows preserves the record and lets the By status kanban show who is serving notice.

Work email, Phone and Home address

Contact details in typed fields: email and phone are validated, and the address field stores street, city, state, PIN code and country separately, which helps when you need to sort or filter by city.

Date of birth, Joining date and Tenure (years)

Tenure is calculated from the joining date and rounded to one decimal, so long-service milestones and probation periods can be spotted without manual maths. Date of birth supports birthday lists or age checks.

Emergency contact, Emergency phone and Documents

Who to call if something happens at work, kept with the employee record rather than in a separate file. Documents is an attachment field for copies such as ID proof, offer letters or certificates.

About the Employee Info Sheet template

This employee information sheet template is a single Employees table with seventeen fields. Each record has the employee's full name, an automatic employee ID (EMP-0001 onwards), a photo, job title, department, employment type, status and reporting manager. Contact details cover work email, phone and a structured home address, and personal details cover date of birth and joining date, from which a formula works out tenure in years. An emergency contact name and phone sit alongside an attachment field for documents. The table comes with five views: a Directory grid, a Faces gallery of photos, a By status kanban board, a Headcount dashboard and an Employee details form that employees can use to fill in or update their own information, with a note that HR keeps the record private.

Who it is for

It suits startups, small and mid-sized companies, schools, clinics, shops and agencies that keep employee records in Excel sheets or paper files and want one directory everyone in HR can work from. Indian HR teams can use it straight away: phone numbers carry +91 in the samples, addresses include the PIN code, and departments and employment types (full-time, part-time, contract, intern) match how most Indian companies classify staff. It is also a good base for HR to collect details from new joiners before their first day.

How to use it

  1. 1

    Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.

  2. 2

    Edit the Department, Employment type and Status options to match your organisation, and change the ID prefix if you do not want EMP.

  3. 3

    Delete the sample employees, then import your current staff list from Excel or CSV, or share the Employee details form and ask each employee to fill it in.

  4. 4

    Restrict who can open the base: give HR an editor role and others viewer or no access, because the table holds dates of birth, addresses and documents.

  5. 5

    Use the By status board to move people to On leave, Notice period or Exited, and the Headcount dashboard to see numbers by department and type.

Connected templates in other Edesy apps

Employee Info Sheet: frequently asked questions

Yes. The Employee details form asks for name, photo, job title, department, work email, phone, date of birth, joining date, home address, emergency contact and phone, and documents. Share its link; each submission creates a record in the Employees table.

Only add the people who need the records to the workspace, with viewer or commenter roles for anyone who should not edit. Share the form, not the table, with employees, and avoid sharing the Directory view by public link.

The template does not include those fields. You can add text fields for them, but check with your adviser how you collect and store that data, and keep the base restricted to HR.

Employee ID is an autonumber field with an EMP prefix and four-digit padding, so new records get EMP-0007, EMP-0008 and so on. Change the prefix or padding in the field settings.

Yes. Export the Employees table or any of its views as CSV or Excel (.xlsx), for example a filtered list of active employees in one department.

It records a status of On leave but not leave balances or daily attendance. Add a linked table for leave requests, or use the separate employee attendance tracker template for daily check-ins.

About the app

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates