Do you have chickens? Do you like spreadsheets? Then I have the Egg Laying Spreadsheet for you! No really, joking pitch aside, I have created this free chicken tracker and egg production spreadsheet for you. You can scroll to the bottom of the directions to get your free egg laying and chicken production spreadsheet if you aren’t into reading about the spreadsheet. There is also a link copy that shows you what it looks like with data.
Who is this chicken tracker and egg laying spreadsheet for?
Both the home hobbyist, the small farmer, and geek extraordinaire.
Truth time: I made this chicken egg production spreadsheet for myself because I am a geek and wanted to know if my chickens ever broke even, cost-wise, when I sell their excess eggs (Spoiler: I’d keep the chickens anyway). I love tracking all types of things, but I just cannot do it on paper. I like using Google Sheets because they are free and easily accessible from my phone. Right now I am offering the chicken tracker and egg production spreadsheet only as a Google Sheet. However, if you desperately need this Egg Laying Spreadsheet in an excel format let me know in the comments. If there is enough interest I’ll convert it for you.
I envision a number of enhancements for 2019! But I wanted to get it out there for other people to use this year and give me feedback about what else they might want to see.
Here is what the Egg Laying Spreadsheet contains:
- At a glance chart (auto fills)
- Summary statistics, example: average eggs per hen, eggs per month (autofills)
- Chicken Log
- Egg Log
- Expense Tracking (optional)
- Income Tracking (optional)
Best Part! You enter you expenses, income, and eggs in each sheet and the statistics and charts automatically update! Booyah!
Egg Laying Spreadsheet Dashboard
My day job is in Business Intelligence so I know people need a variety of ways to digest data. For visual learners the Egg Laying spreadsheet starts with some at-a-glance charts. First you can see how your monthly profit is going and how your running year-to-date profit is headed. Trust me, the fake data you see below is nothing like my actual profit… Which is well below zero this year.
My favorite part are the egg spreadsheets. Even if you have no interest in profit and loss you can see your total eggs, egg size, and color all compared!
Chicken Summary Statistics
Need more numbers? Average eggs per hen? Year-to-date profit on your chickens? Then the Summary Statistics page in the Egg Laying Spreadsheet is all for you. All items automatically populate from the items you enter in the next few sheets.
This is the main portion of the spreadsheet. It started as a place to keep information about all of our new chicks but has evolved to meet a variety of your needs. The whole spreadsheet links from knowing when your chicks start laying, if they died or were sold, and other notes. The key fields that need to be filled in correctly for the Egg Laying Spreadsheet to work:
- Laying Date
- Death/Sale date if applicable
This is the fun spreadsheet! I simply pull this sheet up on my phone when I collect eggs and put in the numbers. It is pretty simple, just put how many eggs of each type and color in the appropriate slots. The totals will auto-calculate for you and update the summaries and charts as you go. I have left what exactly goes in sizes and colors up to you. I tend to put cream eggs with white and tan eggs with brown, etc. but that decision is up to the individual chicken owner. Pro-tip: you can put in total eggs, and skip color and sizes but you will lose you size and color charts.
Expense & Income Tracker
For those chicken owners that want to get a little more into the numbers the expense and income sheets exist. I have some suggested categories for chicken owners, but in reality you can put whatever you want. I am hoping to add more statistics and charts based on the categories in the future. Some examples I am considering: Cost of each egg per amount of feed, Average Carton Price, etc.
If you are a hobbyist and just want to look at how many eggs you have, you can skip these pages or fill out the bare minimum:
Categories that must be filled out are marked with an asterisk *. Filling those columns in is all that is required to use the Chicken Egg Tracking Spreadsheet. I really want feedback from you about what else you might want this spreadsheet to do. Please let me know in the comments and if you found it useful then please share this on social media.
Empty Chicken Tracker You Can Use This sheet will prompt you to make a clean copy ready for you to fill in with your information.
Example Chicken Tracker and Egg Laying Spreadsheet with Data Use this sheet to view how you might want to fill your in
I spent a lot of time creating something I thought might be of value to you, chicken owners, and would like to have your feedback. Please let me know in the comments what other items you might want to see in the spreadsheet. I’ll see about future enhancements for later this year!