Bookish Odds & Ends, Discussion Posts, Features

Bookish Spreadsheet Templates: 2019 Reading & ARC Tracking Spreadsheets

all about (3)

Midway through 2018 I started utilizing Google Sheets to keep myself more organized in my blogging & reading life.  I really wish I had started using spreadsheets sooner!

At the start of 2019, I decided to revamp my spreadsheets.  Not only that, I decided to share a a few of my spreadsheet templates with you all!

Divider2

I would like to mention that I did not come up with the idea to keep a spreadsheet for reading or for keeping track of ARCs.  I’ve seen many bloggers share their own spreadsheets over the years.  I’ve basically taken ideas from various other spreadsheets to create my own.

I should also mention that this spreadsheet was created in Google Drive.  In order to download these spreadsheets, you’ll need your own Google account.

The first spreadsheet template I am going to share is a reading spreadsheet.  This particular spreadsheet is tailored to someone who reviews books, but can easily be tweaked by deleting columns to those who do not review books.

readingspreadsheet

Some of the information that I include on my reading spreadsheet:

  • Book title
  • Author name
  • Status (unread, reading, read, DNF)
    • DNF stands for Did Not Finish
  • Month read
  • Review status (no review, not started, drafting, scheduled, published)
  • Format (paperback, hardback, eBook, audiobook)
  • Source (own, library, ARC, borrowed)
  • Genre
  • Target audience (adult, YA, or MG)
  • Page number
  • Series or standalone
  • Book number in series (if applicable)
  • Star rating

This is the information that I personally like to keep track of.  Like I mentioned, you can easily delete or add columns to customize this spreadsheet to your needs.

But wait!  There’s more!

If you notice there is another tab on my spreadsheet template titled “ARC tracking spreadsheet”

Not only do I have a reading spreadsheet, I have a spreadsheet to keep track of ARCs!  For those of you that don’t know, ARC stands for advanced reader copy.  ARCs are pre-published books that publishers send out to reviewers in exchange for an honest review.  You do not have a blog in order to be eligible to receive ARCs.  You simply need some type of social media platform in which to share your reviews: Twitter, Instagram, Facebook, Goodreads, etc.

Anyways!  Here is a look at my ARC tracking spreadsheet…

arc-tracker-template-e1546743750307.png

The information I include on my ARC tracking spreadsheet:

  • Book title
  • Author
  • Status (unread, reading, read, DNF)
  • Publishing date
  • Review status (not started, drafting, scheduled, published)
  • Genre
  • Format (print or eBook)
  • Source (author, publisher, NetGalleyEdelweiss, other)
  • Source follow-up
    • Did you post to NetGalley?  Did you send the publisher (author) an email with the review link?
  • Publisher
  • Star rating

To access these spreadsheet templates, click here ⇒ Cover2CoverMom’s Reading & ARC Tracking Spreadsheet Templates

Directions to copy these spreadsheets:

  1. You’ll need to copy the spreadsheet to your own Google Drive.  In your own Google Drive, open a new spreadsheet. You will need to name the spreadsheet – located in the top left corner of the spreadsheet.
  2.  Come back to this post and click the Spreadsheet Link above.  At the bottom of the spreadsheet there are two tabs labeled “Reading Spreadsheet Template” and “ARC Tracking Template.”  Click on the tab of the spreadsheet you want to copy.  On that tab, click the little triangle to the side of the tab label.  From that menu, you select “Copy to…”

screenshot 2019-01-05 at 11.18.10 pm

3. Once you hit the “Copy to…” button, a box will pop up.  From this box, you should see the new spreadsheet you had just created and named.  Select that spreadsheet.

screenshot 2019-01-05 at 11.29.31 pm

4. Now the spreadsheet is copied into your Google Drive!  Simply go and open your spreadsheet, and you’ll see a new tab with the copied spreadsheet.

5. Repeat these steps to copy the other spreadsheet if you would like both spreadsheets.

Divider2

LetsChat

Do you use spreadsheets to keep track of your reading and/or ARCs?

Would you add any data to my spreadsheets?  If so, what?

Comment below & let me know 🙂

7 thoughts on “Bookish Spreadsheet Templates: 2019 Reading & ARC Tracking Spreadsheets”

  1. I don’t use a spreadsheet to track my reading, but I’ve thought about it. I track all my blog stuff in Microsoft OneNote. I have a new tab for each book review and related details. But I means I don’t get to do any data dumping and charting… which, honestly, might be fun! I might use this. Thank you for sharing!!

    That said, I do use a spreadsheet to track my blog posting. It helps me visualize what I need to do to stick to my goals. I really enjoy that spreadsheet, so I’ll probably enjoy this one too. Thanks.

    Like

  2. The big scary task is making the spreadsheet of all the books you OWN. However, I’d argue it’s not as scary as it sounds. Touching and looking at my books makes me very exciting and wishing I could just lay on the books and read them through osmosis.

    Like

  3. Ahhh your spreadsheets are so great Amanda, love them! I also like to use spreadsheets, but I’m only using one for blogging and one to track my ARCs, I don’t use a reading spreadsheet at all… I might be a bit lazy, because I often forget to update my goodreads, so that spreadsheet would be a mess 😂

    Like

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.
https://cover2covermom.wordpress.com/2019/01/21/bookish-spreadsheet-templates-2019-reading-arc-tracking-spreadsheets/
cover2covermom.wordpress.com
crawl=CC-MAIN-2019-47
137804
application/http; msgtype=response
sha1:I5R227ARME3ETZ2RM4VV62IABFXOV23Z
<urn:uuid:6af23f35-c15c-4309-b255-5761b42230c9>
2019-11-19T02:42:34Z
192.0.78.13
text/html
sha1:GB2QFWIJHTCQR24WAHHFEGUFQHYOHPQJ
<urn:uuid:4205079c-81b9-451e-88f7-7d442d7f3b2b>
https://cover2covermom.wordpress.com/2019/01/21/bookish-spreadsheet-templates-2019-reading-arc-tracking-spreadsheets/
response
<urn:uuid:4d30abd2-2b5f-4a75-ba66-033bfc4fe444>
isPartOf: CC-MAIN-2019-47
publisher: Common Crawl
description: Wide crawl of the web for November 2019
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-5.ec2.internal
software: Apache Nutch 1.16 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/