Spreadsheet Love

I’m not sure if I’ve ever mentioned it on here, but since the summer of 2014 I’ve been keeping track of the books I’ve read in an Excel spreadsheet. Since I got a new computer, I’ve not got Microsoft anymore, but instead installed OpenOffice; my spreadsheets were transferred to there.

Ever since reading a post by Carina on her blog about the spreadsheet she uses to keep track of her reading (and sharing the spreadsheet with the world), I realized it was about time I updated mine to include a few more features.

I really liked the layout Carina used for her spreadsheet, but I wanted something to keep track of all my books, plus all the books I’d read that weren’t mine. So, the formula fun began! H

Here are the different tabs I now use and the way in which they fit with what I want.

pic 1This is the first tab “general”. Here I can find an overview of the total amount of books I own, how many of those I’ve read, male/female authors, total spending (which is skewed, because mostly the prices aren’t on the books anymore), different languages, and audiences.

pic 2

The second tab is 2014, but since I’ve only kept track since summer 2014, it stars halfway, therefore a picture of 2015. Here you can see the amount of books I’ve read this year. As you can see there’s read (own) and read (other), so I can keep track which books go off my TBR (more on the own/other later). As a lot of the formulas need something to fall back on, it’s not been possible to fill this out halfway through the year (ok, it’s possible, but I’ve been too lazy for those calculations). Thus, a lot is still empty. That should get better in 2016.

pic 3

“2016”, the green bits indicate numbers that need to be filled in by hand. Everything else is generated automatically. I think the white parts are the most important: the total books read, and the TBR I started with for the year.

pic 4

The next tab is “books”. These are all the books that I own, with the necessary information. With the sort function in OpenOffice, it’s easy enough to sort through them and pick my next read.

pic 5

To not make the tabs names too long, I’ve simply called this one “read”. However, these are not all the books I’ve read. These are only the books I’ve read and don’t actually own (or are in eBook and audioBook format). This way, I can keep track of all the books I’ve read, but also am able to easily sort through the books I own, without the two lists becoming confusing.

If you have any questions or would like the formulas or anything, let me know, I’ll be happy to send it to you!

5 thoughts on “Spreadsheet Love

Add yours

  1. Hi Myrthe,

    This is so inspiring!
    I am keeping track of books I have read in a spreadsheet too. But only the ones I have read and maybe it has too many details. Have to reduce that in 2016.

    Thanks for the inspiration!

    Greetings by Sophie

    Liked by 1 person

    1. Yea, too much information can be quite overwhelming (and frustrating) to keep track of. I’ve added a couple of things since I’ve posted this, but only minor things. Like, how many books of a certain language I’ve read. I’m weirdly excited to start the new year with a fresh spreadsheet 🙂

      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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: