I need to say something that might surprise you, coming from a guy who writes about contract management software for a living: your spreadsheet is probably fine.

If you have 30 contracts, a decent Excel tracker, and the discipline to open it every Monday morning, you’re doing better than a lot of people I’ve met who spent $80,000 on a CLM platform and never finished onboarding. I’m not going to sit here and tell you that you need dedicated software to manage a few dozen agreements. I managed contracts on spreadsheets for years before I switched. Some of those years were perfectly fine.

But some of those years were a disaster, and the line between “fine” and “disaster” is thinner than most people realize. So here’s what I’ve actually learned about when a spreadsheet works, when it doesn’t, and how to know when you’ve crossed the line.

The Spreadsheet Was Genuinely Good (for a While)

My first real contracts role, I inherited a tracker that someone in legal had put together in Excel. It had tabs for active contracts, a renewal calendar with conditional formatting that turned cells red when dates were within 90 days, and a column for “notes” that was mostly empty. It worked. For about 18 months, it worked.

I could sort by vendor. I could filter by department. I could pull up a renewal coming due next month in about ten seconds. The whole company had maybe 60 active contracts. I knew most of them by heart. The spreadsheet was really just a backup for what I already had in my head.

Here’s what made it work: one person owned it (me), the volume was low, and nobody else needed to touch it. The second any of those three things changed, the spreadsheet started to break down. Not dramatically. Not all at once. Just slowly, in ways I didn’t notice until it was too late.

Where Spreadsheets Actually Break

There’s an uncomfortable body of research about spreadsheet errors that most people in our field have never seen. Raymond Panko at the University of Hawaii has been studying spreadsheet errors for decades, and the findings are consistent: audits of real-world spreadsheets since the mid-1990s have found errors in approximately 88% of them. Not 88% of sloppy spreadsheets. 88% of spreadsheets, period.

The cell-level error rate runs between 1% and 5%, which sounds low until you think about what it means in practice. A contract tracker with 200 rows and 10 columns has 2,000 cells. At a 2% error rate, that’s 40 cells with something wrong. Maybe a date is off by a month. Maybe a dollar amount got transposed. Maybe someone deleted a formula and typed over it with a static number. Each one of those is a potential missed renewal, a wrong termination date, or a payment amount that doesn’t match the agreement.

The part of Panko’s research that really got me, though, was the overconfidence finding. When developers were asked to estimate the probability that their spreadsheet contained an error, the average guess was 18%. The actual rate was 86%. We think our spreadsheets are clean. They’re not.

And this isn’t just academic. The European Spreadsheet Risks Interest Group has catalogued real-world spreadsheet disasters for over two decades. JP Morgan’s “London Whale” trading loss, which hit $6.2 billion, was traced partly to a VaR model that operated through a series of Excel spreadsheets requiring manual copy-and-paste between files. Fidelity once misstated a fund distribution by $2.6 billion because an accountant omitted a minus sign when transferring data into a separate spreadsheet. These are extreme cases, obviously. But the mechanism is the same one that hits contract trackers: manual data entry, no version control, no audit trail, and no automated checks.

The Five Warning Signs I Missed

Looking back, the spreadsheet started failing long before I admitted it. Here’s what I should have noticed:

More than one person needed to update it. The moment my colleague in procurement started adding her vendor contracts to my tracker, we had two people editing the same file. Version conflicts. Overwritten formulas. Rows that appeared and disappeared depending on who saved last. We tried SharePoint. We tried naming conventions (“contracts_tracker_v4_FINAL_actualfinal”). You know how that goes.

The volume crossed 100. Somewhere around 100 contracts, scrolling stops working as a search strategy. I started spending real time just finding things. A 2023 ACC/Exterro report found that 65% of legal departments now use contract management software, up 14 percentage points in just two years. That surge isn’t because CLM vendors got better at marketing. It’s because people hit a wall with their spreadsheets and went looking for something else.

I couldn’t trust the dates. Renewal alerts in a spreadsheet are conditional formatting. They only work if the dates are correct, and the dates are only correct if someone entered them right. I caught two wrong expiration dates in one quarter. Both were data entry errors. One of them almost cost us an auto-renewal on a contract we wanted to renegotiate.

Auditors started asking questions. When internal audit wanted to see our contract records, I had to explain that our “system” was a spreadsheet on a shared drive. The look I got was not encouraging. There’s no access log, no change history, no way to prove who modified what and when.

I was the single point of failure. If I got hit by a bus (the standard contracts manager hypothetical), nobody else could have made sense of my tracker. The tabs, the color coding, the formulas, the notes column full of cryptic abbreviations. It was organized for my brain, not for the organization.

When a Spreadsheet Is Still the Right Call

I’m not one of those people who thinks everyone needs to run out and buy software. If the following things are true, keep your spreadsheet:

You have fewer than 50 contracts. One person is responsible for maintaining the tracker. You don’t have compliance or audit requirements that demand an access trail. And you actually open the spreadsheet regularly, not once a quarter when someone asks you for something.

Plenty of small businesses and early-stage companies fit that description. A good spreadsheet, maintained by someone who cares about it, beats an unused CLM platform every time. The worst contract management system is the one nobody logs into. I’ve seen six-figure implementations gather dust because the rollout was too complicated and people went back to emailing PDFs. At least a spreadsheet gets opened.

When It’s Time to Switch

The switch isn’t about reaching a magic number. It’s about recognizing when the spreadsheet is creating more work than it saves. For me, the tipping point was when I realized I was spending more time maintaining the tracker than actually managing contracts. Fixing broken formulas, reconciling duplicate entries, manually sending reminder emails because conditional formatting doesn’t actually email anyone.

When I moved to ContractSafe, the thing that surprised me most wasn’t the features. It was the time I got back. Contracts go in, OCR makes them searchable, dates get extracted, and alerts go out automatically. I didn’t have to build any of that. I didn’t have to maintain any of that. I just had to use it.

The setup took less than a day. That part still kind of amazes me, because I’d been telling myself for months that migrating off the spreadsheet would be this massive project. It wasn’t. I exported my tracker, imported the files, and spent the rest of the afternoon spot-checking that everything landed correctly.

The Question Nobody Asks

The real question isn’t “spreadsheet or software.” It’s “what am I actually risking by staying on the spreadsheet?” When the answer is “not much, honestly,” stay on the spreadsheet. When the answer starts to involve missed renewals, audit exposure, version conflicts, or the fact that your entire contract history lives in one person’s head, it’s time to move.

I waited too long, personally. I kept patching the spreadsheet, adding more tabs, more conditional formatting, more workarounds. Every patch made me feel like I’d solved the problem, when really I was just adding complexity to a tool that was never designed for what I was asking it to do.

Excel is an incredible program. I still use it every day for a dozen things. Managing a growing contract portfolio just isn’t one of them anymore.

---

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. New posts every Tuesday and Thursday.