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

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:

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.