Tracking contracts in Excel: 7 signs that it is time to change
The Docform team · Published November 7, 2026 · 6 min read
Key takeaways
It is time to change when the spreadsheet no longer reflects what your contracts say: notice periods discovered too late, a file maintained by a single person, competing versions, diverging dates. Excel remains a very good analysis tool. The real question is whether it can still serve as the reference for the company’s commitments.
Sign 1: a notice period was discovered after the deadline
The typical situation is familiar. A supplier reminds you that the deadline to terminate the contract has passed, and that it is renewing for a new period. Yet the date was in the file.
The spreadsheet records a date, but it does not alert anyone on its own. Someone has to open it, sort it and read it at the right time. Conditional formatting colors a row, provided someone looks. An automation can be added, but it then has to be built and maintained.
The sign is not the missed date itself. It is the fact that no one saw it coming even though the information existed. As a reminder, auto-renewal and the termination notice period follow what the contract and the applicable laws provide: each contract therefore has its own date to watch.
Sign 2: the file depends on a single person
In many teams, one person knows the file: its columns, its abbreviations, its hidden tabs. They know that “AR” means auto-renewal, and that the orange row is waiting for an answer.
This knowledge goes on vacation with them. It also leaves when they change jobs. The file remains, but its instructions are gone.
Run the test. If the person who maintains the file is away for a month, who receives the alert? Who enters the new contract? If the answer is hesitant, tracking depends on a person, not on an organization.
Sign 3: several versions of the spreadsheet are circulating
Legal has its file. Procurement has its own. Finance extracted a copy three months ago for its budget, and has added to it since.
Co-authoring exists, but it comes with conditions. According to Microsoft’s documentation, it requires a Microsoft 365 subscription and a workbook saved on OneDrive or SharePoint Online. On-premises SharePoint sites do not support it. And a workbook sent as an attachment remains a copy, with a life of its own.
The sign is simple: two people give a different end date for the same contract, each with their own file. The discussion is then about the spreadsheet, no longer about the contract.
Sign 4: the spreadsheet no longer says the same thing as the contract
A tracking spreadsheet is a manual copy of what the contract says. Any manual copy can contain an entry error, and it becomes outdated as soon as the contract changes.
A contract amendment extends the term, but the row is not updated. A three-month notice period is entered as six. A contract was terminated, and it still appears among active contracts.
Take ten contracts at random and compare them with their row in the file. Check the end date, the notice period and the renewal method, taking amendments into account. This check takes little time, and the result is often worth more than a long debate about the quality of the file.
Sign 5: finding the signed contract is still an investigation
The row exists, but the document is elsewhere. It is in a shared folder, in an email inbox, in the e-signature tool, or with the salesperson who negotiated it.
When a file contains links to the contracts, they break the first time a folder is moved. When it does not, you have to ask around.
The problem becomes concrete on the day of a dispute, a renegotiation or a customer request. You need the signed text, its appendices and its amendments, not a row that summarizes them.
Sign 6: you no longer know who sees and who edits what
A tracking file often brings together sensitive information: amounts, counterparties, special terms, sometimes employment contracts. Yet it follows the permissions of the folder it sits in, or those of the message that carried it.
Some teams think they solve the issue by protecting a sheet. Microsoft states that sheet-level protection is not designed as a security feature: it prevents changes to locked cells, nothing more.
Excel’s version history lets you go back. It does not replace a clear answer to another question, one that an auditor or an executive may ask: who has access to this contract, and who decided on this change?
Sign 7: a simple question from management ties up the whole team
How many contracts expire next quarter? What are our commitments to this supplier? Which contracts contain a given obligation?
If answering requires going through the file by hand, the spreadsheet has reached its limit. Dates are entered in several formats, and the columns have changed over time. Part of the answer depends on contracts that were never entered, and information that has no column forces you to reopen the documents.
Before choosing a tool, start with the ten-contract check from sign 4, then list what you expect: who enters data, who is alerted, who has access. You can also read how to migrate your existing contracts to gauge what moving to another tool would involve.
In Docform
The Docform contract repository brings contracts, their amendments and their key data together in one workspace, hosted in France. Existing contracts can be imported in bulk, including scanned PDFs thanks to OCR. The AI suggests the parties, dates, term and notice period, and your team validates.
Reminders can be set on the end date, the notice date, a fixed date or a custom attribute. Permissions and roles determine who views and edits each contract, and an audit log records actions. Excel keeps its place: the portfolio can be exported to Excel or CSV for your analyses.
Frequently asked questions
- What are the 7 signs that tracking contracts in Excel has reached its limits?
- A notice period discovered after the deadline, a file that depends on a single person, several versions in circulation, gaps between the spreadsheet and the contracts, a signed contract that is hard to find, unclear access rights, and simple questions that tie up the whole team.
- Can you track contracts in Excel?
- Yes, and it is a common starting point with a small number of contracts and one person in charge. The difficulty appears when the volume, the number of teams or the stakes increase, because the file then has to be kept up to date by hand, with no link to the contracts themselves.
- How many contracts justify leaving Excel?
- No figure applies to every company. The number of contracts matters less than their stakes, the number of people involved and how often deadlines come up. A small but sensitive portfolio can justify a dedicated tool earlier than a large volume of simple contracts.
- Can Excel send deadline reminders?
- A workbook does not alert an owner on its own as a date approaches. Reminders are possible by adding an automation, but it must be built, maintained and checked, and it still depends on the accuracy of the dates entered in the file.
- Should you drop Excel completely when moving to a CLM?
- No. Excel remains useful for analyzing data or preparing reports. What changes is that it no longer serves as the reference: the data lives with the contract, and an export lets you bring it into a spreadsheet when an analysis requires it.
- Where should you start when assessing your tracking file?
- Compare ten contracts picked at random with their row in the file, checking the end date, the notice period and the renewal method. Then ask who would receive the alert if the file owner were away. These two checks give a first concrete measure.
This article provides general information as of its last update. It does not constitute legal advice and does not replace your counsel’s analysis of a specific situation.
Estimate the move to a CLM with your assumptions
Our ROI simulator, available in French, compares a quote with the time saved, the risks avoided and the notice periods met, based on your own data.