Skip to main content

Soil Sampling: How to import historic soil sample results into Agworld - via CSV (lab not in Agworld)

If your laboratory is not listed in Agworld’s integrated labs, you can still manually import your soil sample results.

Adam Jungwirth avatar
Written by Adam Jungwirth
Updated over 3 weeks ago

If your laboratory is not listed in Agworld’s integrated labs, you can still manually import your soil sample results. This process ensures your field data is captured correctly and soil layers are generated.


1. Before You Begin

  • If you are zone sampling or grid sampling, follow the instructions in those specific guides on the Agworld Help site.

  • For manual imports, results must be provided in CSV file format.


2. Generate and Send the Lab Submission Sheet

  1. In the Agworld Sampling app:

    • After sampling a field, click Send to Lab.

    • Click Sync.

  2. Because you are importing results manually:

    • The lab submission sheet will not be sent directly to a lab.

    • Instead, it will be sent to the Agworld website, where you can download it.

  3. To download the lab submission sheet:

    • Go to the Sample Collection page.

    • Click the gear icon next to your sample job.

    • Select Download Lab Submission CSV.

  4. Send this CSV file to your chosen lab, along with the physical soil bags.


3. Align Lab Results with Sample Identifiers

Once the lab sends you results in a CSV format:

  1. Open both files:

    • Lab results CSV (from the lab).

    • Lab submission sheet CSV (from Agworld).

  2. In the lab results CSV, create two new columns:

    • Sample barcode

    • Sample unique ID

  3. Copy the corresponding barcodes and unique IDs from the lab submission sheet into the new columns in the lab results CSV.

  4. Carefully match each barcode and unique ID with the correct lab results.

    • ⚠️ This is the most important step to ensure results align correctly with the right samples.


4. Format Dates and Save File

  • Highlight all date cells in the lab results CSV.

  • Format them as Year–Month–Day (YYYY-MM-DD).

  • Save the updated CSV file.


5. Upload Lab Results into Agworld

  1. Go back to the Sample Collection page.

  2. Click the gear icon next to your sample job.

  3. Select Upload Lab Results.

  4. Choose the CSV file you just updated.


6. Map CSV Columns to Agworld Attributes

  1. Map each CSV column to the correct attribute in Agworld:

    • Lab result columns → Lab result attributes.

    • Identifiers and dates → Sample attributes.

  2. Ignore any unnecessary data (it simply won’t be imported).

  3. Once mapped, Agworld will remember your column headers for future imports as long as the headers remain consistent.

  4. Click Upload to begin processing.


7. Review Your Imported Results

  • Once processing is complete, your soil layers will appear in Agworld.

  • The data is now linked to the correct samples for accurate reporting and analysis.


Key Benefits

  • Works with any lab, even if not integrated with Agworld.

  • Maintains accurate linkage between sample IDs, barcodes, and results.

  • Reusable mapping setup for faster imports in the future.


👉 By following these steps, you can manually import lab results into Agworld and ensure your soil data is properly aligned and ready for decision-making.

Did this answer your question?