1.0GBIF.EShttps://gbif.es/en/gbif_ushttps://gbif.es/en/author/gbif_us/rich600338<blockquote class="wp-embedded-content" data-secret="8e3WJAg3fG"><a href="https://gbif.es/en/open-refine/">Open Refine</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://gbif.es/en/open-refine/embed/#?secret=8e3WJAg3fG" width="600" height="338" title="“Open Refine” — GBIF.ES" data-secret="8e3WJAg3fG" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript"> /* <![CDATA[ */ /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); /* ]]> */ </script> 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.https://gbif.es/wp-content/uploads/2024/07/logo-GBIF-RGB-01.png1064554