My Target Account Spreadsheet Is Always Out of Date. What to Do Instead

If this sounds familiar: someone spent an afternoon (or a weekend) building a proper target account list, thirty, fifty, a hundred companies, scored and prioritized. Three months later, half the list has been called into the ground, a chunk of it turned out to be a bad fit once someone actually looked closer, and nobody's added a single new company since the day it was built. This isn't a discipline problem. It's what happens to every list that's built once by hand.

Why it happens, mechanically

• Companies change faster than spreadsheets get updated. A company that raised a round, hired a relevant exec, or adopted a new tool six weeks ago is a different prospect than it was when the list was built, and nothing in a static spreadsheet reflects that.
• The list only ever gets smaller. Rows get worked and marked contacted or disqualified. Nobody's job is to add new rows, so the list shrinks toward zero instead of staying full.
• Refreshing it is unpleasant, manual work that competes with actual selling for the same hours, so it loses, every time, until the list is too thin to be useful and someone builds a new one from scratch.

What it actually costs

Two failure modes, both expensive: reps call companies that are no longer a fit (wasted calls, and worse, a bad first impression if the company's needs have moved on), or reps run out of list entirely and either go quiet or fall back to unscored, undifferentiated outreach, exactly the "top of funnel" approach an ICP-driven list was supposed to replace. See What to Do When You Run Out of Leads in Your CRM for that second failure mode specifically.

What actually fixes it

Option 1: schedule the refresh like a recurring task, not a hope

Put a real calendar block on it, weekly or biweekly, whoever owns the list spends thirty minutes re-checking top accounts for new signals and adding a handful of new candidates. Better than nothing, still competes with selling time indefinitely.

Option 2: separate "the list" from "the scoring"

Keep your ICP criteria as the source of truth, not the spreadsheet. Re-run the matching process (manually or otherwise) against that criteria periodically instead of treating the existing rows as permanent. This catches companies whose fit changed, not just ones that were never on the list.

Option 3: automate the parts that decay fastest

The two things that go stale, finding new lookalike candidates and re-scoring existing ones against fresh signals, are also the two most mechanical, repetitive parts of the process. That's the actual case for a tool that keeps doing this in the background: not that manual list-building doesn't work, it's that it doesn't stay working past the day you build it.

Either way, the fix isn't more willpower on the same spreadsheet. It's deciding whether refreshing the list is a recurring human task you'll actually protect time for, or a mechanical one worth automating.