or
mail to: spreadsheets@tools.gbif.org
Directions:
- Review the available spreadsheet templates
- Download and complete the templates according to the user guidelines
- Click the "Choose File" button on the right to upload the completed spreadsheet or
- Email it to spreadsheets@tools.gbif.org
- Receive a validated Darwin Core Archive file or EML metadata document.
- To publish, put the Darwin Core Archive file and EML metadata document online, with a stable URL.
- Follow the GBIF data registration guidelines to register the data files with GBIFS.
Note: The processor does NOT publish a datafile to GBIF. It provides a publication-ready file.
Available Spreadsheet Templates – The processor currently only supports a set of pre-configured spreadsheet ‘template’ files. Each is available in the older XLS format and the new XLSX format, which supports more than 64,000 rows.
The following templates are available:
- Metadata - Use this template to describe a database or other data resource. Processor output is an Ecological Metadata Language Document that conforms to a GBIF metadata profile. [XLSX format]
Species Occurrence - Use this template to record or store basic species collections or observational data. [XLSX format]
Species Checklists – These templates provide different methods for recording and storing simple annotated species checklists. The different versions offer different methods for recording classification information.
Checklist 1 - Supports a ‘normalised’ classification where the classification is stored in two spreadsheet columns: one stores the ID of the taxon and another stores the ID of the parent taxon. [XLSX format]
- Checklist 2 - Classification in columns where the user can define the specific higher taxon groups. Useful when using super- or sub- ranks or other ranks outside the core Linnaean ranks. [XLSX format]
- Checklist 3 - Classification in columns is limited to the basic Linnaean ranks of Kingdom, Phylum, Class, Order, Family, Genus, etc. [XLSX format]
Project Website and additional documentation code.google.com/p/gbif-spreadsheet-processor/