DemandTools vs OpenRefine
DemandTools
validity.com
OpenRefine
openrefine.orgSide by side
| Figure | DemandTools | OpenRefine |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| Self-hosted | — | Yes |
| Plans published | 0 | 1 |
| Spec score · Data Cleansing Software | 6.7 (#22) | 7.9 (#11) |
| Purpose | DemandTools finds, fixes, and prevents bad data across Salesforce organizations. | OpenRefine is a tool for cleaning, transforming and extending messy data with web services and external data. |
| Support | Validity lists support hours as Monday through Friday, 4 AM to 7:30 PM ET. | The project provides support through its forum, GitHub, community calls and Gitter chat. |
Plans
In their own words
DemandTools
DemandTools has no write-up on Specifiction yet; its figures are above.
OpenRefine
OpenRefine is a free, open-source tool for cleaning, transforming, and extending messy data. It works on the user's machine rather than sending data to a cloud service, and basic functions can run offline through a small web server on that computer. Facets help explore large datasets and apply changes to filtered views. Clustering uses heuristics to find similar values and address inconsistencies; reconciliation matches values to external databases through reconciliation services. Users can undo and redo operations without a stated history limit. OpenRefine imports formats including CSV, TSV, fixed-width text, JSON, XML, spreadsheets, PC-Axis, MARC, RDF formats, and Wikitext. It can also upload data to Google Sheets and create or update Wikidata statements. Releases are available for Windows, Mac, and Linux. Java must be installed and configured, although the Mac version and some Windows packages include it. Data is not encrypted by default; operating-system full-disk encryption can protect it. The project offers support through its forum, GitHub, community calls, and Gitter chat.