How to use the passport data validation tool?

See this short video to learn the basics: https://youtu.be/LR9Fl1P84Gc

Source taxonomy databases: The tool checks data against the GRIN-Global Taxonomy database (last update Thu Dec 08 19:58:34 UTC 2022) maintained by USDA-ARS. See GRIN Taxonomy for Plants.
Data source: This tools is able to parse CSV data.

Validated columns

Only the following MCPD columns will be checked for taxonomic data: GENUS, SPECIES, SPAUTHOR, SUBTAXA, SUBTAUTHOR.

Geo tests require DECLATITUDE, DECLONGITUDE and ORIGCTY for country border check and suggested coordinate fixes.

Other columns will be included in the output, but not processed.

Select the range of cells (including headers) in Excel and paste the data in to the textbox.

Tab Comma , Semicolon ; Space Other

The separator character in CSV separates "columns".

If the quote character is used in column text, it must be escaped: "This is: a \"column\""

Dot (π is approximately 3.14159) Comma (π is approximately 3,14159)

A decimal mark is a symbol used to separate the integer part from the fractional part of a number. PI is 3 [decimal-mark] 14159.

Options below are specific to validators, try them out.

Yes No

Tick the box if you want to download results as CSV file. Leave unticked to see results in the browser.

Download results as CSV