Data import, export & API

Bring your herd in from CSV, Excel or another platform with AI-assisted mapping, export datasets in CSV/JSON/XLSX, and move data in and out programmatically with a per-org API key.

Updated 2026-07-12 · 6 min

Your data should never be trapped. Farmso lets you import animals and records from a CSV or Excel file — or from another platform — with AI-assisted column mapping that matches your columns to Farmso’s fields for you. Every import is validated first, then committed, and can be rolled back if something is not right, so a bad file never corrupts your herd.

You can export any dataset in CSV, JSON or XLSX for accounting, audits or backups, and move data in and out programmatically in bulk using a per-organisation API key. Import, export and the API are available on all paid tiers.

Use case

A farm switching from a spreadsheet-based system exports 400 head from their old tool as an Excel file. In Farmso’s import wizard, the AI maps “Ear Tag”, “DOB” and “Breed” to the right fields automatically; the farmer fixes one column, validates, sees a preview with two warnings, and commits. A week later they wire their weigh-station software to Farmso’s API so daily weights flow in without anyone re-typing them.

In the web app

Import, validate & export

  1. 1

    Open the import wizard

    In the web app, choose Data import and upload your CSV or Excel file (or connect an export from another platform).

  2. 2

    Map columns

    AI-assisted mapping matches your columns to Farmso fields. Review and adjust any that need it.

  3. 3

    Validate → commit

    Farmso validates the file and shows errors and warnings. Commit to apply — or roll back the whole import if anything looks wrong.

  4. 4

    Export a dataset

    From the export tools, choose your dataset and format — CSV, JSON or XLSX — for accounting, audit or backup.

In the web app

Use the API

  1. 1

    Generate an API key

    In Settings, create your per-organisation API key. Keep it secret — it grants access to your org’s data.

  2. 2

    Send the key

    Include it on each request as the x-farmso-api-key header.

  3. 3

    Bulk in and out

    Use the API to push records in or pull datasets out programmatically — ideal for connecting weigh heads, ERPs or your own tools.

Import, export and the API are managed in the web app. In the mobile app you capture and sync data in the field; the bulk data tools live on the web.

FAQ

Farmso validates before it commits and lists every error and warning. If you commit and then spot a problem, you can roll the whole import back — your existing records are untouched.