Guidance on passport data preparation using Excel: Data cleaning

This document is part of a webinar series organized by the Genesys team in 2023 on passport data preparation for publication in Genesys. The series covers practical approaches to data cleaning, standardization to MCPD v.2.1, validation, and eventual publication in Genesys, with a particular focus on genebanks managing passport data in spreadsheets such as Microsoft Excel. This publication accompanies Part 1 of the series, which focused on data cleaning and preparation of passport data prior to standardization and validation. This guidance is intended as a practical, step-by-step resource that participants can follow alongside the webinar recording or apply directly to their own datasets. Webinar recording:https://www.youtube.com/watch?v=LBZe4ipO2IE