The data cleaning tools on this page help scholars with no coding experience locate blank (null) values, merge datasets, and flag typos and misspellings, preparing the data for analysis and visualization. 

Open Refine 

Open Refine is a free, downloadable tool for Window, Macs, and Linux that helps users clean, sort, and transform data from one format to another. Users can import data from various file types, including CSV, TSV, plain text, fixed-with column, Excel (XLS/XLSX), ODS, JSON, XML, ODS, PX, MARC, JSON-LD, N3, N-Triples, Turtle, RDF, Wikidata. The clustering feature identifies typos and inconsistencies, making it easy to merge, and edit data. Using the facet feature, users can evaluate their data by seeing how frequently a specific value appears in a column. Reconciliation allows users to match their datasets to external sources such as libraries, archives, museums, colleges, scientific institutions, interest groups, and Wikidata. Cleaned and sorted data can be exported as TSV, CSB, HTML, Excel (XLS, XLSX), ODF, ODS, Google Sheets, SQL statements, and JSON files.    

Breve

Breve is a free tool that helps users clean and sort tabular data, available through a web browser or as a downloadable on Mac application. Users can upload their datasets as CSV files. It flags data that mismatches the format within a column, and users can either dismiss the flag or correct the entry. Users can also edit, color-code, and assign data fields by data type. Cleaned and sorted data can then be downloaded as CSV files.