Student Digital Reading Log Using Google Sheets

Why Google Sheets

Collecting student reading logs can be such a tedious task.  There are many websites out there that allow teachers to monitor student reading. However, I prefer Google Sheets as it is so easy to provide students with feedback using the Commenting Tool. Also, students and teachers may easily share the reading log with parents, administrators or educators simply by using the Share feature. And, the Google Sheet is also collaborative. If students were researching together then they could share references, ideas and summaries with their partners. Finally, Google Sheets automatically saves in the Cloud which makes it easy for students to track books they read at school and at home. It will never get lost!

Google Sheets Template

The following digital book log allows students to set a goal for how many books they wish to read. In the image below, the student set a goal to read 100 books. As the student updates their reading log on a weekly basis the percentage towards that goal is automatically updated. So for example, the student in the image below read one book today and they have a goal of 100 books. Therefore, they have met 1% of their goal!

Click the image and Make a Copy to modify and edit your digital book log. 

Screen Shot 2017-10-17 at 10.00.07 PM

Ways to distribute the digital book log

  • Google Classroom-Make a Copy for every student
  • QR Code Generator– Post a QR Code
  • Gmail- Share the file with students and email it to them
  • Teacher Website- Post a link to the URL on the teacher’s website. Remember to change the URL ending from “edit” to “copy” which will force students to make their own copies


There are many ways to have students track their reading. But, Google Sheets allows teachers and students to easily monitor progress using the amazing features of Google.

How do your students track their reading?

12 thoughts on “Student Digital Reading Log Using Google Sheets

  1. Cheryl says:

    Is there a way to use this but set it up where students can scan the ISBN and have the title automatically entered?

  2. Katie Smith says:

    Thank you so much! Looking forward to using this with my students through the end of the school year!

  3. Laura Nager says:

    So if the school isn’t using Google Classroom, is there a way for the teacher to see the student’s information? Or must the child’s parent attach a copy in email?

  4. Amanda says:

    Thanks so much for creating this awesome resource AND the tips on how to pass it along to students!
    I’ve created a QR Code for my happy readers to use!

  5. Michelle Adkins says:

    I love this!! I’m looking for some quick and easy ways to get my students to start using Google Classroom without going completely paperless…. I think there needs to be a balance. This is a great way to get them started using a digital reading log and getting rid of the paper reading log. Thank you!!

  6. Katy says:

    I’m just wondering if you’ve got a way to collate the number of hours read, or pages read, centrally on a master sheet? Or do you just go in to each child’s log and look at it individually?

Leave a Reply to Laura Nager Cancel reply