And most importantly, a list of the Employees at each location lets you track who is where.Įmployees and Locations are linked together using a Related row column, so when you view a location, you’ll see a list of all the employees that work there. Images of each office can be attached in the appropriate column, to help when visiting other offices. The Locations worksheet lists the location of each of your offices, with City, State, Country, and Postal Code, in addition to the Street Address.
Additional columns may be added at will for any other relevant information. Selectable columns for Department and Location make it easy to sort or filter when necessary-see the Department view in the drop-down in the upper left.
Attach a Photo right in the spreadsheet so you can recognize your employees on sight or recall who you spoke to in the hall.
The Employees worksheet lists each employee's Name, along with their Title and Email address. This basic employee directory template has two worksheets.
