7 min read
Fuzzy matching explained: when 'almost equal' is the right answer
What fuzzy matching is, what Jaro-Winkler actually measures, when to use it and — more importantly — when not to. A practical guide for messy real-world data.
Read more →Blog
Notes on comparing, splitting and cleaning messy spreadsheet data. No hype, no oversell — just what we have learned shipping MessyMatch.
- 7 min read
VLOOKUP vs XLOOKUP vs just diffing two files
VLOOKUP and XLOOKUP are great in a live spreadsheet. They are the wrong tool when you need to compare two files once and act on the result. Here is how to tell which approach you need.
Read more → - 6 min read
Why Excel breaks at 1 million rows (and what to do about it)
Excel caps spreadsheets at 1,048,576 rows — and starts hurting long before that. Here is what actually happens, why, and the practical workflow when your file is too big.
Read more →