Data contribution

Your data contribution is what makes GAZP a growing resource for dryland restoration ecologists. In order to facilitate rapid processing and database updates, we require that contributors format their data in a standardized structure for submission. Each step below describes the key components for data contribution.

There are two downloadable files: the first is the Excel workbook that should be filled out for your data submission. Each step below is represented in that workbook as one or more individual worksheets. Please go sheet by sheet and fill in all relevant data.

The second downloadable file is a PDF document that provides a legend for each of the worksheets. All columns are explained in detail. Please look at the legend in detail as you work through each sheet.

Fill the data contribution workbook out and submit it online using the Data Submission step at the bottom of this page. If this work is published, either in a scientific journal or other type report, please include that work in the Data Submission step at the bottom of the page.

If you have reference data (intact vegetation monitoring data), please include that data and treat it as a treatment in the data. Thus, it will be included in the same single data contribution workbook.

If processing in this way is a significant barrier to your involvement, please contact the project leadership team at and discuss alternatives. Also please reach out with feedback or questions on this process.

Downloadable files

GAZP Data Contribution Legend

This is the Excel file required for data contribution. Please download it and fill out all relevant sections. Please do NOT alter column headers (with one exception in “Monitoring results_opt2”). Please do NOT skip worksheets unless the instructions below explicitly say they are optional.

GAZP Data Contribution File

This is the PDF document providing a detailed legend for each worksheet in the data contribution workbook.

Step 1: Site details

This worksheet outlines the overarching site details, with each site as a single row in the data sheet.

Step 2: Treatment details

This worksheet outlines restoration treatments implemented, with each treatment as a single row in the data sheet.

Step 3: Species details

This step details all species added or found in the project. There are three worksheets within the workbook for this step: “Seeded species”; “Planted species”; and “Full species list”. Only the third is required for submission. If species were added in any form, the first and/or second sheets are also required.

The first details seeded species, including all information about seedmix design. The second sheet details similar information but for any species that were planted. The third sheet details all species found in the contributed data.

Step 4: Monitoring details

Image by the University of Idaho, College of Natural Resources

This step details key monitoring components and has two worksheets. Both worksheets are required for submission.

The first worksheet, “Monitoring details”, captures monitoring methods relevant to how we scale and process the contributed data.

The second worksheet, “Time point details”, captures monitoring times, split by treatment if the monitoring occurred at different time points by treatment or site. There are columns for day, month, and year. If day and/or month is unknown, please leave it blank.

Step 5: Monitoring results

This step is represented by two worksheets, only one of which is required depending on your original data format. This data includes the vegetation outcomes captured in the monitoring. There are two potential options, “long” and “wide” format (“Monitoring results_opt1” and “Monitoring results_opt2”, respectively).

Please note that this is designed for species-level measurements (total cover; total density). If you have individual-based measurements, please contact the organizers to finalize this stage of the submission process.

In each worksheet, there are two columns for spatial replicates (to capture, for example: block and plot within block). If there are more spatial levels (for example: block, transect within block, and plot within transect within block), please add columns as needed.

Option 1: Long format

Long format is when species are all included within one column. Final data looks similar to:

Treatment nameBlockPlotTimepointSpecies codeValue
H1A1May-1-2015 POLI5
H1 A1May-1-2015 BRET10
H1 A1May-1-2015 TRRE10
H1 A2May-1-2015 JUPI40
H1 A2May-1-2015 BRET0.1
H1 A2May-1-2015 POLI15
H1 A2May-1-2015 GERT1

Option 2: Wide format

Wide format is when species are included as columns. Final data looks similar to:

Treatment nameBlockPlotTimepointPOLIBRETGERTJUPIABFR
H1A1May-1-2015 5100151
H1A2May-1-2015 150.11400
H1A3May-1-2015 6050.1300
H1B1May-1-2015 10200150.1
H1B2May-1-2015 250.1050
H2A1May-1-2015 010205
H2A2May-1-2015 0300.13510
H2B1May-1-2015 0.15055
H2B2May-1-2015 0251151

Data submission

If you are concerned about your submission once it has been sent, or have any questions at any time, please email and we will respond as quickly as possible.

This is also a TRIAL process and we are looking for feedback on how we can make this easier on everyone! Please see below the submission section to provide suggestions and comments.

    Create a website or blog at

    Up ↑

    %d bloggers like this: