Caffeine level easy comparison in Excel

How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet.

The Guardian’s Datablog has interesting analysis of caffeine levels in different foods.

Sounds boring until you read that:

  • reduced sugar colas have almost double the caffeine of a regular, sugared, cola.
  • 1 cup of coffee can have as much caffeine as 2 cups of tea (depending on the brew time)
  • a single Red Bull can has less caffeine

They’ve published the original US FDA data in a Google Docs spreadsheet which can be exported to Excel (File | Download | Microsoft Excel)

In Excel you can format and chart the data as you’d like:

So grab a cup of coffee and Excel your heart out!

Quick stock price analysis and charts with Excel StockHistory()
Google Sheets gets 10 million cells, not enough to beat Excel
Fancy gridlines to make Excel look great or at least different. 
Putting Health Data into Excel

Join Office for Mere Mortals today

Office for Mere Mortals is where thousands pick up useful tips and tricks for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  We've never spammed or sold addresses since we started over twenty years ago.
Invalid email address