Soil Lab results (CSV/Excel) - Smart Import

GeoPard Agriculture is the first platform to truly “solve” soil lab result format chaos - with automated smart import.

OVERVIEW

Soil lab files are often messy: different templates, languages, column names, units, and even multiple spreadsheets in one Excel. Smart Import auto-understands these files and converts them into consistent sampling-point data for clean analytics and recommendations.

Automated parsing of csv/excel soil lab results

SUPPORTED FILES

• CSV (.csv)

• Excel (.xls, .xlsx), including multi-sheet workbooks

• Multiple files per upload (40 MB per file)

WHAT HAPPENS AUTOMATICALLY

• Auto-parsing: finds the real table + headers (even in “non-standard” layouts)

• Multi-language support: recognizes common lab attribute names across languages/local naming

• Smart mapping: detects macro + micronutrients and builds a mapping preview (editable)

• Units mapping + normalization: detects units, converts to consistent units, flags odd/mixed units

• Field matching: maps points to fields via GeoPard Sampling Plan, or via coordinates in the file

HOW GEOPARD MATCHES LAB RESULTS TO FIELDS

GeoPard can match lab results to the right field in four ways:

1. Sampling Plan ID and Zone ID Use separate columns for the unique Sampling Plan ID and Zone ID. This is the most reliable option for zonal composite sampling from a GeoPard-generated sampling plan.

2. Point coordinates (Lon / Lat) Use two columns for longitude and latitude. GeoPard matches the point spatially when it falls within a field boundary. Use this method for core-point sampling only.

3. WKT geometry Use one column with WKT geometry. GeoPard matches the geometry spatially to the field boundary.

4. Field Name / Field ID Use a text column with the field name or field ID. GeoPard compares it with the field Name. Field ID is the GeoPard field UUID (you can find it on any field page in the browser URL, ex. https://app.geopard.tech/field/farmID/fieldId ).

HOW TO IMPORT

1. Import Data → Upload Files → Lab Results

2. Upload CSV/XLS/XLSX

3. Select field / sampling plan (if available) + dates

4. Review mapping + units in the preview

5. Upload

Connecting to Planning

Best works with Soil Sampling - Automated Planning or files with coordinates.

Available for all users.