A few years ago, I inherited a spreadsheet from someone who had left the company three months earlier. It had 412 rows. It had four tabs. One tab was hidden. The hidden tab was the one with the renewal dates.

I am not making that up.

The person who built it was smart. She had set up conditional formatting that turned cells red when a renewal got close. She had a column for the contract owner, a column for the counterparty, a column for the auto-renewal clause, and a column called “notes” that contained whole paragraphs of negotiation history.

It was, at that moment, the contract management system for a company with about 180 employees and roughly 600 active agreements. Not the backup. Not the tracker. The system.

That is the point I want to talk about. There is a specific moment when a spreadsheet stops being a list and becomes infrastructure. Most people miss it. The spreadsheet does not announce itself. It just keeps getting bigger.

How a spreadsheet becomes the system

Almost every contract management setup I have walked into started as a spreadsheet. That is not a failure. That is how things actually begin.

Someone gets handed contracts to track. They open Excel or Google Sheets. They make columns for the things that obviously matter: counterparty, start date, end date, value, owner. They paste in what they know. They tell two coworkers where the file lives. It works.

Then the spreadsheet starts doing more jobs. People add a column for the signed PDF link. Someone adds a tab for vendor contracts and another tab for customer contracts. A finance person adds a column for payment terms. Legal asks for a column for governing law. The notes column grows.

Six months in, the spreadsheet is no longer tracking the work. The spreadsheet is the work.

You can tell this has happened when three things are true:

• People ask the spreadsheet questions instead of asking each other.
• Decisions get made based on what the spreadsheet says.
• If the spreadsheet disappeared tomorrow, you would not know what to do.

That third one is the real test. If your spreadsheet is the only place where your renewal dates, notice deadlines, and contract owners actually live, then you do not have a tracker. You have a contract management system. It just happens to be made out of cells.

Why this happens to normal companies

This is not a sign that your company is behind. It is a sign that your company is normal.

Contracts pile up faster than anyone plans for. A 50-person company can sign 30 vendor agreements, 10 customer deals, and a dozen NDAs in a single quarter without anyone noticing the count. Nobody sits in a meeting and says, “We need a contract management system now.” They say, “Can someone keep track of these?”

The someone is usually an ops person, a paralegal, or a finance manager. They build the obvious tool, which is a spreadsheet. They do a fine job. Then they get promoted, or quit, or get pulled onto something else, and the spreadsheet keeps running.

The spreadsheet does not get worse on its own. The company gets bigger around it. New vendors. New customers. New regulators. New questions from the board that suddenly need contract data to answer. The spreadsheet was built for 80 rows of work and is now doing 600 rows of work. The structure was never designed for what it is now doing.

This is fine, by the way. A spreadsheet that is doing real contract management work is not embarrassing. It is just a stage. The question is whether you know which stage you are in.

The signs your spreadsheet is now the system

Here is the short test I run when someone asks me to look at their setup. If three or more of these are true, the spreadsheet is the system, not a tracker.

• More than one person edits it on a regular basis.
• People outside the original team rely on it for answers.
• It has more than five tabs, or any tab is hidden.
• The notes column contains real information that is not stored anywhere else.
• You cannot say with confidence which version is current.
• A renewal has been missed because of how the spreadsheet works.
• The original author no longer works at the company.
• The file is sent by email rather than opened from a shared location.

That last one tells you a lot. If the spreadsheet travels through email, you have already lost track of what is current. Every reply-all forks the system.

What “the system” actually means

When I say a spreadsheet has become a contract management system, I mean something specific. I mean it is now load-bearing. If it falls down, work stops.

That is not the same as saying it is bad. A load-bearing spreadsheet can run a small company for years. I have seen it. The risks are real, but they are manageable if you are honest about what you have.

Here is what changes when a spreadsheet becomes the system:

You need a backup story. Not a sticky note. A real one. Where is yesterday’s version? Where is last month’s?

You need an owner. One person whose job it is to keep the file accurate. Not “we all own it.” Somebody.

You need access rules. Who can edit. Who can only view. What happens when someone leaves.

You need a single source of truth for the contracts themselves. The spreadsheet is a tracker. The actual signed PDFs need to live somewhere consistent, and the spreadsheet needs to link to them.

You need a way to know what the spreadsheet does not know. Every spreadsheet has blind spots. The contract that someone signed without telling anyone. The amendment that lives in an email thread. The verbal extension. Pretend those do not exist and they will surprise you.

What to do this week

If you just realized your spreadsheet is the system, do not panic and do not buy software yet. Do these five things first.

1. Find every contract that is not in the spreadsheet. Walk around. Ask each department head what they signed in the last 12 months. You will find more than you expected. This alone is worth a week of work.

2. Lock down one current version. Pick the master file. Rename it. Put it in one location. Tell everyone the others are dead. Do not keep three copies for politeness.

3. Backfill four dates for every contract. Effective date, expiration date, renewal date, and the notice deadline. The notice deadline is the one people forget. If a contract auto-renews unless you give 60 days’ notice, the notice deadline is 60 days before the renewal date. That is the date you actually need to act on.

4. Set real reminders. Calendar invites, not just conditional formatting. Conditional formatting only fires when somebody opens the file. A calendar invite fires whether you remember or not. Set the reminder for the notice deadline, not the expiration date.

5. Assign an owner per contract. Not per category. Per contract. A name. If the person who owns the relationship is not the same person who tracks the dates, write both names down.

You can do all five of these inside the spreadsheet you already have. No new tool. No purchase order. Just an afternoon.

When software is actually needed

I am not against software. I use it. But the honest answer is that you need software later than most vendors say you do, and you need it sooner than most ops people admit.

Here is my rough line. You probably need a real contract management system when:

• You are tracking more than about 200 active contracts and the count is going up.
• More than three people regularly need to find a contract or check a date.
• You are getting audited, or your industry is about to be audited, and you need to produce contracts on request.
• Renewals have been missed. Not “almost missed.” Actually missed, with money or credibility on the line.
• Someone has asked you a question about contract data that you could not answer in under an hour.
• The notes column has become the only record of your negotiation history.

If two or more of those are true, you have outgrown the spreadsheet. You can keep using it. But you are paying a tax in lost time, missed dates, and small risks that compound. The tax is invisible until something breaks, which is the worst kind of tax.

The flip side: if you have 60 contracts, two people who know where everything is, and no renewal disasters in your history, you do not need software. You need a slightly better spreadsheet and a calendar.

What to remember

A spreadsheet is not a stopgap. For a lot of companies, it is the real system for a long time, and that is fine. The danger is not the spreadsheet itself. The danger is pretending the spreadsheet is something less than it is, and then being surprised when it breaks.

Treat it like infrastructure. Give it an owner. Back it up. Lock down a current version. Backfill the four dates. Set calendar reminders for notice deadlines.

Then, when you cross the line where a spreadsheet stops being enough, you will already have clean data to bring with you. The companies that struggle with software are not the ones with messy spreadsheets. They are the ones who never sat down and figured out what the spreadsheet was actually doing.

Your next action this week: open your contract spreadsheet, count the rows, and ask yourself the third question from the test up top. If the spreadsheet disappeared tomorrow, would you know what to do? If the answer is no, you have a system. Start treating it like one.

---

I’m Dave, and I write about contract management the way it actually works. No jargon, no sales pitch, just what I’ve learned from 15+ years of doing this job. If this was useful, stick around.