Edit: We now have a 2024 Version Available!
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 in 2018 and now use this post to show you how to fill it out. We have updated it over the years and it tracks all your poultry, not just chickens. However, the guide below will still get you started. If you need the newest version see the link at the very top of the page!
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 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 poultry 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.
We have had a number of enhancements over the year thanks to people like you! Please keep giving us your feedback about what else you 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)
- Poultry 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!
Poultry Summary Statistics
Need more numbers? Average eggs per hen? Year-to-date profit on your chickens, quail, ducks? 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 and is far expanded beyond the view you see below.
Poultry Log
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
- Type of Animal
Those three items will automatically calculate if you have a laying chicken, duck, or quail hen. It will stop counting if you have sold or the hen passed away. Don’t worry you can track your roosters, they just won’t count in your hen totals.
Egg Log
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. The newest charts include species and egg size tracking. Pro-tip: you can put in total eggs in the EZ total column (not shown), and skip color and sizes but you will lose your size, color, and species 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:
- Date
- Amount
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.
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!
