Atelier Rondin, home
FR
All projects

Time saver

Client file cleaned up

A client list full of duplicates and typos, cleaned up in a few seconds.

Let’s talk about your project
Live demo: Client file cleaned upSwitch the rules on and off, then download the clean CSV.
A beaver pushing a log, the demo is on its way.

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.