Reconcile
A tool I built for the tedious job of matching rows across spreadsheets. Point it at a main CSV and one or more reference files, tell it how rows should line up, and it stamps your main file with the matched values - no fragile VLOOKUPs, no formula gymnastics.
It runs entirely in your browser, so your files never leave your machine. That makes it safe for the kind of data you can't drop into some random web app.
What it does
- Multiple reference files - match your main file against several sources at once, each with its own rules.
- Ordered strategies - stack matching rules and let the first one that finds a match win.
- Flexible matching - exact, trim and ignore case, contains, starts with, or numeric equal, and combine conditions with AND.
- Ambiguity guard - reject a match when a rule hits more than one reference row, so you never merge the wrong data.
- Unmatched inspector - a fuzzy near-miss search (Levenshtein) shows what almost matched, and why it didn't.
- Saved setups - store a rule configuration as JSON and reuse it. It saves the rules, never your data.
- 100% in your browser - nothing is uploaded; your CSVs stay on your machine. Export the result as CSV or copy it to the clipboard.