Every team has that one spreadsheet. The pricing model, the migration tracker, the client list — passed around by email, edited by five people, and saved as final_v7_REAL.xlsx. When two versions come back to you, the question is always the same: what actually changed?
Scrolling through hundreds of rows looking for edited cells is not a workflow. It's a punishment. And Excel's built-in "Compare Workbooks" is buried, clunky, and requires both files open in the desktop app.
The diff-first approach
Developers diff code instinctively. The same instinct should apply to spreadsheets: convert the comparison problem into a visual diff problem, and let the tool do the reading.
FileCompare is a free, browser-based diff tool that compares Excel workbooks cell by cell — no signup, no upload to a server, everything runs locally in your browser. Drop in the two versions and every added, removed, or modified cell is highlighted.
A practical workflow that survives real teams:
- Freeze a baseline. Before sending the sheet out for edits, keep an untouched copy. This is your "before."
- Diff the return. When the edited version comes back, compare baseline vs. returned. Don't read the sheet — read the diff.
- Verify the surprises. The diff shows you exactly which cells changed. Every change should map to something you expected. The ones that don't are the ones that matter.
Why it beats git diff for this
Yes, you can version-control a CSV export. But most business spreadsheets live outside repositories — they arrive as email attachments, live in shared drives, and get edited by people who have never heard of a commit. A browser diff meets the file where it actually lives.
Beyond spreadsheets
The same principle applies to the other formats that drift silently: JSON configs before a deploy (compare two JSON files and spot the one key someone changed), API responses before and after a release, YAML manifests, even folders of config files.
The habit is simple: never merge by reading — merge by diffing. Your future self, staring at final_v9_FINAL2.xlsx at 11pm, will thank you.
Top comments (0)