OpenRefine · Clean Product CSV Data Before Import
Standardize names and attributes in supplier catalogs within a local browser workspace.
Requirements
Medium learning difficulty. Local Java application provides an interface via a browser; keep original CSV backups and verify store import rules.
Quick start
Download official packages: Windows package with Java, Mac DMG, or Linux tarball, and start locally per upstream instructions; it is not a hosted SaaS.
Check for inconsistencies in brand, color, and size before importing catalogs. Clustering similar values does not mean SKUs can be merged. Local cleaning is free; optional remote data reconciliation or URL fetching may send data to external services.
Verified official materials on 2026-10-16; no installation or running tests conducted. Official release/source code: https://github.com/OpenRefine/OpenRefine/releases/tag/3.10.1