FREE Customizable Printable Egg Production Chart

Tracking your chickens' egg production is not only fun, it's a really good way to monitor the health of your flock. 

Often a reduction in laying is the first sign that something is wrong, since laying eggs takes so much energy out of a chicken, so by keeping track of who is laying what - when - you can sometimes get a jump on anything that's gone awry.

A former accountant, I'm a bit of a spreadsheet freak, I admit! So I created this custom chart that you can use to track your girls' egg production. 
It's a Google Sheet which you will need to download and then save a copy of it in order to enter your own data.  
[Newly updated for 2020 with charts/graphs at the bottom!]
Alternatively, you can print out each month and write in the information by hand - but then all the totals will need to be manually calculated as well - or the data will then need to be entered into the spreadsheet at the end of the month. 
If you have children, you might want to print out the sheet for the month and have them write in how many eggs they collect each day in pencil, then either they or you can input the numbers into the spreadsheet.
To begin using the chart, first you'll want to enter your name or your farm name where the gold words are in brackets [] at the top.  

Then, down the left hand side, you have the option of setting up the categories you want to track. You can replace the [Color/Name] cell on each line with whatever you want. 
Each of your chickens' names, the egg color, the breed, etc. One per line.

If you have a small flock, you might want to enter the name of each hen to be able to count how many eggs she lays each month.

If your flock is larger and you can't match an egg to a specific chicken, you can track your egg production by egg color or breed. 
Or if you have separate flocks, you might track the eggs by coop. It's up to you. Those rows where it says [Color/Name] in gold are for you to customize with what works for you. 

(Note: you only need to type in your categories once - in January - they will auto-fill down the sheet for the remaining months.) 
If you need more lines, you can insert them easily and if there are too many lines, then go ahead and delete them. The formulas should all still work just fine.
And that's it. As you collect your eggs and type in numbers, you will get totals by day, by category, by month and for the entire year at the bottom of the chart. 

Download the Egg Production Chart

IMPORTANT: After you click on the link above and the template comes up, you'll need to click on "File", then "Make a Copy" and save it to your computer. Then you'll be able to edit your spreadsheet.
Remember that no chicken lays an egg every day, so there's no reason to panic if you notice one skip a day here and there, and production naturally slows during extreme heat, the molting season and the shorter days of winter.

But you should be able to see a bit of a pattern over time - and use the chart for fun or an educational tool for your kids, if nothing else. 
And if you have any trouble using the spreadsheet, please email me at

Remember... you need to click on File, then Save As in order to download your own copy of the chat that you can fill in!

Join me here
Facebook | Twitter | Instagram | YouTubeBloglovin
©2017 by Fresh Eggs Daily, Inc. All rights reserved.