Skip to content
ClientPlot
Get started

Free Customer Tracker Template

If you searched for a customer tracker or a customer tracker app template, use this page rather than the generic client tracker download. Need a spreadsheet? Download the free customer tracker. Need something easier to maintain? Import it into ClientPlot. This file uses the word customer because that is how many service businesses talk. Inside ClientPlot the same record is a client.

Want the software after the download? See the client tracker, or check the list you already keep.

Download ExcelDownload CSV

Free download. No signup required.

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

Outgrown the customer spreadsheet?

Import the same customer list into ClientPlot. Each customer becomes a client record with jobs, tasks and follow-up dates attached.

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

Import your customer tracker into ClientPlotSee 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.

Customer spreadsheet

  • Callbacks live in a date column
  • Job details in one person's phone
  • Quiet customers disappear in the grid
  • Site notes buried to the right

ClientPlot

  • A page per customer
  • Jobs connected to that customer
  • Tasks, due dates and follow-ups
  • Notes and files on the record

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.

Free Customer Tracker Template sample data
Customer IDCustomer NameCompanyContact NameEmailPhoneStatusServiceStart DateLast ContactNext Follow-UpPriorityCustomer ValueSourceNotes
2CU-001Metro DeliMetro DeliLuis Romerohello@metrodeli.example(555) 410-8801ActiveWalk-in cooler service2026-08-182026-08-212026-08-27High420Repeat ClientAfter close, 8pm. Rear alley.
3CU-002Ruiz ResidenceAna Ruizana@ruiz.example(555) 410-8802ActiveDeck staining2026-08-122026-08-202026-08-23Normal1800ReferralSide yard water shutoff. Friendly dog.
4CU-003Patel HouseholdDev Pateldev@patel.example(555) 410-8803LeadRoof leak inspection2026-08-222026-08-222026-08-26Urgent250WebsiteNorth slope above the kitchen.
5CU-004Cedar GoodsCedar GoodsKim Haleops@cedargoods.example(555) 410-8804On HoldLighting retrofit2026-08-012026-08-152026-09-02Normal2400NetworkingWaiting on LED cans from supplier.
6CU-005Beacon DentalBeacon DentalPriya Shahadmin@beacondental.example(555) 410-8805ActiveNew patient ads2026-08-102026-08-212026-08-28High1500WebsitePrefer email before 8am.
7CU-006Hale HVACHale HVACChris Halechris@halehvac.example(555) 410-8806CompletedOffice mini-split install2026-06-022026-07-20Low3800Repeat ClientQuote 4412. Finished in July.

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
6
Open Projects
6
Open Tasks
0
Follow-Ups Due
5
Waiting on Client
0
Upcoming Dates
5
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-08-23 · Deck staining · Ruiz Residence
  • 2026-08-26 · Roof leak inspection · Patel Household
  • 2026-08-27 · Walk-in cooler service · Metro Deli
  • 2026-08-28 · New patient ads · Beacon Dental
  • 2026-09-02 · Lighting retrofit · Cedar Goods
Upload my spreadsheet freePreview this template as a dashboard

What is in the template

Customer, contact, email, phone, status, last contact, next follow-up, current project (Service), value, and notes, plus Customer ID, Company, Start Date, Priority and Source. Dropdowns and overdue highlighting are in the Excel file. CSV has the same columns without formatting.

Customer ID

A short unique id for this customer.

Customer Name

The person or account you work with. ClientPlot imports this as a client.

Company

Business or household name.

Contact Name

Who you actually talk to.

Email

Email if you have one.

Phone

Best number to call back.

Status

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

Service

The current job or service.

Start Date

When this work began.

Last Contact

Last call, visit, or text.

Next Follow-Up

Callback or check-in date.

Priority

Low, Normal, High, or Urgent.

Customer Value

Typical job or retainer value.

Source

How this customer found you.

Notes

Site details, quotes, preferences.

Who it is for

Contractors, shops, and small service teams that have outgrown a notebook but are not trying to install a full CRM.

How to use it

  1. 1. One row per customer, not per invoice

    Repeat jobs stay on the same row. Put the current job in Service and update it when the next one starts.

  2. 2. Put callbacks in Next Follow-Up

    A quote you never called back on is a job you donated to a competitor.

  3. 3. Keep site notes in Notes

    Dogs, lockboxes, and side-gate instructions belong here, not in a group text.

  4. 4. Import when the sheet gets noisy

    Upload the same file into ClientPlot. Customer Name becomes a client record. Service becomes a project. Next Follow-Up shows up on the dashboard after you confirm the mapping.

What is a customer tracker?

A customer tracker is a list of the people and accounts you work with, plus the current job, status, last contact, and next follow-up. It is the same job as a client tracker. The word changes by industry, not the work.

What information should a customer tracker include?

Customer name, contact, email, phone, status, last contact, next follow-up, current project, value if you track it, and notes. That is enough to call someone back and know what is open.

How do I track customers in Excel?

One row per customer, not per invoice. Put the current job in Service, keep Next Follow-Up as a real date, and filter Status to Active when the list grows. Download this file if you want dropdowns and overdue highlighting already in place.

What is the difference between a customer tracker and a CRM?

A customer tracker is a working list of relationships and jobs. A CRM adds pipelines, campaigns, and automation. ClientPlot is the app alternative when the spreadsheet is the problem. It is not a CRM and it does not invoice.

When should I move from a spreadsheet to an app?

Move when callbacks live in voicemail, two people overwrite the same row, or you cannot see who went quiet. Check the file first, or import it into ClientPlot and keep using the same customer names.

When a spreadsheet starts becoming difficult

  • Callbacks live in voicemail
  • The job details are in one person's phone
  • You cannot see which customers have gone quiet
  • Quotes sit in a folder with no chase date

Customer pages with the job attached

ClientPlot stores the customer once and lets jobs and tasks hang off that record.

A calendar of scheduled work

Due dates and follow-ups show up on a calendar instead of a buried column.

Assignment that is visible

Who owns the customer or the job is a field you can work from, not a highlight color.

Frequently asked questions

Is a customer tracker the same as a client tracker?

Same idea, different language. ClientPlot is designed around client tracking, so a Customer Name column imports as a client record. Use this sheet if your business says customers and jobs.

Will ClientPlot start calling them clients?

Inside the app the record is a client. Your spreadsheet can keep saying Customer. The importer maps that column to the client name after you confirm it.

Can I track more than one job per customer?

In the spreadsheet, keep the current job on the row and move finished jobs to notes. In ClientPlot, add multiple projects under the same client.

Does this do invoicing?

No. It tracks who, what job, when, and the next callback. Attach invoices in whatever you already bill from.

Related resources