Client Tracker Excel Template

Download a free client tracker Excel template. The .xlsx file is ready to use: formatted table, frozen headers, filter arrows, status dropdowns and overdue highlighting. No signup required.

Walk through how to track clients in Excel, then download this file. If the work is a pile of verbs instead of one row per client, use the client task tracker. You can also check an existing spreadsheet or build a custom tracker.

Download Excel Download CSV

Free download. No signup required.

No signup required. Excel includes the extra formatting. CSV is portable data only.

Outgrown the Excel tracker?

Keep the workbook as a backup. Import the same columns into ClientPlot and work from a client dashboard instead of a filter view.

Free to preview. No credit card. Create an account only when you want to save your dashboard.

Import your Excel client tracker See ClientPlot

Spreadsheet rowsClient records
Project columnProjects under that client
Deadline columnDue dates on the work
Next action / next taskTrackable tasks
Client notesNotes on the client page

Official ClientPlot templates skip the mapping quiz. ClientPlot counts what it found, then you import. Unusual spreadsheets still get a mapping review.

Excel tracker

Manual sorting every morning
One row has to hold the whole relationship
Easy to overwrite shared cells
Hard to see one client's full history

ClientPlot

Client records you can open
Projects under each client
Tasks and deadlines on Today
Search across notes and history

Template preview

Sample rows so you can see what you will download. Scroll sideways on a phone if the table is wider than the screen.

Client Tracker Excel Template sample data
	Client ID	Client Name	Company	Contact Name	Email	Phone	Status	Service / Project	Project Status	Start Date	Due Date	Last Contact	Next Follow-Up	Priority	Project Value	Source	Notes
2	C-001	Acme Co	Acme Co	Jordan Hale	ops@acme.example	(555) 201-0101	Active	Homepage refresh	In Progress	2026-08-04	2026-09-12	2026-08-20	2026-08-22	High	2400	Repeat Client	Monthly retainer. Prefers email, not Slack.
3	C-002	Smith LLC	Smith LLC	Riley Smith	hello@smithllc.example	(555) 201-0102	Active	Photo shoot package	Waiting	2026-08-11	2026-08-24	2026-08-18	2026-08-29	Normal	1800	Referral	Quote sent 8/12. Waiting on signed proposal.
4	C-003	Jones Co	Jones Co	Priya Jones	priya@jonesco.example	(555) 201-0103	On Hold	Identity system	Not Started	2026-07-28	2026-09-18	2026-08-15	2026-09-02	High	3200	Website	Paused while they finish hiring a marketing lead.
5	C-004	Harbor Clinic	Harbor Clinic	Alex Chen	admin@harborclinic.example	(555) 201-0104	Active	Patient intake page	In Progress	2026-08-08	2026-08-26	2026-08-21	2026-08-25	Urgent	1500	Networking	Must match language they already use.
6	C-005	Bright Labs	Bright Labs	Sam Ortiz	team@brightlabs.example	(555) 201-0105	Lead	Onboarding microsite	Not Started	2026-08-18	2026-09-20	2026-08-26	2026-09-01	High	4100	Website	New client. Kickoff not scheduled yet.
7	C-006	Mesa Goods	Mesa Goods	Sam Mesa	sam@mesagoods.example	(555) 201-0106	Inactive	Catalog refresh	Completed	2026-05-02	2026-07-15	2026-07-10		Low	900	Repeat Client	Paused in July. Warm relationship. Check in after busy season.

What this spreadsheet looks like in ClientPlot

Upload your spreadsheet and ClientPlot turns the rows into clients, projects, tasks, deadlines and follow-ups on a live dashboard. Preview it before signup. Create a free account only if you want to save it. No credit card.

Dashboard preview

This replaces a formula Dashboard tab. Counts stay current after you import. Invoice totals and hours stay in the spreadsheet if you track them there.

MetricCurrent

Active Clients

Open Projects

Open Tasks

Follow-Ups Due

Waiting on Client

Upcoming Dates

Project StatusCount

Planning

In Progress

Waiting on Client

On Hold

Completed

Operational notes

After import, these counts stay current as you work. Invoice totals and hours stay in the spreadsheet if you track them there.

ClientOpen work

Clients with open work show here after import.

Upcoming schedule

2026-07-15 · Catalog refresh · Mesa Goods
2026-08-22 · Homepage refresh · Acme Co
2026-08-25 · Patient intake page · Harbor Clinic
2026-08-29 · Photo shoot package · Smith LLC
2026-09-01 · Onboarding microsite · Bright Labs
2026-09-02 · Identity system · Jones Co

Upload my spreadsheet free Preview this template as a dashboard

What is in the template

Client ID, Client Name, Company, Contact Name, Email, Phone, Status, Service / Project, Project Status, Start Date, Due Date, Last Contact, Next Follow-Up, Priority, Project Value, Source and Notes. Sample rows plus empty rows ready for your names.

Client ID

A short unique id so you can talk about a row without using the name.

Client Name

The person or account you work with. Required if you later import this file.

Company

The business name if it is different from the client.

Contact Name

Who you actually talk to, if that is not the client name.

Email

Primary contact email.

Phone

Best number for a quick call.

Status

Lead, Active, On Hold, Completed, or Inactive.

Service / Project

The current piece of named work under this client.

Project Status

Not Started, In Progress, Waiting, or Completed.

Start Date

When this work began.

Due Date

When the current project or deliverable is due.

Last Contact

Date of the last real conversation.

Next Follow-Up

The next date you should reach out.

Priority

Low, Normal, High, or Urgent.

Project Value

Optional fee, retainer, or job value.

Source

How this client found you.

Notes

Context your future self will need.

Who it is for

People who searched for an Excel client tracker because Excel is already open. Freelancers, consultants and small offices who want a real workbook, not a screenshot.

How to use it

1. Download the XLSX
Use the button above. Open it in Microsoft Excel. The header row is frozen and every column has a filter arrow.
2. Use the status dropdowns
Status is Lead, Active, On Hold, Completed or Inactive. Project Status is Not Started, In Progress, Waiting or Completed. Priority and Source are lists too.
3. Track follow-ups and deadlines
Put dates in Next Follow-Up and Due Date. Those cells turn red when they are past today and the client or project is still open.
4. Filter active clients
Open the Status filter and keep Active. Leave Completed and Inactive rows in the sheet so you still have history.
5. Import the same file later
When Excel maintenance is the job, upload this workbook in ClientPlot and confirm the suggested column mapping.

When a spreadsheet starts becoming difficult

A workbook with one tab per client that nobody wants to open
Filter views that break when a new column is inserted
Shared Excel files that overwrite each other's edits
Dates stored as text so sort order is wrong
No good way to see today's work without building another sheet

Keep Excel until you outgrow it

This template is a complete Excel tracker. ClientPlot is optional, and importing does not delete your file.

Columns that map cleanly

Client Name, Project, Deadline and Next Follow-Up are names ClientPlot already recognizes, so you are not rebuilding the sheet to switch.

A dashboard instead of a filter

When sorting every morning feels like the job, import the workbook and use the Today view.

Frequently asked questions

Is this client tracker really free?

Yes. The Excel download does not require an account or an email address.

Does it work in Microsoft Excel?

Yes. It is a .xlsx workbook with a table, frozen headers, filters, dropdowns and conditional formatting. No macros.

Can I use it with Google Sheets?

You can open it in Google Sheets. Dropdowns and highlighting are most reliable in Excel. A CSV is on the main template page if you want a simpler import into Sheets.

Can I add more columns?

Yes. Insert columns in the table as you would in any Excel file.

How do I track client follow-ups in Excel?

Fill Next Follow-Up, then sort or filter that column. Overdue dates highlight when the client is not Inactive or Completed.

How do I track active and inactive clients?

Use the Status dropdown and filter to Active. Keep inactive rows for history.

How does conditional formatting work?

Next Follow-Up turns red when the date is before today and the client is still open. Due Date turns red when the date is before today and Project Status is not Completed.

Can I import it into ClientPlot?

Yes. Upload the .xlsx, confirm Client Name, Status, Service / Project, Due Date and Next Follow-Up, then save. Your original file stays on your computer.