Turn messy spreadsheets into cleaner, more trustworthy data.
DataRefine checks CSV and Excel files for common quality problems, explains what it finds in plain English, and lets you review safe corrections before exporting a cleaner copy.
DataRefine checks CSV and Excel files for common quality problems, explains what it finds in plain English, and lets you review safe corrections before exporting a cleaner copy.
DataRefine is a browser-based data-quality project. It takes a spreadsheet, converts it into a JavaScript data structure, checks that data against a small set of quality rules, and highlights records that may deserve attention.
CSV files are parsed directly by JavaScript. Excel files use the
open-source SheetJS library so the browser can read
workbook cells without needing a backend server.
The current rules look for blank values, exact duplicate rows, leading/trailing whitespace, inconsistent capitalization, numeric outliers and a few category-format inconsistencies.
Trimming accidental spaces is usually safe. Guessing whether
Flordia means Florida is not. The tool
automatically offers low-risk corrections and leaves uncertain
changes for human review.
Changes are made to a copy of the loaded dataset. The original is preserved inside the browser session so the user can compare or reset at any time.
The user can download a CSV or Excel copy of the cleaned data. Nothing is silently uploaded or written back to the original file.