Cattle auction prices in Excel

USDA AMS cattle auction reports come as PDFs and text. Our API returns one row per lot as CSV, so Excel can load it straight from a link and refresh it later.

Load it

  1. In Excel, go to Data, then From Web (in the Get & Transform group).
  2. Paste this link and click OK:
    https://api.kossinlabs.com/v1/prices?state=TX&class=STEERS&weight_min=500&weight_max=700&limit=200&format=csv&api_key=kl_free_demo_2026
  3. If Excel asks how to connect, pick Anonymous. Then click Load.

You get a table of Texas feeder steers, 500 to 700 lb, newest first. Data, Refresh All pulls the latest sales. kl_free_demo_2026 is a free demo key for trying it out.

Head-weighted average $/cwt

If the table is named prices, this gives the average price weighted by head, counting only per-cwt lots:

=SUMPRODUCT(prices[head_count], prices[price_avg], --ISNUMBER(SEARCH("Cwt", prices[unit])))
 / SUMPRODUCT(prices[head_count], --ISNUMBER(SEARCH("Cwt", prices[unit])))

Weighting by head keeps a 2-head lot from counting as much as a 36-head one. Rough lot value: =[@weight_avg]/100*[@price_avg]*[@head_count].

What one lot looks like

A real row from Cattlemen's Livestock Auction (TX) on Nov 12, 2026:

auction_name,state,report_date,class_name,grade,unit,head_count,weight_avg,price_avg
Cattlemen's Livestock Auction,TX,2026-11-12,STEERS,Medium and Large 1,Per Cwt / Actual Wt,36,515,443.37

(Some columns left out to fit.) Check the unit column, because some replacement lots are priced per head. More on units: cattle price per cwt.

Change the filters

Edit the link under Data, Queries & Connections, or just add a new query. Full list: api.kossinlabs.com. Other ways in: Google Sheets, Python, R, plain CSV.

Your own key

The demo key is shared. Get your own free key in one click, or Starter is $29/mo for higher limits: subscribe. 30-day money-back guarantee. Product page: cattle auction prices API. Source: USDA AMS Livestock, Poultry & Grain Market News (public). We are not affiliated with USDA.