--- title: "Employee Directory" id: "38205" type: "page" slug: "employee-directory" published_at: "2026-11-11T15:01:21+00:00" modified_at: "2026-11-11T15:01:21+00:00" url: "https://wppool.dev/flextable/use-cases/employee-directory/" markdown_url: "https://wppool.dev/flextable/use-cases/employee-directory.md" --- For HR teams and people managers # Turn your HR spreadsheet into a staff directory everyone can actually use. Your employee data already lives in Google Sheets. FlexTable publishes it on your website or intranet as a searchable staff directory, a performance leaderboard and private employee records, and keeps every table in sync when the Sheet changes. [Try FlexTable Free](https://wordpress.org/plugins/sheets-to-wp-table-live-sync/) [See a live demo](https://demo.wppool.dev) Free on WordPress.orgNo coding30-day money-back guarantee Synced from **Employees 2026** · Google Sheets **Team performance · Q3**Search… AllDesignSalesEngineeringSupport | Employee | Department | Location | Q3 score | Status | | --- | --- | --- | --- | --- | | ACAva Chen | Design | Austin | 96 | Top performer | | LPLeo Park | Sales | Remote | 93 | Top performer | | MRMia Ross | Engineering | Berlin | 88 | On track | | SDSam Diaz | Support | Lisbon | 84 | On track | | NPNora Patel | Marketing | London | 79 | On track | Showing 1 to 5 of 86 employees*1**2**3* Sound familiar? ## HR data is easy to keep. It's hard to share. > Every time someone joins or leaves, I update the team page by hand. It's always a little out of date. The office manager > Our performance numbers live in a spreadsheet nobody outside HR ever sees. The HR lead > I can't publish salaries or leave balances where every employee can open them. People operations How it works ## From employee Sheet to live directory in three steps No HR software rollout, no developer. Keep working in the Sheet your team already uses. 1### Keep your people data in Google Sheets One row per employee: name, role, department, location, email, photo URL and any scores or KPIs you track. 2### Connect the Sheet in FlexTable Paste the Sheet URL, pick a theme, hide private columns and choose who sees what. 3### Publish it on your site or intranet Embed with a block, Elementor widget or shortcode. New hires, exits and score updates appear as soon as the Sheet changes. Staff directory ## A staff directory people can actually search Turn a long employee list into a directory that's quick to scan on any device. Visitors search by name, filter by department or location, and see photos and contact links pulled straight from the Sheet. - Search, sorting and pagination on the free plan - Department and location filters (single, multi-select or text) - Employee photos and mailto links from the Sheet - Hide columns on mobile so it stays readable **Staff directory**Search… All departmentsDesignSalesEngineering | Name | Role | Department | Email | | --- | --- | --- | --- | | ACAva Chen | Product Designer | Design | ava@company.com | | LPLeo Park | Account Executive | Sales | leo@company.com | | MRMia Ross | Backend Engineer | Engineering | mia@company.com | | SDSam Diaz | Support Lead | Support | sam@company.com | Showing 1 to 4 of 86 entries*1**2**3* User-Specific DisplayPro ## Each employee sees only their own record Publish one table, and FlexTable shows every logged-in employee only the rows that match their account. It's ideal for payslips, leave balances, attendance and appraisals. Visitors who aren't logged in get a login prompt or nothing at all. - Match rows by username, email address or employee name - The search box is removed, so nobody can browse other records - Custom login prompt with your own button and URL - Several matching rows? All of them are shown Signed in as **mia@company.com**Only your rows **My leave and payslips**Search… | Month | Days taken | Leave left | Payslip | | --- | --- | --- | --- | | September | 2 | 14 | View | | October | 1 | 13 | View | | November | 0 | 13 | View | Showing 3 of 3 entries*1**2**3* 85 other employees' rows are hidden from this user AI summaries and Q&APro ## Ask the table who's leading this quarter Add an AI summary above your performance table and an Ask AI box below it. Managers get the headline in a sentence and can ask follow-up questions in plain language. - Instant summary, saved or generated on click - Visitors ask questions like averages, top values and filters - Uses your own OpenAI or Google Gemini API key **Team performance · Q3**AI AI summaryAverage Q3 score is 86, up 4 points on Q2. Design and Sales lead the board; two Support team members improved by more than 10 points. Who has the highest score in Sales?Ask Leo Park, with a Q3 score of 93. He's also the top performer in Sales for the second quarter in a row. Runs on your own OpenAI or Google Gemini API key. Features that matter here ## Everything an HR table needs ### Always current Edit the Sheet and the directory updates. No re-uploads when people join, move or leave. ### Hide sensitive columns Pro Keep internal fields like salary or notes out of the published table, or hide them on specific devices. ### Protected and private views Pro Use User-Specific Display or Protected View for data that shouldn't be public. ### One tab per team or quarter Pro Show several Sheet tabs as one tabbed table: Q1, Q2, Q3 or one tab per office. ### Export for reviews Pro Let managers export to CSV, Excel or PDF, or print the table for review meetings. ### Works on every device Responsive layouts (collapsible or scrollable) keep wide HR tables readable on phones. Also used for Staff directoryTeam pagePerformance leaderboardLeave balancesPayslip lookupTraining recordsOnboarding checklistOffice contact list FlexTable Pro: MCP server ## Or just ask your AI assistant to build it. Connect Claude, ChatGPT (Codex), Cursor or VS Code to FlexTable through its MCP server. Describe the table you need, and your assistant syncs the Google Sheet, styles the table, manages its columns and publishes the page for you. Works withClaude DesktopClaude CodeChatGPT (Codex)CursorVS Code [See how to connect MCP](https://wppool.dev/docs/how-to-connect-ai-assistants-to-flextable-with-mcp-claude-chatgpt-cursor-more/) AI assistant · FlexTable MCP connected**• Connected** Create a staff directory from our "Employees 2026" Sheet, hide the Salary column, add a Department filter and publish it on the Team page. **Synced Google Sheet** “Employees 2026”, 86 rows **Hid column** Salary **Added filter** Department **Published page** /team/ Done. Your staff directory is live at /team/ and stays synced with the Sheet. Illustrative example of a FlexTable MCP session. FAQ ## Frequently asked questions Can I build a WordPress staff directory with FlexTable? Yes. Keep your employee list in Google Sheets, connect it to FlexTable and embed the table on any page. It's searchable, sortable and responsive, and it updates whenever the Sheet changes. Can each employee see only their own data? Yes, with User-Specific Display. FlexTable matches the logged-in WordPress user to a column in your Sheet by username, email address or employee name, and shows only their rows. Visitors who aren't logged in see a login prompt or no table. How do I keep salaries and other private data safe? Only publish what's needed. Hide internal columns, use User-Specific Display or Protected View, and for highly sensitive fields, keep them in a separate Sheet or tab that isn't connected to a public table. Can I show employee photos? Yes. Put an image URL in a column of your Sheet and FlexTable displays it as a picture in the table. Image import is a Pro feature. Do employees need WordPress accounts? Only for User-Specific Display, where FlexTable needs to know who is logged in. A public staff directory works without any logins. Is FlexTable free? Yes. The free plugin on WordPress.org includes live Google Sheets sync, unlimited tables and rows, search, sorting, pagination, responsive layouts, the Gutenberg block and shortcodes. Pro starts at $59 a year or $119 one-time and adds features like filters, conditional views, images and links, exports, AI summaries and the MCP server. Do I need to know how to code? No. You paste a Google Sheet URL, choose your settings and embed the table with the Gutenberg block, the Elementor widget or a shortcode. ## More ways teams use FlexTable [Student results and certificatesResult lookups, grade dashboards and certificate checks](https://wppool.dev/flextable/use-cases/student-results/) [Pricing tables and price listsPlans, rate cards and service menus that never go stale](https://wppool.dev/flextable/use-cases/pricing-tables/) [WooCommerce product tablesSearchable product lists with images, stock and Buy buttons](https://wppool.dev/flextable/use-cases/woocommerce-product-table/) [Client portals and order trackingPrivate status pages and order lookups for every client](https://wppool.dev/flextable/use-cases/client-portal/) ## Give your team a directory that keeps itself up to date. Connect your employee Sheet and publish a searchable directory in minutes. Free to start. [Try FlexTable Free](https://wordpress.org/plugins/sheets-to-wp-table-live-sync/) [View pricing](https://wppool.dev/flextable-pricing/)