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.
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
- 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
- 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: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
- buyer_1_address (String) - Mailing address, as a single line
- Examples: 1234 Red St, Sycamore, IL 60178
- 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.

