Form

Guidance on how to complete the spreadsheet to record details of imported plant material

Updated 5 March 2021

This form was withdrawn on

This content has been withdrawn because PEACH has now closed.

Use the import of products, animals, food and feed system (IPAFFS) to notify authorities about an import to Great Britain. 

How to complete the spreadsheet to record details of imported plant material for uploading on to PEACH system.

Step 1: Enable macros

Download the spreadsheet and open it on your computer. To enable macros, click ‘Enable Editing’ and ‘Enable Content’.

Step 2: Enter your genus

In column B (Genus), type the genus as it appears on your phytosanitary certificate. Click on the genus dropdown icon (it looks like an upside down triangle) to confirm the correct genus from the list. For example, ‘Acorus’.

If the genus does not appear on the dropdown lists, you can still add it. Type the name as it appears on your phytosanitary certificate.

If your phytosanitary certificate does not have a species name, select the genus option with brackets and skip the next step.

Step 3: Enter your species

In column C (species), type the species as it appears on your phytosanitary certificate.

Click on the species dropdown icon (it looks like an upside down triangle) and confirm the correct species from the list. For example, ‘Gramineus’.

If the species does not appear on the dropdown lists, you can still add it. Type the name as it appears on your phytosanitary certificate.

Step 4: Confirm the number of plants

In column E (Number of), type the number of plants being imported as a figure only.

For example, if you plan to import fifty Acorus gramineus, type ‘50’ in the column.

Repeat the steps if you have more genus or species

If you import more than one type of genus or species, you can add more entries to the spreadsheet.

Enter the genus, species and number of plants underneath your first entry in the same columns (B, C and E).

Step 5: Enter the net weight of your consignment

Enter the net weight as a figure in the yellow cell under ‘Net Weight (enter below)’.

For example, if your net weight is 350 kilograms enter it as ‘350’.

Step 6: Enter your phytosanitary certificate number

Enter the last 5 digits and characters of your phytosanitary certificate in the yellow cell under ‘Phyto Last 5 digits/characters (enter below)’.

For example, if your phytosanitary certificate number is 2021030457263, you would type ‘57263’.

Step 7: Create your CSV file

Click on the ‘Create CSV File’ button and select where you would like to save the CSV file on your computer. You do not need to select any options from the ‘Directory for CSV file to be saved in’ dropdown.

The name of the CSV file will be automatically saved as the net weight and last 5 digits of the phytosanitary certificate number.

For example, the name of the file will appear as ‘350KG 57263’.

If your consignment has more than 200 lines of different genera and species you will have to put this onto a separate spreadsheet and save it as a separate CSV.

The CSV file, or files if you have more than 200 lines, for each phytosanitary certificate can then be uploaded to the PEACH application on screen 2B. Do not upload the spreadsheet to PEACH.

Reusing spreadsheets

If you’re re-using a spreadsheet, make sure the details are updated. If there are any genera or species you are not importing for that consignment, enter 0 in the ‘Number of’ column or leave it blank.