Maintain a clean, searchable employee directory that your team can access from a single link. This template stores essential employee information: name, job title, department, email, phone, office location, and start date. It is particularly useful for growing companies that do not yet have an HRIS but need a centralized place for contact information. The spreadsheet format makes it easy to search, sort by department, and export for onboarding packets or org chart tools. When integrated with the API, you can sync the directory with your identity provider (Okta, Google Workspace) so it stays up to date as people join and leave. New hires get added automatically, and departures get flagged or removed. Share a read-only link company-wide so anyone can look up a colleague without pinging HR.
| Full Name | Title | Department | Phone | Office | Start Date | |
|---|---|---|---|---|---|---|
| Natalie Reeves | VP of Engineering | Engineering | natalie@example.com | (415) 555-0134 | San Francisco | 2022-06-15 |
| Derek Yamamoto | Product Designer | Design | derek@example.com | (212) 555-0187 | New York | 2023-09-04 |
| Fatima Al-Hassan | Data Analyst | Analytics | fatima@example.com | (512) 555-0221 | Austin | 2024-01-22 |
| Carlos Mendez | Account Executive | Sales | carlos@example.com | (305) 555-0098 | Miami | 2025-03-10 |
Generate this employee directory programmatically with a single POST request. The API returns a shareable URL that anyone can open in the browser.
curl -X POST https://openofficeai.com/api/v1/sheets \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"title": "My Employee Directory",
"sheets": [{ "rows": [["Full Name","Title","Department","Email","Phone","Office","Start Date"],["Natalie Reeves","VP of Engineering","Engineering","natalie@example.com","(415) 555-0134","San Francisco","2022-06-15"],["Derek Yamamoto","Product Designer","Design","derek@example.com","(212) 555-0187","New York","2023-09-04"]] }]
}'Returns { "id": "...", "url": "...", "created_at": "..." }. See the full API docs for formatting, formulas, and export options.
This template comes with 7 columns designed for a standard employee directory workflow. Each column can be renamed, reordered, or extended through the API or the browser editor.
The employee first and last name.
The official job title or role within the company.
The team or department the employee belongs to.
The work email address.
The work or mobile phone number.
The office location or city where the employee is based.
The date the employee joined the company.
This template is a starting point. Here are specific ways to adapt it to your workflow:
Add a "Manager" column that references another employee name, enabling you to build an org chart from the spreadsheet data.
Include a "Skills" column with comma-separated tags so team leads can quickly find colleagues with specific expertise.
Add a "Pronouns" and "Time Zone" column to support distributed teams and inclusive communication.
Set up a nightly sync script that pulls employee data from your HRIS or identity provider, compares it with the current spreadsheet, and sends a PUT request to add, update, or remove rows. This ensures the directory is always current without anyone manually editing it.
The sharing model is per-document, not per-column, so you cannot hide specific columns from certain viewers. If phone numbers are sensitive, create two versions of the directory: a full version for HR and a public version without the Phone column for company-wide sharing.
No practical limit for a typical organization. Spreadsheets with up to 10,000 rows load quickly in the browser. For companies with thousands of employees, the spreadsheet will work fine, though you might want to paginate or split by department for easier navigation.
Manage your sales pipeline with a lightweight CRM spreadsheet that tracks leads, deal stages, and ex...
Track your product inventory with a spreadsheet that shows stock levels, reorder points, and supplie...
A straightforward task list for tracking to-dos with priorities and deadlines. Unlike a full project...
Sign up for free and start building spreadsheets in seconds — from the browser or via the API.