Skip to content
ClientPlot
Get started

Free Client Tracker Template

Choose the simple Excel list for one working table, the full workbook for separate client, project and follow-up sheets, or CSV for a portable Google Sheets starting point. No account is required to download the files. Import the same data into ClientPlot only when you need a shared view of the work.

This page is the free client tracker template. If you want the software instead, use the client tracker app. Need the ready-formatted workbook with dropdowns? See the client tracker Excel template. For a contact-and-next-step workflow, see the client tracking spreadsheet. For named projects, download the project tracker template. New to the layout? Read how to track clients in Excel. To track tasks for multiple clients, use the client task tracker. If your business says customers, not clients, use the customer tracker template.

Download ExcelDownload CSV

Free download. No signup required.

Choose your format

Excel (.xlsx)

Download

Formatted table, dropdowns, frozen headers and overdue highlighting.

Download Excel

Google Sheets

Make a working copy

Download the CSV, then File, Import, Upload in Google Sheets. No extra account on our side.

CSV

Download

Portable client data without formulas. Use this for Sheets or any other tool.

Download CSV

Download the full workbook if you want clients, projects, follow-ups and a dashboard on separate tabs.

Outgrown the spreadsheet?

Your spreadsheet is a great place to start. When client details, projects, tasks and deadlines become harder to manage, import your existing data into ClientPlot.

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

Import your client trackerSee ClientPlot
  1. Spreadsheet rowsClient records
  2. Project columnProjects under that client
  3. Deadline columnDue dates on the work
  4. Next action / next taskTrackable tasks
  5. 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.

Spreadsheet

  • Client rows
  • Manual organization
  • Multiple tabs
  • Manual project tracking
  • Manual task tracking
  • Manual filtering
  • Easy to lose context

ClientPlot

  • Client records
  • Projects connected to clients
  • Tasks connected to work
  • Deadlines in context
  • Statuses
  • Search and filtering
  • One client workspace

Simple tracker preview

This is the simple Excel tracker: one row per client, with status, project, dates and follow-ups. Scroll sideways on a phone to see every column.

Free Client Tracker Template sample data
Client IDClient NameCompanyContact NameEmailPhoneStatusService / ProjectProject StatusStart DateDue DateLast ContactNext Follow-UpPriorityProject ValueSourceNotes
2C-001Acme CoAcme CoJordan Haleops@acme.example(555) 201-0101ActiveHomepage refreshIn Progress2026-08-042026-09-122026-08-202026-08-22High2400Repeat ClientMonthly retainer. Prefers email, not Slack.
3C-002Smith LLCSmith LLCRiley Smithhello@smithllc.example(555) 201-0102ActivePhoto shoot packageWaiting2026-08-112026-08-242026-08-182026-08-29Normal1800ReferralQuote sent 8/12. Waiting on signed proposal.
4C-003Jones CoJones CoPriya Jonespriya@jonesco.example(555) 201-0103On HoldIdentity systemNot Started2026-07-282026-09-182026-08-152026-09-02High3200WebsitePaused while they finish hiring a marketing lead.
5C-004Harbor ClinicHarbor ClinicAlex Chenadmin@harborclinic.example(555) 201-0104ActivePatient intake pageIn Progress2026-08-082026-08-262026-08-212026-08-25Urgent1500NetworkingMust match language they already use.
6C-005Bright LabsBright LabsSam Ortizteam@brightlabs.example(555) 201-0105LeadOnboarding micrositeNot Started2026-08-182026-09-202026-08-262026-09-01High4100WebsiteNew client. Kickoff not scheduled yet.
7C-006Mesa GoodsMesa GoodsSam Mesasam@mesagoods.example(555) 201-0106InactiveCatalog refreshCompleted2026-05-022026-07-152026-07-10Low900Repeat ClientPaused in July. Warm relationship. Check in after busy season.

What this tracker 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
6
Open Projects
6
Open Tasks
0
Follow-Ups Due
5
Waiting on Client
0
Upcoming Dates
6
Project StatusCount
Planning
0
In Progress
6
Waiting on Client
0
On Hold
0
Completed
0

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 freePreview this template as a dashboard

What information should a client tracker include?

The simple Excel file is one formatted table: client id, client name, company, contact, email, phone, status, service/project, project status, dates, priority, value, source and notes. The full workbook adds separate CLIENTS, PROJECTS, FOLLOW-UPS and DASHBOARD tabs. CSV is the core client columns only.

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

Freelancers, consultants and small teams who want a working client list today, without signing up for software first.

How to use it

  1. 1. Download the file you need

    Use Simple Client Tracker for one list. Use the full workbook if you want clients, projects, follow-ups and a dashboard. Use CSV if you only need portable data.

  2. 2. Add one row per client

    Fill Client Name, Status, and Next Follow-Up at minimum. Status dropdowns are Lead, Active, On Hold, Completed and Inactive.

  3. 3. Filter and watch overdue dates

    Filter arrows are already on. Next Follow-Up and Due Date cells turn red when they are past today and the work is still open.

  4. 4. Import only when you need a shared workflow

    Upload the same file at clientplot.com/import. Review the clients, projects and follow-ups found and confirm the field mapping before anything is saved.

When a spreadsheet starts becoming difficult

  • Too many rows to scan before coffee
  • Missed follow-ups because a date sat quietly in a cell
  • Hard to see what is due today
  • Multiple people editing and overwriting cells
  • Constant filtering to find waiting work
  • Important notes buried at column Q
  • No clean daily view

A page per client

Contact details, notes, tasks, and files live together instead of stretching sideways across a row.

Follow-ups on the dashboard

Next follow-up dates appear on today's view next to due tasks, so check-ins are part of the workday.

Due work in one list

Open projects, tasks, and waiting items group by client so you stop hunting through filters.

Frequently asked questions

Is this client tracker really free?

Yes. Download the Excel or CSV files and use them. No signup and no email wall.

Does it work in Microsoft Excel?

Yes. The .xlsx files are built for modern Excel: formatted tables, frozen headers, filter arrows, dropdowns and overdue highlighting.

Can I use it with Google Sheets?

Yes for the CSV. Google Sheets can also open the XLSX. Dropdowns and highlighting are most reliable in Excel.

What is the difference between the simple file and the full workbook?

The simple file is one client list. The full workbook has a START HERE tab, CLIENTS, PROJECTS, FOLLOW-UPS and a DASHBOARD. Use simple if you want one sheet. Use full if projects and follow-ups need their own tabs.

Can I add more columns?

Yes. Insert columns as you would in any Excel table. Extra columns stay in the file. If you import into ClientPlot, unmapped columns are kept in notes.

How do I track client follow-ups in Excel?

Put the next date in Next Follow-Up. Filter or sort that column each morning. Cells turn red when the date is past and the client is still active.

How do I track active and inactive clients?

Use the Status dropdown. Filter to Active when the list grows. Leave Completed and Inactive rows in place so you keep history.

Can I import it into ClientPlot?

Yes. Upload the file, pick the client sheet, and confirm the suggested mapping for Client Name, Status, Project, Due Date and Next Follow-Up before anything is saved.

Related resources