Open Refine
OPEN REFINE
This generic ETL (Extract, Transform and Load) tool is very useful for working with messy data, in general (transformation, analysis etc.). The three tutorial videos in their website provide a good overview of what is possible to do or be adapted to biodiversity data without too much trouble.
