Anyone who has worked on spreadsheets as a team knows the folder full of files called budget_final.xlsx, budget_final2.xlsx and budget_final_REALLY_reviewed.xlsx. The problem is not just cosmetic: when you do not know which version is the right one or what changed between them, every decision based on that data becomes risky. Version control, a standard practice in software development, can be applied to Excel with a few simple rules.
What version control means
Controlling versions means being able to answer three questions at any time: which version is current, what changed compared with the previous one and who made the change. You do not need complex software to do this; a consistent naming system, a single storage location and a reliable way to compare versions are enough.
Step 1: a clear naming system
The file name should tell its story. A format that works well is:
project_document_YYYY-MM-DD_v03_initials.xlsx
For example: store_prices_2026-09-15_v03_MG.xlsx. This format has several advantages:
- The year-month-day date makes files sort themselves in the folder.
- A two-digit version number stops v10 from appearing before v2.
- The initials identify the author without opening the file.
Avoid words like “final”, “definitive” or “new”. There will always be a later version.
Step 2: a single storage location
Versions should live in a shared folder, not in email attachments or on each person’s desktop. If you use OneDrive, Google Drive or Dropbox, take advantage of their version history, which keeps earlier copies automatically. Even so, it is worth saving a numbered version manually at every important milestone, such as sending a file to a client or approving a budget.
Step 3: log the changes
Add a sheet called “Changes” at the start of the workbook with columns like these:
| Version | Date | Author | Description of change |
|---|---|---|---|
| v01 | 2026-09-01 | MG | Initial version |
| v02 | 2026-09-08 | JR | Updated supplier prices |
| v03 | 2026-09-15 | MG | Added 12 new products |
This log takes seconds to fill in and saves hours of detective work when someone asks why a figure changed.
Step 4: compare versions before approving them
A change log depends on the discipline of whoever writes it. To be certain about what really changed, compare each new version with the previous one before accepting it. With the Excel comparison tool on our Excel tools page you upload the previous version as the original and the new one as the modified file, and you get a file with every difference marked: modified cells, added or deleted rows and new sheets.
This check has two benefits. First, it catches changes the author forgot to log. Second, it reveals accidental changes, like a cell overwritten during a copy and paste, that nobody would otherwise notice.
Step 5: protect approved versions
Once a version is approved, make sure it is not modified by mistake. You can store it in a read-only subfolder, mark it as final in Excel or protect it with a password. If you send it to third parties, you can also convert it to PDF with our Excel to PDF tool so the recipient sees exactly what you see.
What to do with files from outside
When a client or supplier sends back a modified file, do not assume only what they told you has changed. Save their file as a new numbered version, compare it with the one you sent and review the difference report before bringing the changes in. It is common to discover deleted rows, formulas replaced with values or reordered columns.
Tools that help
Besides the comparison tool, other utilities make it easier to keep versions clean:
- Merge Excel: useful when each person works on one part and everything has to be joined in a single workbook.
- Remove Duplicates: prevents records from being repeated when versions are combined.
- Format converters: if one person saves as XLS and another as XLSX, standardize the format before comparing.
You will find all of them on our free tools page.
Common mistakes
- Working on the email attachment. Changes stay in a temporary folder and get lost.
- Overwriting the previous version. Without the earlier version there is nothing to compare.
- Several people editing different copies at the same time. In the end someone has to merge them by hand.
- Not noting where the data came from. Months later nobody knows where a figure came from.
Frequently asked questions
Does OneDrive or Google Drive version history replace version control?
It helps a lot, but it does not fully replace it. Version history keeps automatic copies, but it does not explain what changed or why. Combining it with numbered versions at key milestones and a change log gives you full control.
How often should I create a new version?
Create a numbered version whenever the file changes hands or reaches a milestone: when you send it for review, when it comes back with corrections, when it is approved and when it goes to a client. Minor day-to-day edits can stay in the automatic history.
How do I know what changed if nobody filled in the change log?
Compare the new version with the previous one using a file comparison tool. The result will show every modified cell, added or deleted row and new sheet, even if nobody wrote them down.
What should I do with old versions?
Do not delete them right away. Move them to a subfolder called “Archive” or “Previous versions” and keep at least the approved versions and those sent to third parties for as long as your accounting or contractual obligations require.
Conclusion
Version control in Excel does not require expensive tools, just habits: clear names with a date and number, one storage location, a change log and a systematic comparison between versions. With these five steps you will always know what changed and be able to prove it. Start today by comparing your last two versions with the tool on our Excel tools page and find out whether there were changes nobody mentioned.
Try our free tools
Compare, convert, merge and clean your spreadsheets right in your browser, with nothing to install.
