All projectsLet’s talk about your project 
Time saver
Client file cleaned up
A client list full of duplicates and typos, cleaned up in a few seconds.

Loading the demo…
What it is
You drop in your CSV file, the export from a spreadsheet. Each fix (duplicates, phone numbers, dates, e-mail addresses) is a rule you switch on or off, and you see the before and after.
How it’s built
The file is processed in your browser and isn’t sent anywhere. I also wanted you to stay in control of every fix.
Try this
Switch the rules on and off, then download the clean CSV.
At a glance
- File processed on your computer
- One rule per kind of fix
- Clean CSV export
For the curious: built with
- TypeScript
- FileReader
- Fuzzy matching
- CSV
Under the hood
The problem
Cleaning up a client file full of duplicates and typos.
How I solved it
- I wrote the file reader myself. It handles quotes, different separators and files exported by Excel on Windows, and the file never leaves your computer.
- For duplicates, the tool counts how many letters separate two names (the Levenshtein distance). “Dupont” and “Dupond” are one letter apart, and the tool ignores accents and word order.
- A date like 03/04 can be read two ways. The tool reads it as day then month and flags it “to check”.
The catch
On export, a cell that starts with = or @ could run a formula when the file is opened in a spreadsheet. The tool puts an apostrophe in front to stop it.
