Data Cleaning and Statistical Analysis
A workflow from raw tables through cleaning, descriptive statistics, significance testing and figure export, ready for a paper's results.
Cleaning tabular data
Free, open-source data cleaning tool for tidying messy tables and standardising text in bulk.
Version-watched: add it to favourites and confirmed new releases will show on your favourites page (stored in this browser only).
Sources checked: 2026-11-05 · Compiled from official sources; not run by ZIRULAB
Anyone with hand-entered or merged tables who needs to unify inconsistently spelled categories, trim spaces, or split and join columns.
Runs as a small web server on your computer and is used in the browser; basic functions need no internet. Reconciliation and similar features send data to the external service you choose.
Steps compiled from the official documentation and interface; not run by ZIRULAB. Practise with demo data.
OpenRefine is a powerful free, open-source data cleaning tool for handling messy tables, duplicate names, inconsistently formatted fields, bulk text transformations and data completion. It is better suited than Excel to building reproducible data cleaning workflows, and can connect to external data services to enrich data.
Use cases: table cleaning, species name standardisation, place name tidying, literature data organisation, bulk text processing
Checked 2026-11-05 · Compiled from official sources; not run by ZIRULAB