EUDR field plot template

Does your exporter ask for the GPS of every plot? Write it down here: one row per plot, with who farms it, where it is, how big it is and what it grows. The template is free, and a phone’s GPS is all you need to fill it in.

Download the template

Excel template

English

Google Sheets

Open in Google Sheets
Make a copy

It opens without an account. To fill it in, make a copy in your own Google Drive; that needs a Google account. On a phone it works best in the Google Sheets app.

CSV, any spreadsheet app
The template open in Google Sheets: the eight column names, then three example plots. Two are recorded as a point and one as a polygon.
The example sheet, opened in Google Sheets.

A point or a polygon?

Left, a small plot with one map pin near its middle. Right, a larger plot outlined by six numbered corners, walked in order around the edge.
4 hectares or less: one point, near the middleOver 4 hectares: every corner, in order
  • 4 hectares or less: one point is enough. Stand inside the plot, near the middle, and write its latitude and longitude. Write the area too.
  • Over 4 hectares: record the outline as a polygon. Walk the edge and write the position of each corner, in order.
  • Cattle are the exception: one point per establishment, at any size. Record every establishment where the animals were kept.
  • Not sure of the size? Record the outline. A polygon works for a small plot too.

More on points, polygons and the 4-hectare rule: What geolocation does the EUDR require?

How to read GPS from a phone

You don’t need a special device. Any phone with GPS works, even without mobile data, though the map may not load.

  1. Turn on location and let Google Maps use your precise location. On Android, also turn on Improve Location Accuracy if your phone has it.
  2. Stand still in the open for a minute, away from tall trees and roofs, so the GPS settles. The GPS Accuracy Test shows how close it is, in metres.
  3. In Google Maps, zoom in and touch and hold the map right where your blue dot is until a red pin drops. On Android the latitude and longitude show in the search box; on iPhone, swipe up the pin’s panel to see them. They look like -6.033012, -76.965811.
  4. Copy both numbers exactly, with any minus sign and all the decimals shown (at least six). The first number is the latitude, the second the longitude.
  5. For a polygon, do the same at each corner as you walk around the plot. Paste the corners in order in one cell, each as Google Maps shows it (latitude, comma, longitude), with a semicolon between corners.

A land-measuring app can also record the outline and its area as you walk. Copy its corners into the sheet.

The columns

ProducerName
Name of the farmer who owns or works the plot.
ProductionPlace
Your own code for the plot, such as SM-014. Use each code only once in the file.
ProducerCountry
Country of the plot as a two-letter code, such as PE (Peru), CO (Colombia), BR (Brazil), CI (Côte d’Ivoire) or ID (Indonesia).
Latitude
For a point (plots up to 4 ha, or cattle establishments of any size): the first number Google Maps shows for a spot inside the plot, with at least 6 decimals, such as -6.483012. Keep the minus sign if there is one.
Longitude
The second number for the same spot, such as -76.365811. Keep the minus sign: in Latin America it always has one.
Polygon
For a plot over 4 ha (except cattle): its corners in order around the edge. Paste each corner as Google Maps shows it (latitude, comma, longitude) and put a semicolon between corners: -6.041012, -76.972034; -6.040811, -76.969702; … Leave Latitude and Longitude empty.
Area
The plot’s area in hectares, such as 1.5. Needed for a point. For a polygon, write the area you know, if any.
Commodity
What the plot produces, written as listed: cattle, cocoa, coffee, oil palm, rubber, soya or wood. In Google Sheets, pick it from the list.

When the sheet is full

Drop the filled sheet into the plot file fixer. It turns the rows into the GeoJSON plot file your buyer asks for and points out the rows to fix.

This is a template, not a compliance check. Filling it in doesn’t show that a plot is free of deforestation or that a shipment meets the EU rules.

Need these records kept together? See Restoration Scope for EUDR.

About the EUDR Field Plot Template

A free spreadsheet for coffee and cocoa co-ops to record each plot in the field for the EUDR: farmer, plot, GPS point or polygon, area and commodity. Excel in English, Spanish, Portuguese, French and Indonesian, or CSV.

How it works

  1. Download the Excel template in your language, or the CSV. Each Excel file has a note on every column, a filled example and a notes sheet.
  2. In the field, write one row per plot: the farmer, your own plot code, the country, the area in hectares and the commodity.
  3. For a plot of 4 hectares or less, stand inside it and write the latitude and longitude from your phone’s GPS, with at least six decimals. For a larger plot, walk the edge and write each corner, in order, in the polygon column.
  4. Drop the filled sheet into the EUDR plot file fixer to turn the rows into a GeoJSON plot file.

Input and output

Input
Nothing to upload: download the Excel template in your language, or the CSV, and fill it in on a phone, a tablet or paper.
Output
A sheet with one row per plot: farmer, plot code, country, a GPS point or a polygon, area in hectares and commodity, ready for the EUDR plot file fixer.

Example

Input

Three made-up plots of a coffee co-op near Moyobamba, Peru: Rosa Huamán’s 1.5 ha coffee plot as one GPS point, Luis Tapia’s 7.1 ha coffee plot as a polygon of its four corners, and his 18 ha cattle pasture as one point.

Output

ProducerName,ProductionPlace,ProducerCountry,Latitude,Longitude,Polygon,Area,Commodity
Rosa Huamán,SM-014,PE,-6.033012,-76.965811,,1.5,coffee
Luis Tapia,SM-021,PE,,,"-6.041012, -76.972034; -6.040811, -76.969702; -6.043209, -76.969598; -6.043402, -76.972113",7.1,coffee
Luis Tapia,SM-022,PE,-6.046521,-76.975302,,18,cattle

Limits

  • It is a template only, not a compliance or deforestation check. Filling it in doesn’t show that a plot is free of deforestation or that a shipment meets the EU rules.
  • Commodity values are written in English (cattle, cocoa, coffee, oil palm, rubber, soya or wood) in every language of the template.
  • Excel set to Spanish, French or Portuguese saves CSV files with semicolons instead of commas. Keep the sheet as an Excel file when you can.
  • Coordinates are latitude and longitude in decimal degrees, with at least six decimals, as a phone’s GPS shows them. Convert UTM or degrees-minutes-seconds first.

Questions

When do I need a polygon instead of a point for the EUDR?

For a plot of more than 4 hectares, record a polygon: the outline of the plot, corner by corner, in order. For 4 hectares or less, one point with its latitude and longitude is enough, though a polygon works for a small plot too. Cattle are the exception: one point per establishment, and every establishment where the animals were kept.

How do I get GPS coordinates with my phone?

Turn on location and let Google Maps use your precise location. Stand still in the open for a minute, away from tall trees and roofs, then touch and hold the map where your blue dot is until a pin drops. Copy the latitude and longitude it shows, with any minus sign and at least six decimals. The GPS Accuracy Test shows how close your phone’s position is, in metres.

Is there a version in Spanish?

Yes. The guide is in Spanish at restorationscope.com/tools/eudr-plantilla-parcelas, and the Excel template comes in Spanish (eudr-plot-template-es.xlsx), with its column notes, example and notes sheet in Spanish. It also comes in Portuguese, French and Indonesian. The column names stay the same in every language, so the plot file fixer reads them all.

Connect your data, understand your operations.

Bring in the spreadsheets, field forms and maps you already use, and see every site in one place.

Create projectWhy operations matter