Blog for Power Sheet AI BI for Excel
Sometimes it's hard to explain what a Fuzzy match is, so here is an example. Anyone who is trying to compare data in Excel, for example, is almost always limited to exact matches. In other words. Doug must equal Doug and Doug will not equal Douglas. But fuzzy matches are different. See below. CrushErrors.com will correctly match Tom with Thomas and Dave with David. But that's not really enough. It's ok if you only have 4 rows as shown below. But what if you had 1000 rows. You need to see which matches make sense. Because it's fuzzy, it almost means that it's sometimes wrong. So there is a score (see orange arrow belowthat indicates how close the match is. Tom and Thomas are more different than Ben and Benny.
All efforts in last few months have been on the product. Hardly any effort has been on the website or marketing for that matter. The product has many new features that will be revealed in further detail in the weeks to come.
Briefly, it can now handle CSV files. You can drag and drop them into the text boxes.
There are now progress bars, so you can process big files. 12 MB. No problem. Must be CSV.
There is now Fuzzy comparison. So you can match Doug with Douglas or Dave with David.
Oh, and dedupe also does a fuzzy search, so you're much more likely to find dupes.
Much more to come..