To start using Record Cleaner go to the File upload page.
Record Cleaner allows you to upload a file of species records for
• validation - checking the format is correct
• verification - checking for consistency with rules such as where and when species are known to be found.
Your file must be in CSV format and contain a header row with column names (Excel files will become an option soon, but are currently not fully supported). Each row needs to contain at least the following columns:
• Taxon name or taxon version key. This identifies the organism that was observed. Where possible taxon names should be the scientific names; English names can be used but can be ambiguous. If you have taxon version keys (TVKs) available these provide the most unambiguous option.
• Observation date. This can be a specific date, or a date range. Read more.
• Spatial reference. The location on the observation. It can be a grid reference (UK, Ireland or Channel Islands), or latitude and longitude coordinates.
Record Cleaner also requires a Unique record ID number for each record, but if your file does not contain unique IDs, Record Cleaner can generate them by adding auto-numbering to each row in the file.
Additional columns can be included, such as:
• Stage. A stage term (such as “adult” or “larva”) will allow phenology rules to be applied to the appropriate stage (e.g. so that butterfly flight period rules are not used to check caterpillar records).
• Vice-county. Record Cleaner can carry out checks to see if your grid reference correctly overlaps the vice-county assigned to the record (based on the 1 km square for the record).
Known issues at March 2025
- Some phenology (flight period) rules for overwintering species (mainly birds and moths) are currently being incorrectly applied (records that are in the correct period will be flagged as failing, while records that are in the incorrect period will pass). A fix is in progress.
- Rules for hoverflies are currently missing. These will be added shortly.
- Excel files can be imported but dates are not being handled correctly. A fix is in progress.