How can I easily transpose my Farm Management Software (FMS) data into the Sandy Excel template?

Trinity Agtech’s Sandy software has a custom Excel template that allows you to upload data in bulk. This can be used to quickly upload arable and grassland (operational data

only) from FMS platforms where there is currently is not a bespoke integration with Sandy.

The Sandy Excel sheets are format sensitive, so this requires some of the original FMS data to be transposed into the correct format (i.e. naming/spelling) for the Sandy Excel, sheet before it can be uploaded.

Wait till you have completed the Sandy Excel sheet fully before you upload it.

Click here to watch an instruction video.

1. DOWNLOAD YOUR FMS DATA AND SANDY EXCEL SHEET

   Download your FMS data (cropping and operations) in either

   Excel, or CSV format. Then download the Sandy arable/grassland Excel

   upload sheet from “Sandy Setup>Choose your onboarding method”.

2. FIELD NAMES AND FIELD AREAS

Copy and paste the field names and areas from your FMS report into the

“Fields” tab in the Sandy Excel upload sheet. Make sure that the field

areas correspond to the correct field name.

2. CROPPING DATA

Select all your FMS data in Excel by clicking on the small triangle in the top

left corner of the cells. Click on “Sort & Filter” and “Custom Sort”. Make

sure to select “My data has headers”. Sort the data by crop name in

alphabetical order, so that the same crop types are next to each other.

Open the Sandy Excel sheet. Go to the “Field Cropping data” tab. For each

crop in your original FMS data, select and copy the correct “Crop type”,

“Crop name” and “Crop variety” from the Sandy Excel sheet so that you

have the correct format for the Sandy Excel sheet.

Paste this Sandy text (making sure to paste the formatting too) as a new

column next to each cropping record in the original FMS data sheet. For

identical crops in multiple fields, you can easily duplicate this data across

multiple rows, by clicking on the bottom right corner of the cell and

dragging the data down to populate the cells. Alternatively you can copy

and paste this for each row.

Once you have added the Sandy crop type, crop name and crop variety

next to each row of data in your original FMS data sheet, rather than

selecting each record using the drop down menus in the Sandy Excel

sheet, you can simply copy and paste the field name and Sandy cropping

information back into the Sandy Excel sheet in the correct columns*.

If you have yield information in your FMS data you can paste this in as well

in the “Yield” column.

*You will be overwriting the drop down menus in the Sandy Excel sheet, so

it’s vital that the correct Sandy formatting is used, otherwise you cannot

upload the Sandy Excel sheet.

3. OPERATIONAL DATA

Select all your original FMS data in Excel by clicking on the small triangle in

the top left corner of the cells. Click on “Sort & Filter” and “Custom Sort”.

Make sure to select “My data has headers”. Sort the data by product name

in alphabetical order, so that the same product names are next to each

other.

Open the Sandy Excel sheet. Go to the “Field Operational data” tab. For

each product name in your FMS data, select and copy the correct

“Operation group”, “Operation type” and “Product name” from the Sandy

Excel sheet so that you have the correct format for the Sandy Excel sheet.

Do the same for the “Unit” column.

Paste this Sandy text (making sure to paste the formatting too) as a new

column next to each operational record in the original FMS data sheet. For

identical products in multiple fields, you can easily duplicate this data

across multiple rows, by clicking on the bottom right corner of the cell

and dragging the data down to populate the cells. Alternatively you can

copy and paste this for each row.

Once you have added the Sandy operation group, operation type and

product name next to each row of data in your original FMS data sheet,

rather than selecting each record using the drop down menus in the

Sandy Excel sheet, you can simply copy and paste the field name and

corresponding Sandy operational data (now in the correct format) back

into the Sandy Excel sheet in the correct columns*.

You can also paste the quantity applied and applied area into the

respective columns in the Sandy Excel sheet too.

*You will be overwriting the drop down menus in the Sandy Excel sheet, so

it’s vital that the correct Sandy formatting is used, otherwise you cannot

upload the Sandy Excel sheet.

4. UPLOADING YOUR DATA INTO SANDY

Make sure there are no gaps in the Sandy Excel sheet. Save it and

then upload the Excel sheet back into Sandy. This is done in

“Sandy Setup<Select your onboarding method”.