Cattle auction prices in Google Sheets
You can load US cattle auction prices straight into a spreadsheet. No copying from PDFs. Paste one formula into cell A1 and Sheets fills in the lots from USDA AMS auction reports.
The formula
=IMPORTDATA("https://api.kossinlabs.com/v1/prices?state=MO&class=STEERS&weight_min=500&weight_max=700&format=csv&api_key=kl_free_demo_2026")
That returns Missouri feeder steers between 500 and 700 lb, newest sales first. kl_free_demo_2026 is a free demo key for trying it out.
Change what you pull
state=NE: any two-letter state.class=HEIFERS: STEERS, HEIFERS, BULLS, COWS and so on, as AMS writes them.weight_min/weight_max: your weight band in pounds.date_from=2026-11-09&date_to=2026-11-11: a date range.limit=200: how many rows.
What comes back
One row per lot, with columns A to Q: id, slug_id, auction_name, state, report_date, category, class_name, grade, unit, head_count, weight_min, weight_max, weight_avg, price_min, price_max, price_avg, comments. A real row from Nov 11, 2026:
South Central Regional Stockyards, MO, 2026-11-11, FEEDER CATTLE, STEERS,
Medium and Large 1, Per Cwt / Actual Wt, 29 head, 508-544 lb (avg 531),
$455-$470/cwt (avg $463.16), Value Added
Handy formulas on a second tab
If the import sits on Sheet1:
- Head-weighted average $/cwt:
=SUMPRODUCT(Sheet1!J2:J,Sheet1!P2:P)/SUM(Sheet1!J2:J) - Rough value of each lot (in column R of Sheet1):
=(M2/100)*P2*J2. For the row above that is about $71,300.
Check the unit column first. Most feeder lots are per cwt, but some replacement lots are per head. More on the math: cattle price per cwt.
Excel
Use Data, then From Web, and paste the same URL (without the IMPORTDATA wrapper). Excel reads it as a CSV table you can refresh.
No key, just a look
The same trick works on the keyless sample of the latest feeder lots: =IMPORTDATA("https://api.kossinlabs.com/v1/sample?format=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. Docs: api.kossinlabs.com. Product page: cattle auction prices API. Source: USDA AMS Livestock, Poultry & Grain Market News (public). We are not affiliated with USDA.