OpenRefine is a free open source tool you can use to clean data. The program runs in your web browser and does not require an internet connection.
Common scenarios when working with OpenRefine are:
What can it help you do with a simple tabular format?
Please note: OpenRefine works best on Google Chrome or Mozilla Firebox browsers. It is highly unstable on Internet Explorer or Microsoft Edge.
This work is licensed under a Creative Commons Attribution NonCommercial-ShareAlike 4.0 International License. Data and workbook are shareable under the Creative Commons Attribution-NonCommerical-ShareAlike 4.0 International License. (CC-BY-NC-SA license).
Most of the material was created by John Little, Data & Visualization Services Department, Duke University Libraries, Hilla Sang, Data Visualization & GIS Specialist, UNLV Libraries, and Tricia Lampron, Metadata Services Specialist, the University of Illinois at Urbana Champaign.