OpenRefine
Open-source alternative to Excel data cleanup, Tableau Prep
OpenRefine is an open-source alternative to manual Excel cleanup and Tableau Prep workflows. It cleans and transforms messy data through a browser interface, using faceting and clustering to find and fix inconsistencies. It runs on your own computer and handles large datasets without a spreadsheet.
Key features
- Data cleaning and transformation in a browser interface
- Faceting and clustering to group and fix similar values
- Runs locally on macOS, Windows, and Linux
Before you switch
Utilities should be boring in the best way: install, configure once, forget. Before switching, confirm the tool supports your operating system and check whether it needs background services or special permissions. Open-source utilities are often lighter than their commercial counterparts, so you may notice your machine feeling snappier.
Like every project on OpenShelf, OpenRefine is developed in the open — you can read the code, follow development, and even contribute. Check the system requirements and the project’s own documentation linked on this page before installing.