Files
OpenRefine
Clean a messy spreadsheet before analysing it
Desktop appFree · desktop installation
Open OpenRefine Why this one
Group inconsistent names and fix repeated data problems in batches. Useful when a CSV has several spellings for the same city, company or product.
Try this first
Import a copy of a CSV, facet one text column and inspect suggested clusters. Merge only the values you know belong together, then export a new file.
How it helps your AI
Give an assistant a cleaned table and a record of your transformations instead of asking it to guess which rows mean the same thing.