OpenRefine is an open-source tool that runs on your machine for data cleaning: merging duplicate or differently written values, splitting columns, and performing bulk format conversions. Your data stays on your machine.

Data cleaning

Visit Website

Step-by-Step Guides Real-World Use Cases Pros & cons Reviews

Step-by-Step Guides

Reviews

No reviews yet - be the first to share your experience.

Real-World Use Cases

Cleaning Customer Lists

Data Specialist

About 1 hour

The customer list has many different spellings for the same company.

Problem

Manually correcting each line takes a long time and is prone to errors.

Solution

Use OpenRefine to group similar values and standardize them in bulk.

More consistent data
Quick batch corrections
Data stays on the machine

Pros

Data cleaning: merging duplicate or differently written values, splitting columns, performing bulk format conversions
Free and open source
Data stays on your machine

Cons

Interface requires a learning curve
Runs on your machine, so limited by your configuration
Needs to verify results after cleaning

At a glance

Pricing: Free
API: No
Languages: English

Perfect ForData Analyst Researcher