Skip to main content
Requires CamoAg Enterprise subscription to access this feature.

Requirements: Read First

1
Column names must appear exactly as written below (lowercase, with underscores). Columns you don’t use can be left blank or removed.
2
Every row must include the five required values: county_geoid, sale_date, sale_price, assessor_parcel_number, and at least one recorded document number (document_number, document_book_number, or document_page_number).
This import is for county-recorded sales. Because every row needs a recorded document, book, or page number from the county, sales that haven’t closed and been recorded with the county yet can’t be imported.
3
One row per parcel. A sale that covers several parcels is written as several rows with the same county, sale date, and document number(s). They’re combined into a single sale during the import.
4
Dates use YYYY-MM-DD format (for example, 2024-03-15).

Sales Import Template

Download the sales import template

A CSV with the header row for every supported column. Fill in the columns you have and leave the rest blank.

How rows become sales

CamoAg identifies each sale by its county, sale year, and recorded document number(s). Rows that share those values are grouped into one sale:
  • Sale fields are read from the first row in the group. improvements is the exception: the sale is marked as having improvements if any row says true.
  • Parcel and acreage fields are read from every row, so each row adds a parcel to the sale. If two rows in a group have the same parcel number, only the last one is kept.
  • Buyer and Seller fields are read from every row, and duplicate names are merged.
  • comments from every row are combined, with duplicate lines removed.
Re-importing a row with the same county, sale year, and document number(s) updates the existing sale rather than creating a duplicate.

Value formats

The file must be a comma-delimited CSV (.csv). Other formats, such as Excel workbooks or pipe-delimited files, aren’t supported.

Required fields

Rows missing any of these values are rejected. The other rows in the file still import.
  • county_geoid (String) - The 5-digit county FIPS code (2-digit state code + 3-digit county code). Keep any leading zero.
    • Examples: 17037 (DeKalb County, IL), 01001 (Autauga County, AL)
  • sale_date (Date) - Date the sale closed
    • Examples: 2024-03-15
  • sale_price (Number) - Total sale price for all parcels in the sale, from 0 up to 999,999,999.99
    • Examples: 1250000
  • assessor_parcel_number (String) - The parcel number (APN / PIN) that was sold. Used to match the sale to a parcel on the map. Formatting such as dashes and spaces is ignored when matching.
    • Examples: 08-16-200-004, 0816200004
  • document_number (String) OR document_book_number (String) OR document_page_number (String) - At least one is required; provide all that appear on the recorded deed.
    • Examples: document number 2024R-01202; book 345, page 3

Sale fields

These describe the sale itself. For a multi-parcel sale, they only need to be filled in on the first row.

Required

  • county_geoid, sale_date, sale_price, and a recorded document number (see Required fields)

Optional

  • sale_type (Choice) - How the property was sold. One of: auction, listing, private_sale, other. Defaults to listing
  • improvements (Boolean) - true if the sale included buildings or other improvements
  • mls_number (String) - MLS listing number
    • Examples: 11987654
  • comments (String) - Any notes about the sale. Comments from every row in the sale are combined
    • Examples: Sold with 2024 crop rights retained by seller

Example


Parcel fields

These describe each parcel in the sale. Fill them in on every row; each row adds one parcel to the sale.

Required

  • assessor_parcel_number (String) - The parcel number (APN / PIN). Formatting such as dashes and spaces is ignored when matching.
    • Examples: 08-16-200-004, 0816200004

Optional

  • legal_description (String) - Legal description of the parcel
    • Examples: NE 1/4 SEC 16 T40N R5E
  • external_id (String) - Your own ID for this parcel or sale record
Acreage Acres on this parcel by land type. Each defaults to 0 when blank. The sale’s total acres are the sum across all of its rows.
  • dryland_acres (Number) - Non-irrigated cropland
    • Examples: 78.5
  • irrigated_acres (Number) - Irrigated cropland
  • pasture_acres (Number) - Pasture
  • crp_acres (Number) - Acres enrolled in the Conservation Reserve Program
  • wrp_acres (Number) - Acres enrolled in the Wetlands Reserve Program
  • wetland_acres (Number) - Wetland
  • woodland_acres (Number) - Woodland / timber
  • site_acres (Number) - Building site / homestead
  • non_production_acres (Number) - Other non-productive land (roads, waterways, waste)

Example

A single sale of two parcels uses two rows with the same county, sale date, and document number. Sale fields only need to be filled in on the first row:
sale_price is the total for the whole sale, not the price of each parcel. Repeat the same total on every row, or fill it in only on the first row. Every row still needs a value, so repeating it is the safer choice.

Buyer and seller fields

Up to four buyers and four sellers per row. A buyer or seller without a full_name is skipped.

Required

None. A sale can import without buyers or sellers, but we strongly recommend including at least buyer_1_full_name and seller_1_full_name.

Optional

Names
  • buyer_1_full_name (String) - Full name of the first buyer
    • Examples: John A Smith, Smith Family Farms LLC
  • seller_1_full_name (String) - Full name of the first seller
    • Examples: Mary Jones Revocable Trust
  • The same columns exist for buyers and sellers 2, 3, and 4: buyer_2_full_name, seller_2_full_name, and so on
Mailing address Each buyer and seller has their own mailing address. Provide either the single-line address or the broken-out components. These are shown for buyer_1; the same columns exist for every buyer and seller (buyer_2_address, seller_1_address_city, and so on).
  • buyer_1_address (String) - Mailing address, as a single line
    • Examples: 1234 Red St, Sycamore, IL 60178
OR
  • buyer_1_address_line_1 (String)
    • Examples: 1234 Red St
  • buyer_1_address_line_2 (String)
    • Examples: Suite 400
  • buyer_1_address_city (String)
    • Examples: Sycamore
  • buyer_1_address_state (String) - Two-letter state abbreviation
    • Examples: IL
  • buyer_1_address_zipcode (String)
    • Examples: 60178
If an address can’t be read (for example, an unrecognized state or an invalid ZIP code), the buyer or seller still imports, without an address.

Example


Full example

A sale of two parcels, as it would look in a text editor:
Questions about the format, or ready to send a file? Email support@camo.ag.
Last modified on November 20, 2026