How to Track Employee Goals in Google Sheets

Performance management software costs $5 to $15 per employee per month. For a team of 20, that’s $1,200 to $3,600 per year. The tool stores goals and tracks progress. At review time, it generates a report. But there’s a frugal option that’s worth consideration. A Google Sheet does all of that for free.

The tradeoff is manual setup. You build the tracker yourself and maintain it. For teams under 50 people, that tradeoff works. You spend a few hours upfront instead of a few thousand dollars annually. And you keep full control over the format and the data.

Dedicated platforms like Lattice, 15Five, and BambooHR make sense when you have 100+ employees and a full HR team managing the system. Below that threshold, a shared Google Sheet does the job.

Setting Up Individual Goal Trackers

Start with the goal tracker template. Open it, make a copy, and rename it for the employee.

The template has two working areas: the Goal Setup tab and the Dashboard tab. The Goal Setup tab is where you define what the employee is working toward. The Dashboard tab pulls from that data and shows progress automatically.

Configuring the Goal Setup Tab

Each row in the Goal Setup tab represents one goal. Fill in these columns for each:

Goal name. Keep it specific. “Close 40 deals this quarter” is useful. “Improve sales performance” is not. If you need a framework for writing better goal statements, the SMART goals template walks through the criteria.

Target value. The number the employee needs to hit. This could be 40 deals, 3 certifications, $100,000 in revenue, or a ticket resolution time under 4 hours.

Current value. Updated during check-ins. This is the number that drives the progress calculation.

Start and end dates. Define the time window. Most employee goals align with a quarter, but the template handles any date range.

Notes. Use this column during 1-on-1 meetings to log blockers and context. It becomes the running record of the conversation around each goal.

Reading the Dashboard

The Dashboard tab calculates pace status automatically. It compares where the employee should be (based on elapsed time) against where they actually are (based on current value). The result is one of three statuses: ahead of pace, on pace, or behind pace.

This is the tab you pull up in a 1-on-1. It gives you the full picture in seconds.

Scaling to a Full Team

One tracker per employee works fine. The question is how you organize them. There are two approaches, and the right one depends on how your team handles privacy.

Option 1: One File Per Employee

Create a separate Google Sheet for each person. Share it between the manager and the employee only. Nobody else sees it.

This works well when goals include sensitive targets like performance improvement plans or compensation-linked metrics. It also keeps things simple. Each person has one file and one link.

The downside is management overhead. If you have 15 direct reports, you have 15 separate files to open during review season.

Option 2: One Master Spreadsheet With Tabs

Create a single Google Sheet. Give each employee their own tab. The manager sees everything in one file.

This is faster for the manager. You open one spreadsheet and click between tabs during back-to-back 1-on-1s. You can also build a summary tab that pulls pace status from every employee tab into one view.

The downside is privacy. Google Sheets doesn’t support tab-level permissions. If you share the file, everyone with access can see every tab. You can work around this by sharing the file only with the manager and screen-sharing the relevant tab during meetings. But if employees need direct access to update their own progress, the one-file-per-person model is cleaner.

Which to Choose

Teams under 10 with goals that aren’t sensitive: use the master spreadsheet. It saves time and keeps everything visible.

Teams of 10 or more, or any team with sensitive goals: use individual files. The extra clicks are worth the privacy.

Running Goal Check-Ins

The spreadsheet isn’t a set-it-and-forget-it tool. It works because you use it in every 1-on-1.

The whole thing takes about five minutes per employee.

Pull up the Dashboard tab. Share your screen or open it on a shared monitor. Both of you should be looking at the same data.

Review pace status for each goal. Green means ahead. Yellow means on pace. Red means behind. Start with anything red.

Update the current value. If the employee has new numbers since the last check-in, enter them now. The dashboard recalculates immediately.

Discuss blockers. For any goal that’s behind pace, ask what changed. Log the answer in the Notes column. This creates a record that matters at review time.

Adjust targets if needed. Business conditions change. If a product launch got delayed or a key client churned, the original target might not make sense anymore. Change it in the Goal Setup tab and note why. A revised target with context is more useful than an outdated target with a red status.

The Notes column is the most underrated part of this system. Three months from now, when you’re writing a performance review, those notes are the difference between “I think they struggled in Q2” and “They lost their largest account in April, adjusted their pipeline strategy, and recovered by June.”

Connecting Employee Goals to Business Goals

Individual goals shouldn’t exist in isolation. They need to connect to something bigger. If an employee hits every target but the team misses its number, the goals were wrong.

The math is straightforward. Start with the company or team goal for the quarter. Break it into individual contributions.

Example: The company goal is $500,000 in Q2 revenue. You have five salespeople. Each one gets a $100,000 individual target. That target goes into their goal tracker as a specific, measurable row.

If you use the OKR framework, the company objective sits at the top and each employee’s key results are the rows in their individual tracker. The spreadsheet makes the relationship between the two visible. When a salesperson is at $60,000 by mid-quarter, you can see exactly what that means for the company number.

For non-revenue goals, the same logic applies. If the engineering team’s quarterly goal is “ship the new onboarding flow,” individual goals might be “complete API integration by week 4” and “finish QA testing by week 6.” Each person’s tracker shows whether the team goal is on track.

If you’re using project management templates for the execution side, the goal tracker handles the accountability side. They complement each other.

Performance Review Season

Review season is where the spreadsheet pays off. Instead of scrambling to remember what happened over the last six months, you have data.

Open the employee’s goal tracker. Look at the Dashboard tab for each quarter. The pace status and final values tell the story. The Notes column fills in the context.

For a formal review document, export the dashboard as a PDF or take screenshots. Include the data alongside your written evaluation. The combination of specific numbers and your narrative assessment is stronger than either one alone.

Two to four quarters of goal tracker data gives you enough to identify patterns. An employee who consistently hits revenue targets but misses development goals needs a different conversation than one who struggles across the board. The data makes that distinction clear without relying on memory.

If your review process includes self-assessments, give employees access to their tracker before the review. Let them write their self-assessment using the same data you’re using. The conversation that follows is grounded in shared facts, not competing recollections.

Tips for Making the System Stick

The most common failure mode is the habit, not the spreadsheet. People set up goals in January and never open the file again until December.

Three things prevent that:

Update the tracker in the meeting, not after. If you tell yourself you’ll update it later, you won’t. Open it during the 1-on-1 and make changes in real time.

Keep goals to three to five per employee per quarter. More than five and the tracker becomes a to-do list. Fewer than three and it’s probably missing something important. The task list template is a better fit for day-to-day action items. The goal tracker is for outcomes.

Review and reset quarterly. At the end of each quarter, archive the current goals (duplicate the tab or save a copy) and set new ones. This keeps the tracker fresh and gives you a clean historical record.