Spreadsheet: All the Books [in progress]

I got a lot of input for my latest spreadsheet and hence made a lot of changes after sharing it. This time I want to get input before I finish and share it AND have some beta users to prevent errors.

The spreadsheet: All the Books

Usually I have one spreadsheet for every year and as much as I like making a new spreadsheet each year (and I’ll definitely keep on doing it) and love start filling a new one, I always wanted to have just one spreadsheet with all my books: Books that I read, books that I own but are unread, books I want to have. My current ideas for this spreadsheet are:

Tab: All

This will not only be the tab that has a list of all the books but will also be almost the only tab that has to be filled with data by yourself. My current plans include the following values for each book:

• Title
• Series
• Author
• Gender (Author)
• Genre
• Audience
• Format
• Pages
• Publisher
• Published (date)
• Bought (date)
• Rating
• Read (date)
• Fields for up to 9 rereads (dates)

I was thinking of maybe adding a column to mark a book as owned/library copy/… and maybe another column for the expenses. If I add both, I could also calculate how much one saves by getting books from the library. My 2016 spreadsheet also has a Tag column which I could add again.
(If you wish to have any of these features, please mention them in the form below)

Tabs: filtered lists

As of right now there will be three additional tabs that filter the previous list of all books:

• TBR: will list all books that you own (=the date for Bought is set) but are unread
• Wishlist: books you want to read but don’t own yet
• Filtered: this list will be a list filtered by a given year. Only books (re)read that year will be listed

Other lists that I currently don’t intent to implement but could if people want to:

• A list of books released in a give year
• A list of books acquired in a given year

(If you wish to have any of these lists, please mention them in the form below)

Statistics

I intend to have three different tabs for statistics: one for all books and one for just a given year (according to the date you read the book). These two will both show roughly the same kind of statistics:

• Number of books read*
• Pages read*
  • Distribution of how many books have how many pages
  • Biggest/smallest book
  • Average number of pages/book
• Number of books acquired and expenses*
• Number of series/standalones
  • how many 1st/2nd/3rd/… books in series
• Number of different authors and most read author
• Distribution of format, genre, audience, gender, rating, publisher and publication year

Maybe I will also add a feature so you would be able to choose two different categories of the listed above and their values and get stats on those. Another idea would be to have a tab that lists all authors and how many books they each have in the list.

*overall as wells as monthly/yearly overview

A third tab shows statistics about the TBR (owned but unread books):

• Number of books
• Number of pages to read
• Average number of days since the book was acquired
• Distribution of format, genre, audience, gender, rating, publisher and publication year

Goodreads Import

As it would be quite a lot of work to enter every book into this spreadsheet, I’m going to make it possible to import your GR data.

These are all the things I intend to implement so far (minus the additional ideas I listed, those are just maybes). I might add more while I’m working on it and I’m always open for more ideas.

If you have any suggestions and/or want to be a beta user, please fill out this form.