is part of the Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

  • American Agriculturist
  • Beef Producer
  • Corn and Soybean Digest
  • Dakota Farmer
  • Delta Farm Press
  • Farm Futures
  • Farm Industry news
  • Indiana Prairie Farmer
  • Kansas Farmer
  • Michigan Farmer
  • Missouri Ruralist
  • Nebraska Farmer
  • Ohio Farmer
  • Prairie Farmer
  • Southeast Farm Press
  • Southwest Farm Press
  • The Farmer
  • Wallaces Farmer
  • Western Farm Press
  • Western Farmer Stockman
  • Wisconsin Agriculturist

Convert Those Pesky Metric Measurements

Easy spreadsheet makes conversions simple and offers range of options.

Agriculture is becoming more global every day and the system of measurement is not consistent around the world. Reports come in about export shipments and production values in tons, kilograms, pounds, bushels, hectares, acres and more. Converting these values to a common measurement can be a challenge to the most number savvy and downright impossible for some. Iowa State University has a simple and easy to use spreadsheet that will allow the user to convert everything from simple linear measurements all the way to crop prices in different currencies. Keeping all of these conversions in one place allows the user to make conversions to any set of reported information and put it into term that make sense.  

William Edwards and Ann Johanns developed the spreadsheet to simplify the process of converting between different measurements, prices, currencies, temperatures, and even application rates all in one place. Overseas travel and the need to convert USDA reports to English measures have increased the need for these simple conversions in an easily understood format. This spreadsheet covers nearly all of the important conversion factors that today's agriculturalist will need. These conversions are a necessary tool in every farmer's toolbox as agriculture increases its global interactions.

We're featuring the spreadsheet as our Farm Futures Spreadsheet of the Month. The 121-kilobyte spreadsheet should work with Excel 2000, 2002, 2010 or Excel XP. You can download it by using the link below.

Do you have a spreadsheet that's made a difference on your operation that you'd be willing to share with other readers? Drop us a line at with a description of the spreadsheet. We'll pay $75 if we feature your farmer-written noncommercial program as our Spreadsheet of the Month.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.