My favourite a part of any new yr is taking the time to arrange my new studying log to trace my studying for every year. It’s all the time a pleasure to craft and refine this Sheets-based log for higher studying monitoring, and it looks like regardless of how completely satisfied I’m with the log at the starting of the yr, I all the time have just a few tweaks for it at the finish of the yr! The adjustments for 2023 are fairly minimal, however I hope they’ll present much more clarifying and monitoring energy. And as all the time, you’ll be able to tweak it to fit your personal wants and monitoring wishes. Click right here to entry the 2023 Reading Log.
Because Google Sheets has made just a few enhancements and totally different design decisions this yr, I’m completely satisfied to stroll you thru how you can use, edit, and refine the Reading Log to personalize it to your tastes and studying habits. While there are lots of superior options, you’ll be able to all the time delete or conceal the ones that you simply don’t need to use or discover distracting. I like to recommend hiding slightly deleting, although — generally sure values are related to different options, and also you don’t need to make a giant mess of code!
About the Log
The studying log is inbuilt Google Sheets. When you click on the hyperlink above to entry it, you will notice a clean log that can not be edited. Please don’t ship me a request for edit entry. This is the clean grasp log, and you’ll get hold of a replica of it by clicking File -> Make a Copy. Then, you’ll identify the doc no matter you need and put it aside to your private Google Drive. (You should have your individual Google account and be logged in to take action.) This permits you to preserve your log in the cloud so you’ll be able to entry it wherever you go, and it will likely be solely accessible by you, or whomever you share the file with.
Tracking Power
If the log seems to be like a LOT, don’t fear! You don’t have to make use of it to its fullest extent. Simply decide and select what works for you. I like to recommend hiding the columns and rows you’re not occupied with utilizing, however if you wish to use all the options, go wild! Each drop down menu and column might be edited and personalised to trace all the pieces from books, studying habits, creator and creator demographics, and variety illustration. Plus, there’s a useful tab for monitoring your Read Harder progress, and a tab for monitoring your e-book spending.
Editing the Log
This log is impressed by numerous suggestions, a number of samples on-line, and my very own whims in the case of monitoring my studying. Therefore, how I take advantage of it may not be the way you need to use it, and that’s okay. I attempted to incorporate as many choices as potential, however I extremely encourage you to make it your individual. I discover it thrilling to set it up every year and to mirror on what my studying reveals me at the finish of the yr, so I extremely suggest taking the time to make it give you the results you want.
If you’d like directions on how you can edit it, watch my YouTube video walkthrough, which explains a few of the capabilities and the way they work, and reveals you how you can add or change wording and options. The excellent news? It’s a LOT simpler to edit than it was once, due to some Sheets updates that went into impact in 2022.
Unfortunately, I’m not ready to reply to each single request for assist attributable to the excessive quantity of emails I obtain and my busy schedule. Please do let me know for those who see an error or run into points, however I like to recommend trying out the video for troubleshooting, and making an attempt to resolve your drawback through the Google Sheets assist boards first. Happy studying!
Want to see how the log has developed over the years? Check out the 2020 log, the 2021 log, and the 2022 log!
Discussion about this post