If you have a company it could be hard to find each employee. Would be nice to have an employee directory by their photo, a phone number, and email. As well as department, location, position, etc.
This directory should be updated constantly because some of the employee and leaving the company and new join the company.
The easiest way to create an employee directory is using Excel or Google Sheets because you are already familiar with this software and it's made exactly for creating structured information.
You can do it even without SharePoint if you want.
In the end of this article we will give you a code snippet that you can try in your SharePoint.
You can create an entire database of all your employees. Here is what information each employee should have
Sheet2Site has an Employee Directory Template that has all these fields and you can change any of them depending on your company needs.
You easily change your employee directory with different font and colors.
Also, you can remove some information that you don't need. For example, you might not need a bio or seniority.
It's easy to remove them, you just delete a column. Also, you might need to add some other columns like a year when a person joined the company.
Another small detailed that you might want to do is to make each photo in black and white style rather than color to make look more professional.
If you have many employees you might want to filter them by a location, department, position. Sheet2Site has a multi-filter functionality that allows you to filter employees by Location and Department.
For example, you want to see only employees that work in the San Francisco office in the Legal department with seniority level Senior.
How about if you want to search for an employee by the name? Sheet2Site has a searching functionality that allows you to search non only by a name but also by any field such as department location or a position.
You can put all detailed information such a bio, contacts about each team member to a detailed page:
There are 2 most common use cases how you can use your team directory:
One of the easiest ways to make your website looks more trustworthy is to add a team page to your website and show all your team members
Much likely you want to make your staff directory private so only your employees can log in to this website. Sheet2Site supports password protection so only employees who have the company's email and know a password can log in the website.
You can connect your employee directory to a subdomain such as employees.example.com or a page example.com/employees
Many of your employees might want to find their team makes from their mobile phones. Sheet2Site employee directory can is optimized for mobile with a nice responsive design.
Please take a look on this demo of team page employee directory that was made only using Google Sheets:
You can start creating your Employee Team Directory now by sign-up here:
Explore Employee Directory Website Examples that were Made by People using Sheet2Site
If you need any help with creating employee directory please message me in the chat in the right corner and I will be happy to help you.