{"id":7384,"date":"2026-10-02T14:48:32","date_gmt":"2026-10-02T14:48:32","guid":{"rendered":"https:\/\/templacity.com\/book-tracker-spreadsheet\/"},"modified":"2026-11-18T00:46:56","modified_gmt":"2026-11-18T00:46:56","slug":"book-tracker-spreadsheet","status":"publish","type":"post","link":"https:\/\/templacity.com\/es\/books\/book-tracker-spreadsheet\/","title":{"rendered":"Book Tracker Spreadsheet 2027: Free Google Sheets + Excel"},"content":{"rendered":"\n<aside class=\"tldr\" aria-label=\"Summary\">\n  <span class=\"tag\">Tl;dr<\/span>\n  <ul>\n    <li>Five free book tracker spreadsheets worth copying for 2027, our own included: a <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/14MKOvz5g6uwyXCqlt1pncmS2k_bUs-294cRlEW7IaCw\/copy\" target=\"_blank\" rel=\"noopener\">Google Sheets copy<\/a> or a <a href=\"https:\/\/templacity.com\/wp-content\/uploads\/2026\/08\/templacity-book-tracker-template-excel.xlsx\">direct Excel download<\/a>, ranked by what survives past March, not what photographs.<\/li>\n    <li>Ours needs no new file for 2027: the dashboard reads the year from today&#8217;s date, so it flips on 1 January and your 2026 log stays in the same workbook.<\/li>\n    <li>The \u00absource\u00bb column is the one most templates miss; it&#8217;s the field you&#8217;ll read most when picking what to read next.<\/li>\n  <\/ul>\n<\/aside>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">Why this matters<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"book-tracker-vs-reading-tracker-the-small-distinction-worth-knowing\">Book tracker vs reading tracker: the small distinction worth knowing<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00abBook tracker spreadsheet\u00bb and \u00abreading tracker spreadsheet\u00bb are mostly synonyms; the SERP for both shows the same set of files. But there is one subtle difference in how the makers frame them. A book tracker treats each row as a record of a book (the object): title, author, format, source, where it lives on your shelf, lent-to status. A reading tracker treats each row as a record of the act of reading (the verb): started, finished, rating, notes. The first leans toward inventory; the second leans toward journal. If you have 600 books on a wall of shelves and want to know what you own, you want a book tracker. If you want to know what you finished this year, you want a reading tracker. For most readers, the answer is both, and a single sheet with seven columns covers both jobs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The longer version of this discussion lives in our <a href=\"\/books\/reading-tracker-spreadsheet\/\">reading tracker spreadsheet pillar<\/a>, which compares the same field of free Google Sheets in more depth. This piece is the book-tracker entry: leaner, with picks sorted for the \u00abI want to track the books I own and have read\u00bb use case, not just the reading history.<\/p>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">The free sheet<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"the-free-templacity-book-tracker-spreadsheet-copy-it\">The free Templacity book tracker spreadsheet (copy it)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you came here for a book tracking spreadsheet or a book spreadsheet template to copy, not a comparison, here it is. Copy the Templacity book tracker to your own Google Drive and start adding rows. It logs title, author, genre, format, status, start and finish dates, pages, a 1 to 5 rating with an auto star column, where the book came from, and notes, plus a dashboard tab with a yearly goal, a progress bar, and at-a-glance stats. A separate To Read tab holds the books you own or want but have not started, with a priority and where you heard about each one, so the TBR pile and the reading log live in one file. There is no year-tagged file to re-copy every January, the single thing that splits most free trackers&#8217; history, Elaine Howlin&#8217;s included.<\/p>\n\n\n\n<aside class=\"tool-card tool-card--promo\" aria-label=\"Free book tracker spreadsheet\">\n  <header class=\"tool-head\">\n    <span class=\"tag\">Free sheet<\/span>\n    <h3>Copy the book tracker spreadsheet<\/h3>\n    <p class=\"muted\">One click and it lands in your own Google Drive, so you will need a free Google account. Would rather keep it offline? <a href=\"https:\/\/templacity.com\/wp-content\/uploads\/2026\/08\/templacity-book-tracker-template-excel.xlsx\">Download the Excel version (.xlsx)<\/a>, the same five tabs with the formulas live. No email to us, nothing to pay, and no year-tagged file to re-copy every January. The Google Sheets copy survives the trip to Excel too: we downloaded it through File, Download, Microsoft Excel and every one of its several hundred calculated cells came back as a working number, with no error cells, because it is built without XLOOKUP, TEXTJOIN or LAMBDA. <a href=\"\/free-google-sheets-templates\/\">The rest of our free Google Sheets templates<\/a> copy the same way.<\/p>\n  <\/header>\n  <a class=\"buy\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/14MKOvz5g6uwyXCqlt1pncmS2k_bUs-294cRlEW7IaCw\/copy\" target=\"_blank\" rel=\"noopener\">Make a copy in Google Sheets<\/a>\n<\/aside>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What happens on 1 January 2027.<\/strong> Nothing you have to do. The dashboard&#8217;s \u00abShowing year\u00bb cell reads the year from today&#8217;s date, so the goal bar, books finished, pages read and the month-by-month chart all start counting 2027 on their own. Your 2026 rows stay in the same My Books tab, and the all-time totals keep adding them in. To look back at last year, type 2026 into the Showing year cell; to change your target, edit the reading goal cell beside it (it starts at 24). Year-tagged trackers work the other way: Elaine Howlin&#8217;s 2027 files are new copies titled \u00ab2027 Reading and Books Tracker\u00bb, with each earlier year kept as a separate archived file, so a multi-year view means opening several files.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The paid <a href=\"\/product\/reading-tracker-template\/\">Templacity Reading Tracker<\/a> is not this file in a nicer palette. Pick a title from the dashboard&#8217;s dropdown and that book gets its own overview: cover, pages read against its page count, format, start and finish dates, a progress bar, your favourite quote and a short review. Beside it sit a genre pie, a currently-reading dial, a completed-rate dial and a top ten with covers. A Library tab shows the last book you read with your reading and finished counts, and a Wishlist tab adds up the price of the books you still want. Three designs, same fields underneath. The free copy above stays free either way.<\/p>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">The picks<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"five-book-tracker-spreadsheets-worth-copying-for-2027\">Five book tracker spreadsheets worth copying for 2027<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Each of these is free and Google-Sheets-first. We rated them on three things relevant to book tracking specifically: whether the template handles \u00abowned but not yet read\u00bb, whether it handles a multi-year history, and whether the dashboard view works on a phone (because half of book-shelf cataloguing happens standing in front of the shelf with your phone).<\/p>\n\n\n\n\t<div class=\"device-mockup\"\n\t     data-device=\"kindle-scribe\"\t     style=\"aspect-ratio: 2693\/2989;\">\n\n\t\t<img class=\"device-mockup__back\"\n\t\t     src=\"https:\/\/templacity.com\/wp-content\/themes\/templacity\/assets\/mockups\/devices\/kindle-scribe\/back.webp\"\n\t\t     alt=\"Kindle Scribe\"\n\t\t     loading=\"lazy\" decoding=\"async\" \/>\n\n\t\t<div class=\"device-mockup__screen\"\n\t\t     style=\"left: 14.519123653918%;\n\t\t            top: 4.6169287387086%;\n\t\t            width: 75.380616412922%;\n\t\t            height: 90.665774506524%;\n\t\t            border-radius: 0.59113300492611%;\">\n\n\t\t\t\t\t\t\t<img class=\"device-mockup__planner\"\n\t\t\t\t     src=\"https:\/\/templacity.com\/wp-content\/themes\/templacity\/assets\/mockups\/planners\/reading\/page.webp\"\n\t\t\t\t     alt=\"Kindle Scribe showing the Reading log page\"\n\t\t\t\t     style=\"filter: grayscale(1) brightness(1) contrast(0.9);\"\n\t\t\t\t     loading=\"lazy\" decoding=\"async\" \/>\n\t\t\t\n\t\t\t\t\t\t\t<div class=\"device-mockup__tint\"\n\t\t\t\t     style=\"background: #c6c7c6;\n\t\t\t\t            opacity: 0.2;\n\t\t\t\t            mix-blend-mode: multiply;\"><\/div>\n\t\t\t\n\t\t\t\t\t\t\t<div class=\"device-mockup__grain\"\n\t\t\t\t     style=\"opacity: 0.15;\n\t\t\t\t            mix-blend-mode: overlay;\"><\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\t<\/div>\n\t\n\n\n\n\n<div style=\"overflow-x:auto;\">\n<table class=\"cmp-table\" aria-label=\"Book tracker spreadsheet comparison\" data-stack=\"5\">\n  <thead>\n    <tr>\n      <th>Tracker<\/th>\n      <th><span class=\"device\">Owned shelf<\/span><\/th>\n      <th><span class=\"device\">Multi-year<\/span><\/th>\n      <th><span class=\"device\">Phone view<\/span><\/th>\n      <th><span class=\"device\">Fields<\/span><\/th>\n    <\/tr>\n  <\/thead>\n  <tbody>\n    <tr>\n      <th data-label=\"Tracker\">Templacity Free Book Tracker<\/th>\n      <td data-label=\"Owned shelf\"><span class=\"winner\">Yes, \u00abstatus\u00bb column plus a To Read tab<\/span><\/td>\n      <td data-label=\"Multi-year\"><span class=\"winner\">Yes, single workbook<\/span><\/td>\n      <td data-label=\"Phone view\"><span class=\"winner\">Phone-friendly<\/span><\/td>\n      <td data-label=\"Fields\">12<\/td>\n    <\/tr>\n    <tr>\n      <th data-label=\"Tracker\">SpreadsheetPoint Book Tracker<\/th>\n      <td data-label=\"Owned shelf\">Partial, via filter<\/td>\n      <td data-label=\"Multi-year\">Yes, year tab<\/td>\n      <td data-label=\"Phone view\">Workable<\/td>\n      <td data-label=\"Fields\">7<\/td>\n    <\/tr>\n    <tr>\n      <th data-label=\"Tracker\">Elaine Howlin 2027<\/th>\n      <td data-label=\"Owned shelf\">No, reading-focused<\/td>\n      <td data-label=\"Multi-year\">No, a new file each year<\/td>\n      <td data-label=\"Phone view\">Cramped<\/td>\n      <td data-label=\"Fields\">Three versions<\/td>\n    <\/tr>\n    <tr>\n      <th data-label=\"Tracker\">InfoInspired Book Log<\/th>\n      <td data-label=\"Owned shelf\">No<\/td>\n      <td data-label=\"Multi-year\">Yes<\/td>\n      <td data-label=\"Phone view\">Phone-friendly<\/td>\n      <td data-label=\"Fields\">5<\/td>\n    <\/tr>\n    <tr>\n      <th data-label=\"Tracker\">Free Excel Book Inventory (Microsoft template)<\/th>\n      <td data-label=\"Owned shelf\">Yes<\/td>\n      <td data-label=\"Multi-year\">Yes<\/td>\n      <td data-label=\"Phone view\">Excel mobile is rough<\/td>\n      <td data-label=\"Fields\">9<\/td>\n    <\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">If you want a book tracker that doubles as a shelf inventory, the Templacity free copy and the Microsoft Excel template are the two we&#8217;d recommend. Our free copy includes a \u00abstatus\u00bb column (To Read, Reading, Finished, DNF) so you can filter your owned-but-unread shelf without splitting the workbook. The Excel template is older but still solid for Office users; the trade-off is the mobile experience, which is worse than Google Sheets across the board.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you want the reading-focused option (dates, ratings, finished count) and don&#8217;t care about cataloguing what you own, Elaine Howlin and SpreadsheetPoint are both fine; the trade-off is Elaine&#8217;s new-file-every-year approach (her 2027 set comes in Basic, New and Improved, and a Bookopoly reading-challenge edition) vs SpreadsheetPoint&#8217;s drier visuals. InfoInspired is the simplest possible: five fields, no dashboard, holds across years. Pick by what you want the tracker to do; the answer is rarely \u00aball of it\u00bb.<\/p>\n\n\n\n<aside class=\"takeaway\" aria-label=\"Key takeaway\">\n  <div class=\"takeaway__num\">i.<\/div>\n  <div class=\"takeaway__body\">\n    <p class=\"takeaway__eyebrow\">What we found<\/p>\n    <p class=\"takeaway__text\">The most useful book tracker spreadsheet is the one that holds across years in a single file, with a phone view that works at the shelf. Year-tagged files split your history; cramped phone views push you back to the laptop.<\/p>\n  <\/div>\n<\/aside>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">The missing column<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"the-source-column-most-book-trackers-miss\">The \u00absource\u00bb column most book trackers miss<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Most trackers leave the source column out (Elaine Howlin&#8217;s 2027 log is the exception, with a Source column); ours ships it as \u00abWhere from\u00bb on the reading log and \u00abWhere I heard about it\u00bb on the To Read tab, and it&#8217;s the field you&#8217;ll read most when picking what&#8217;s next. The use of the source column is to record who recommended the book, or where you saw it, at the time you added it. By June you&#8217;ll have forgotten which podcast guest mentioned the title, which Substack list it came from, or which sister put it in your hands. The five-second cost of writing \u00abTom, podcast Mar 24\u00bb is the difference between knowing how the book got onto your list and not.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Add the source column as a seventh field, between \u00abnotes\u00bb and the end. Keep it free-form text; don&#8217;t try to structure it. The point of the column is to be readable when you&#8217;re scanning the list, not to be queryable. The dashboards can ignore it. When you&#8217;re picking what to read next, you&#8217;ll filter by priority and then read the source column to decide. After six months of tracking, the source column quietly becomes the most useful field in the sheet.<\/p>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">Reader-type fit<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"which-book-tracker-fits-which-reader\">Which book tracker fits which reader<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The five trackers split cleanly by reader type, which is more useful than ranking them. For the inventory-first reader (you have a wall of books, you want to know what you own), the Templacity free copy or the Microsoft Excel template are the two real options. For the analytical reader (you want charts on books per month, rating distribution, genre split), SpreadsheetPoint or our reading-tracker-spreadsheet pillar&#8217;s free copy. For the aesthetic-first reader (the tracker should look pretty in a Pinterest pin), Elaine Howlin. For the minimalist (you want a list of titles and dates and nothing else), InfoInspired.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you&#8217;d rather skip a spreadsheet entirely and use an app, Goodreads (\u00abWant to Read\u00bb, \u00abCurrently Reading\u00bb, and \u00abRead\u00bb shelves cover the same shapes as a book tracker) and StoryGraph (cleaner UI, same shapes) are both free. The trade-off is the data lives in the app&#8217;s cloud; export is harder than in a Sheet. For most readers who already use one of those apps, doubling up with a spreadsheet is overhead. For readers who want both an app for the social layer and a spreadsheet for the data layer, two trackers can coexist with a monthly reconciliation. <a href=\"https:\/\/www.goodreads.com\/\" target=\"_blank\" rel=\"noopener\">Goodreads<\/a>, <a href=\"https:\/\/app.thestorygraph.com\/\" target=\"_blank\" rel=\"noopener\">StoryGraph<\/a>.<\/p>\n\n\n\n<p class=\"pull-quote\">The source column quietly becomes the most useful field in the sheet. You&#8217;ll read it more often than the rating, more often than the notes.<cite>The missing column<\/cite><\/p>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">Tablets<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"if-you-mostly-read-on-a-tablet\">If you mostly read on a tablet<\/h2>\n\n\n\n<figure class=\"post-figure\"><img decoding=\"async\" src=\"https:\/\/templacity.com\/wp-content\/uploads\/2026\/08\/book-tracker-spreadsheet-inline-0.webp\" alt=\"Reading notes kept on an e-ink tablet rather than in a spreadsheet\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If most of your reading happens on a Kindle Scribe, reMarkable, or Boox tablet, a spreadsheet is the wrong format. The friction of switching to a phone or laptop to log a book you just finished on a tablet is what kills tracker habits. A digital-tablet reading tracker that lives on the same device solves this. Our <a href=\"\/kindle-scribe\/best-kindle-scribe-templates\/\">best Kindle Scribe templates<\/a> and <a href=\"\/remarkable\/best-remarkable-templates\/\">best reMarkable templates<\/a> pieces cover the catalogue for each device, including reading-tracker layouts.<\/p>\n\n\n\n<aside class=\"bundle-inline\" aria-label=\"Templacity reading templates\">\n  <div class=\"bundle-inline__body\">\n    <p class=\"bundle-inline__eyebrow\">Templates for tablet readers<\/p>\n    <p class=\"bundle-inline__text\">Our <a href=\"\/product\/reading-tracker-template\/\">Reading Tracker<\/a> builds the dashboard this piece argues for and keeps it off your hands: a genre pie, a currently-reading dial and a completed-rate dial that fill from the rows you already logged. Three designs, one picker at checkout. If you read on a tablet and would rather write by hand, the <a href=\"\/product\/remarkable-template-bundle\/\">reMarkable<\/a> and <a href=\"\/product\/kindle-scribe-template-bundle\/\">Kindle Scribe<\/a> bundles ship Infinite Notes, a blank book to keep the log in rather than a reading layout.<\/p>\n  <\/div>\n<\/aside>\n\n\n<div class=\"tc-pb-answer tc-pb-answer--pace\" data-tc-pace><div class=\"tc-pb-answer__pace\"><label for=\"tc-pb-pace-g-1\">Goal this year<input id=\"tc-pb-pace-g-1\" data-f=\"g\" type=\"text\" inputmode=\"numeric\" pattern=\"[0-9]*\" maxlength=\"5\" autocomplete=\"off\" value=\"52\"><\/label><label for=\"tc-pb-pace-r-2\">Read so far<input id=\"tc-pb-pace-r-2\" data-f=\"r\" type=\"text\" inputmode=\"numeric\" pattern=\"[0-9]*\" maxlength=\"5\" autocomplete=\"off\" value=\"0\"><\/label><\/div><div class=\"tc-pb-answer__track\" aria-hidden=\"true\"><i style=\"width:0.00%\"><\/i><em style=\"left:calc(89.04% - 1px)\"><\/em><\/div><p class=\"tc-pb-answer__verdict\" aria-live=\"polite\">46 behind an even pace. 52 to go: about 40 a month, 9.1 a week.<\/p><p class=\"tc-pb-answer__note\">The dark bar is books read, the gold mark is where you would be on an even pace today (<span data-o=\"expect\">46<\/span> of <span data-o=\"goal\">52<\/span> as of <time datetime=\"2026-11-21\">21 November 2026<\/time>).<\/p><\/div>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">FAQ<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"common-questions-answered-briefly\">Common questions, answered briefly<\/h2>\n\n\n\n<section class=\"faq\" aria-label=\"Frequently asked\">\n  <details open>\n    <summary>What is a book tracker spreadsheet?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">A Google Sheet or Excel file that records the books you&#8217;ve read, are reading, or own. Most use one row per book and five to seven columns (title, author, dates, rating, notes, optionally status and source). The simplest version takes 30 seconds per book to update.<\/div>\n  <\/details>\n  <details>\n    <summary>Is there a free book tracker spreadsheet?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">Yes. The Templacity free copy, SpreadsheetPoint&#8217;s book tracker, Elaine Howlin&#8217;s reading tracker, InfoInspired&#8217;s book log, and Microsoft&#8217;s free Excel book inventory template are all free. The comparison table above shows the trade-offs.<\/div>\n  <\/details>\n  <details>\n    <summary>How is a book tracker different from a reading tracker?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">Mostly the same. Book trackers tend to emphasise the book object (title, author, status, where it lives); reading trackers emphasise the act of reading (dates, ratings, finished). One sheet with seven columns usually covers both jobs.<\/div>\n  <\/details>\n  <details>\n    <summary>What columns should a book tracker have?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">Seven: title, author, started, finished, rating, notes, source. Status (owned-unread \/ reading \/ finished) as an eighth if you want shelf inventory too. Skip genre, format, pages, theme, mood; you&#8217;ll fill them once and skip them thereafter.<\/div>\n  <\/details>\n  <details>\n    <summary>Can a book tracker spreadsheet work for ebooks and audiobooks?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">Yes. Treat them the same as paper books in the title, author, and rating columns. If you want to distinguish, add a \u00abformat\u00bb column with three values (paper, ebook, audio). If you don&#8217;t, leave it out; format breakdowns aren&#8217;t useful month-to-month.<\/div>\n  <\/details>\n  <details>\n    <summary>Do I need a new book tracker for 2027?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">Not with ours. The Templacity book tracker reads the year from today&#8217;s date, so its dashboard starts counting 2027 on 1 January while your 2026 rows stay in the same file. Type 2026 into the Showing year cell to look back. Trackers sold or shared as a \u00ab2027\u00bb file need a fresh copy each year, which splits your history across files.<\/div>\n  <\/details>\n  <details>\n    <summary>Is there a free book tracker Excel template?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">Yes. The Excel version of the Templacity book tracker is a direct .xlsx download, no email: the same reading log, To Read tab and self-filling dashboard as the Google Sheets copy, with the formulas live.<\/div>\n  <\/details>\n  <details>\n    <summary>Where can I get a free book spreadsheet template?<span class=\"pm\" aria-hidden=\"true\"><\/span><\/summary>\n    <div class=\"answer\">The Templacity book tracker spreadsheet above is free: make a copy to your Google Drive and start logging. The same file works as a book spreadsheet, a book tracking spreadsheet, and a reading log, with a status column for the books you own but have not read yet.<\/div>\n  <\/details>\n<\/section>\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [\n    {\"@type\":\"Question\",\"name\":\"What is a book tracker spreadsheet?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"A Google Sheet or Excel file that records the books you've read, are reading, or own. Most use one row per book and five to seven columns. The simplest version takes 30 seconds per book to update.\"}},\n    {\"@type\":\"Question\",\"name\":\"Is there a free book tracker spreadsheet?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes. The Templacity free copy, SpreadsheetPoint, Elaine Howlin, InfoInspired, and Microsoft's Excel book inventory template are all free.\"}},\n    {\"@type\":\"Question\",\"name\":\"How is a book tracker different from a reading tracker?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Mostly the same. Book trackers emphasise the book object; reading trackers emphasise the act of reading. One sheet with seven columns covers both.\"}},\n    {\"@type\":\"Question\",\"name\":\"What columns should a book tracker have?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Seven: title, author, started, finished, rating, notes, source. Status as an eighth if you want shelf inventory. Skip genre, format, pages, theme, mood.\"}},\n    {\"@type\":\"Question\",\"name\":\"Can a book tracker spreadsheet work for ebooks and audiobooks?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes. Treat them the same as paper books. If you want to distinguish, add a 'format' column.\"}},\n    {\"@type\":\"Question\",\"name\":\"Do I need a new book tracker for 2027?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Not with ours. The Templacity book tracker reads the year from today's date, so its dashboard starts counting 2027 on 1 January while your 2026 rows stay in the same file. Trackers shared as a 2027 file need a fresh copy each year.\"}},\n    {\"@type\":\"Question\",\"name\":\"Is there a free book tracker Excel template?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes. The Excel version of the Templacity book tracker is a direct .xlsx download, no email, with the same reading log, To Read tab and self-filling dashboard as the Google Sheets copy.\"}},\n    {\"@type\":\"Question\",\"name\":\"Where can I get a free book spreadsheet template?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"The Templacity book tracker spreadsheet is free: make a copy to your Google Drive and start logging. The same file works as a book spreadsheet, a book tracking spreadsheet, and a reading log, with a status column for books you own but have not read.\"}}\n  ]\n}\n<\/script>\n\n\n\n<p class=\"wp-block-paragraph\">If yours isn&#8217;t above, drop the question in the comments and we&#8217;ll add it.<\/p>\n\n\n\n<p class=\"section-marker wp-block-paragraph\">People also ask<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"other-questions-briefly-answered\">Other questions, briefly answered<\/h2>\n\n\n\n<section class=\"paa\" aria-label=\"People also ask\">\n  <a href=\"\/books\/reading-tracker-spreadsheet\/\">Best reading tracker spreadsheet\n    <svg viewBox=\"0 0 16 16\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n  <a href=\"\/books\/best-tbr-spreadsheet-template\/\">Best TBR spreadsheet template\n    <svg viewBox=\"0 0 16 16\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n  <a href=\"\/books\/reading-tracker-dashboard\/\">Reading tracker dashboard\n    <svg viewBox=\"0 0 16 16\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n  <a href=\"\/books\/best-reading-tracker-template\/\">Best reading tracker template\n    <svg viewBox=\"0 0 16 16\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n<\/section>\n\n\n\n<section class=\"citations\" aria-label=\"Sources\" style=\"display:grid; gap:8px;\">\n  <a class=\"cite\" href=\"https:\/\/one.google.com\/about\/plans\" target=\"_blank\" rel=\"noopener\">\n    <span class=\"src-tag\">Reference<\/span>\n    <span class=\"body\">\n      <span class=\"title\">Google One, plans and storage: &quot;All Google accounts come with up to 15 GB of storage&quot;, which is what makes the free Google Sheets route described here no-cost (checked August 2026)<\/span>\n      <span class=\"url\">one.google.com\/about\/plans<\/span>\n    <\/span>\n    <svg class=\"arrow\" viewBox=\"0 0 16 16\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n  <a class=\"cite\" href=\"https:\/\/elainehowlin.wordpress.com\/2026\/09\/09\/2027-reading-tracker-spreadsheet-with-stats-free-tools-to-reach-your-reading-goals\/\" target=\"_blank\" rel=\"noopener\">\n    <span class=\"src-tag\">Reference<\/span>\n    <span class=\"body\">\n      <span class=\"title\">Elaine Howlin, 2027 Reading Tracker Spreadsheet: three free versions (Basic, New and Improved, Bookopoly), earlier years kept as separate archived files (checked October 2026)<\/span>\n      <span class=\"url\">elainehowlin.wordpress.com<\/span>\n    <\/span>\n    <svg class=\"arrow\" viewBox=\"0 0 16 16\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n  <a class=\"cite\" href=\"https:\/\/www.goodreads.com\/\" target=\"_blank\" rel=\"noopener\">\n    <span class=\"src-tag\">Reference<\/span>\n    <span class=\"body\">\n      <span class=\"title\">Goodreads (book tracker, owned by Amazon)<\/span>\n      <span class=\"url\">goodreads.com<\/span>\n    <\/span>\n    <svg class=\"arrow\" viewBox=\"0 0 16 16\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n  <a class=\"cite\" href=\"https:\/\/app.thestorygraph.com\/\" target=\"_blank\" rel=\"noopener\">\n    <span class=\"src-tag\">Reference<\/span>\n    <span class=\"body\">\n      <span class=\"title\">StoryGraph (independent book tracker)<\/span>\n      <span class=\"url\">app.thestorygraph.com<\/span>\n    <\/span>\n    <svg class=\"arrow\" viewBox=\"0 0 16 16\"><path d=\"M5 11l6-6M6 5h5v5\"\/><\/svg>\n  <\/a>\n<\/section>\n\n\n\n<section class=\"share\" aria-label=\"Share this post\">\n  <span class=\"eyebrow\" style=\"margin-right:8px;\">Share<\/span>\n  <a class=\"icon-btn\" href=\"mailto:?subject=From%20Templacity&#038;body=https%3A%2F%2Ftemplacity.com%2Fbooks%2Fbook-tracker-spreadsheet%2F\" aria-label=\"Share by email\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"3\" y=\"6\" width=\"18\" height=\"13\" rx=\"2\"\/><path d=\"m3 7 9 7 9-7\"\/><\/svg><\/a>\n  <button class=\"icon-btn\" type=\"button\" onclick=\"navigator.clipboard&amp;&amp;navigator.clipboard.writeText(location.href);this.setAttribute('aria-label','Link copied');\" aria-label=\"Copy link\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M10 14a4 4 0 0 0 5.66 0l3-3a4 4 0 0 0-5.66-5.66l-1 1\"\/><path d=\"M14 10a4 4 0 0 0-5.66 0l-3 3a4 4 0 0 0 5.66 5.66l1-1\"\/><\/svg><\/button>\n  <button class=\"icon-btn\" type=\"button\" onclick=\"window.print()\" aria-label=\"Print\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><polyline points=\"6 9 6 2 18 2 18 9\"\/><rect x=\"6\" y=\"14\" width=\"12\" height=\"8\"\/><path d=\"M6 18H4a2 2 0 0 1-2-2v-5a2 2 0 0 1 2-2h16a2 2 0 0 1 2 2v5a2 2 0 0 1-2 2h-2\"\/><\/svg><\/button>\n  <a class=\"icon-btn\" href=\"https:\/\/x.com\/intent\/post?url=https%3A%2F%2Ftemplacity.com%2Fbooks%2Fbook-tracker-spreadsheet%2F\" target=\"_blank\" rel=\"noopener\" aria-label=\"Share on X\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M4 4l7.5 9.5L4.5 20H7l6.2-6 4.8 6H21l-7.7-9.7L20 4h-2.5L12 9.5 7 4z\"\/><\/svg><\/a>\n  <a class=\"icon-btn\" href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Ftemplacity.com%2Fbooks%2Fbook-tracker-spreadsheet%2F\" target=\"_blank\" rel=\"noopener\" aria-label=\"Share on Facebook\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><path d=\"M14 9h3V6h-3a3 3 0 0 0-3 3v3H8v3h3v6h3v-6h3l1-3h-4V9z\"\/><\/svg><\/a>\n  <a class=\"icon-btn\" href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=https%3A%2F%2Ftemplacity.com%2Fbooks%2Fbook-tracker-spreadsheet%2F\" target=\"_blank\" rel=\"noopener\" aria-label=\"Share on LinkedIn\"><svg viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"3\" y=\"3\" width=\"18\" height=\"18\" rx=\"2\"\/><path d=\"M8 10v8M8 7v.01M12 18v-5a2.5 2.5 0 0 1 5 0v5M12 13v5\"\/><\/svg><\/a>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>A free book tracker spreadsheet for 2027: copy it to Google Sheets or download the Excel file. The dashboard rolls over to the new year by itself.<\/p>\n","protected":false},"author":4,"featured_media":13655,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_hall_cta":"","_hall_request_id":0,"_featured_products":["reading-tracker-template","remarkable-template-bundle","kindle-scribe-template-bundle"],"_reviewed_product":"","_templacity_lang":"en","_templacity_native_de":0,"_templacity_native_de_old":[],"_templacity_native_de_preview":0,"_templacity_native_de_preview_old":[],"_templacity_native_fr":0,"_templacity_native_fr_old":[],"_templacity_native_fr_preview":0,"_templacity_native_fr_preview_old":[],"_templacity_native_nl":0,"_templacity_native_nl_old":[],"_templacity_native_nl_preview":0,"_templacity_native_nl_preview_old":[],"_templacity_native_es":0,"_templacity_native_es_old":[],"_templacity_native_es_preview":0,"_templacity_native_es_preview_old":[],"_templacity_native_zh":0,"_templacity_native_zh_old":[],"_templacity_native_zh_preview":0,"_templacity_native_zh_preview_old":[],"_templacity_native_slug":"","footnotes":"","rank_math_focus_keyword":"book tracker spreadsheet","rank_math_title":"Book Tracker Spreadsheet 2027: Free Google Sheets + Excel","rank_math_description":"A free book tracker spreadsheet for 2027: copy it to Google Sheets or download the Excel file. The dashboard rolls over to the new year by itself.","rank_math_canonical_url":"","rank_math_robots":"","rank_math_seo_score":"76","rank_math_primary_category":48},"categories":[48],"tags":[125,195,85,87],"niche":[79],"template_type":[],"class_list":["post-7384","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-books","tag-books","tag-google-sheets","tag-spreadsheet","tag-tracker","niche-books"],"_links":{"self":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/posts\/7384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/comments?post=7384"}],"version-history":[{"count":5,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/posts\/7384\/revisions"}],"predecessor-version":[{"id":17576,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/posts\/7384\/revisions\/17576"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/media\/13655"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/media?parent=7384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/categories?post=7384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/tags?post=7384"},{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/niche?post=7384"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/template_type?post=7384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}