Blogmas

#Blogmas Day 19 I I Made a Reading/Blogging Spreadsheet

Hi bookworms! For the last couple of years I’ve been tracking my reading using a spreadsheet, and its been incredibly fun. I like seeing all the stats and charts at the end of the year – What genres am I reading? How many pages? What are the author demographics, etc?

And most importantly – how much am I spending on books? The answer is too much. The answer is always too much. πŸ˜‚πŸ˜‚πŸ˜‚

But, I’ve never found a spreadsheet that is exactly what I need/want so I decided to make my own. And, because I love it so much and I’m so excited about how it turned out, I wanted to share it in case anyone else is interested in using it. Any bookworm can use this – you do not need to be a blogger or want to track your blogging stats. (The Blog Stats and Blog Posts tabs can be hidden/deleted without messing with the other tabs.)

**You can get your own copy here**

⚠️ DO NOT rename the sheets or enter information where it doesn’t belong – it will break the formulas. All the charts and tables on the Reading Stats page auto populate and there are only a few places where you need to manually enter information on the Blog Stats page. ⚠️ 

There are 7 tabs on the sheet:
1. Reading Stats
2. Blog Stats
3. Books Read
4. Books Hauled
5. TBR
6. Blog Posts
7. Categories

READING STATISTICS

The first tab of the spreadsheet is your 2020 Reading and Acquisition Statistics. The ONLY things you need to fill out on this first page are:

1. Reading Challenge Goal
2. TBR at the Start of the Year
3. Monthly Budget

Everything else in the spreadsheet on the Reading Stats page will be auto completed from your Books Read and Books Hauled pages.

BLOG STATISTICS

The second page of the spreadsheet is your Blog Statistics page. The ONLY things you need to fill out on this page are:

1. Your views, visitors, likes, and comments for the Overall Blog Stats.
2.Your follower counts for the beginning/end of each month. The growth will calculate automatically, and the chart will pull from that column.

The other charts will auto populate from the Blog Posts tab.
If you do not want to track your blog/do not have a blog, you can delete this tab.

BOOKS READ

This page is where all the information for the 2020 Reading Statistics is pulled from. All of the drop downs are created from the lists on the Categories tab.

BOOKS HAULED

This page is where all the information for the 2020 Acquisition Statistics is pulled from. All of the drop downs are created from the lists on the Categories tab. The tables to the right will auto populate from the information you list – you do not need to manually calculate any of the information.

TBR

This page is where you will track all of the books you own as of 1/1/2020. All of of the drop downs are created from the lists on the Categories tab. Both charts auto populate from the information you list – you do not need to calculate the tables yourself.

Make sure that your Total TBR matches the TBR total you entered on the Reading Stats tab.

BLOG POSTS

This where all the information for the 2020 Blog Statistics page will pull from. You will have to manually enter the Views, Likes, and Comments from your blog dashboard. If you do not want to track your blog/do not have a blog, you can delete this tab.

CATEGORIES

This is arguably the most important tab in the whole spreadsheet. All the items listed here are used to create the tables/charts on the Reading and Blogging Statistics pages and the drop down menus on the Read, Hauled, and Blog Posts pages. You can use the lists I’ve already created or enter your own information. You can enter as many items as you want until you run out of white cells. The purple cells and beyond will not populate into the drop down menus or the tables/charts. Once you create your list and start choosing from your drop down menus, DO NOT re-order your menu items or re-name them. It will affect the information you chose on the Books Read, Books Hauled, and Blog Posts.

So there you have it! Here is my the spreadsheet I created for tracking my reading for 2020.

**You can get your own copy here**

To save a copy of the spreadsheet, you need to open the file, click File–> Make a Copy. Then you’re ready to go.

This spreadsheet is free for any bookworm to use. If you have questions about using this spreadsheet, I will do my best to help.

If you use this, I’d love it it you would credit me. And maybe give me a follow on Twitter or Instagram. πŸ™‚

Happy Reading β™₯

20 thoughts on “#Blogmas Day 19 I I Made a Reading/Blogging Spreadsheet

    1. Thank you! And, I totally get that. They can be a little intimidating. But, luckily the formatting is all down for you – so you should just have to enter your books, and then the charts will auto populate.

      And, if you run into trouble, I’m happy to help! πŸ™‚

      Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s