> For the complete documentation index, see [llms.txt](https://docs.geopard.tech/geopard-tutorials/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.geopard.tech/geopard-tutorials/product-tour-web-app/import-precision-agriculture-data/soil-lab-results-csv-excel-smart-import.md).

# Soil Lab results (CSV/Excel) - 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.

<figure><img src="/files/dVdMYr4QWQVTpcKZeV4c" alt="Automated parsing of csv/excel soil lab results"><figcaption><p>Automated parsing of csv/excel soil lab results</p></figcaption></figure>

## 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. **Point coordinates (`Lon` / `Lat`)**\
   Use two columns for longitude and latitude. If the point falls inside a field boundary, GeoPard matches it spatially.
2. **WKT geometry**\
   Use one column with WKT geometry. GeoPard matches the geometry spatially to the field boundary.
3. **Field Name / Field ID**\
   Use a text column with the field name or field ID. GeoPard compares it with the field `TagString`. You can also filter by label.\
   `Field ID` is the GeoPard field UUID.
4. **Sampling Plan ID**\
   Use the unique Sampling Plan ID created with the sampling plan. This is the most reliable option when lab results come back from a GeoPard-generated sampling workflow.

## 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](/geopard-tutorials/product-tour-web-app/soil-sampling-automated-planning.md) or files with coordinates.

## Available for all users.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.geopard.tech/geopard-tutorials/product-tour-web-app/import-precision-agriculture-data/soil-lab-results-csv-excel-smart-import.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.