Homebrewing Spreadsheets – Brewing Spreadsheet, Brew in a Bag and Small Batch

homebrewing spreadsheets

Homebrew recipe and brew day software can be handy.  Something like BeerSmith or BrewfatherFree Non-Expiring Brewfather Trial Account – can be invaluable for creating recipes, figuring SRM, figuring IBUs, fitting beers into established styles and lots more.  Some are BeerSmith power users and track every recipe and every brew day in this great software.

Sometimes you just want to brew.  It’s a recipe that you’ve brewed before, something you’re putting together on the fly, or you just want something quick and easy to tell you temperatures and volumes.  Even though I have and use recipe software, I just find it easier to use brew day spreadsheets to track each individual beer.  I’ve developed three that I use in different situations.

The formulas in these spreadsheets are tried and true.  I’ve used them myself for years.  Hundreds, maybe thousands of homebrewers have used them too.  I’ve taken feedback and tweaked and corrected things over time.

  • My Brewing Spreadsheet – written from the batch sparge perspective, although variable can be modified to work with fly sparging.  Figures water volumes, strike water temperatures, projects volumes, helps you correct gravities and more.  If you’re batch sparging, your brew day is presented in narrative step by step directions.  A one page printed brew day summary is also created from your recipe letting you know what to do at each step and giving you something to write notes on.
  • BIAB Brew Day Spreadsheet – similar to my original beer making spreadsheet but tweaked for Brew in a Bag/BIAB style brewing.  This spreadsheet has an anytime gravity estimate and correction calculator to help you project and correction gravities.  Instead of a one page summary, the entire spreadsheet is setup to print out on a single  8 1/2 by 11 piece of paper.  You still get narrative step by step directions.
  • Small Batch BIAB Spreadsheet – Brew in a Bag, but this time a simplified version for small batch BIAB brewers.  This is designed to make homebrewing easy and the post contains a step by step how to for brewing small batch all grain homebrews on your stovetop.

Need More?

My brew day spreadsheet helps you calculate water volumes and temps and helps you do simple tracking.

If you’re looking for a powerful, full featured solution for building recipes, brew day tracking and loads more, consider Brewfather.

Pinned: Black Friday Roundup!Amazon Black FridayKeg Rebuild

More: Our Last Fifty Finds!


Always use caution when dealing with hot liquids and electricity.  Make sure the components you use are compatible and rated for your intended application.  Contact manufacturer with questions about suitability or a specific application.  Always read and follow manufacturer directions.

Homebrew Finds makes no representations as to accuracy, completeness, currentness, suitability, or validity of any information in this article and will not be liable for any errors, or omissions in this information or any losses, injuries, or damages arising from its display or use. All information is provided on an as-is basis. To use Homebrew Finds you must be 21 years or older

This is a Top Post! See: All Top Posts – toppost:homebrewspreadsheets tag:tpr

Leave a Reply