Reading journals
Book tracker template
By BiblioFiend · Last updated
Sections7
Preview the book tracker template
Book title and author: __________________________________
Reading status or reflection: __________________________________
Known dates: __________________________________
Optional personal note: __________________________________
Download the editable CSV starter: headings only, UTF-8 text.
The preview shows the field names you will find in the originals. Each paper row leaves a combined space for the title and author, with room for dates and a brief note. The CSV keeps those details in separate columns so they can be sorted. These formats share a reading method, but they are not identical page layouts.
This book tracker template gives each reading attempt a row with a clear status. Download a paper copy for handwriting or a CSV for your own spreadsheet. The template does not choose books or judge how much you should read. It helps you tell a plan from a current read and a completed book.
Use To read, Reading, Finished, Paused and DNF as distinct states. Leave an unknown date or rating blank. A personal rating is your own optional response, not a published review score. The paper file has writing space; the CSV has column headings only and does not contain formulas or app connections.
The five book tracker template statuses
To read
Use To read for a possibility you have not started. A reason in Notes can explain why it belongs in your queue. Do not add a start date just because you reserved a library copy. If you remove the title before reading it, that is a changed plan rather than DNF.
Reading
Move a title to Reading when you begin the attempt you want to record. Several rows can be Reading at once. If you alternate between print and audio for the same edition and attempt, you can note both formats in one row. Use a new row for a later reread if you want separate dates or responses.
Finished
Finished means you reached the end under your own reading rules. Add a finish date only if you know it. A book can be Finished with an empty date cell; that keeps the status truthful without inventing a day. In a platform with monthly summaries, such a row should stay outside a month until it has a real date.
Paused
Paused means you expect that you may return. Keep the title and any useful location note, such as the chapter where you stopped. There is no required restart date. A paused title does not count as a completed book merely because it has been on the sheet a long time.
DNF
DNF means did not finish this attempt. You may prefer the word Stopped in a personal paper copy; write the label you will understand later. Keep a reason if it helps, but you do not need to justify the decision. DNF remains separate from Finished in any total you later create.
Field dictionary and fictional example
- Title: the name on the edition you used.
- Author: the credited writer or creators.
- ISBN or edition: an optional identifier when a version matters.
- Status: one of the five states above.
- Started: a known date for this reading attempt.
- Finished: a known completion date, left blank otherwise.
- Format: the format you used, recorded in your own words.
- Personal rating: optional, with a scale you define.
- Notes: a brief response or retrieval cue.
A fictional example is The Quiet Atlas by E. Example, Reading, started October 4, eBook, rating blank, note: return to the map before the next chapter. That invented row shows why a blank rating is useful. You have not yet decided on a response, so zero would say something different from unknown.
For a second fictional attempt, imagine returning to The Quiet Atlas a year later. Give it a new row if you want to preserve the first attempt. Do not overwrite old notes merely to make the sheet look tidy. A tracker can show a change in taste as well as a list of completions.
Pick paper or CSV without losing the method
Paper suits a small active list and quick notes. Print the matching Letter or A4 file and check that the row labels remain legible. The regular tracker has no cut dimensions, so modest printer fitting is acceptable. Keep completed sheets in order if dates are part of how you retrieve a book later.
The CSV suits a reader who wants to arrange their own columns. Import it into a new table first, check that commas have created the expected fields, then set date columns deliberately. The file has no dropdown rules, calculations or sample rows to remove. If you want those spreadsheet features, use the separate Google Sheets tracker.
For a database with saved reading views, use the Notion setup instead of expecting CSV to carry view settings. A CSV moves data; the application decides how to display it. Keep a backup of the plain file before changing column names or adding platform-specific properties.
Keep a tracker small enough to use
Try the fields for a few books before adding more. If an edition number never helps you, it can stay empty. If a note is too private for a shared sheet, keep it in a separate journal. A personal tracker does not need a full catalogue record for every book.
When you sort a spreadsheet, select the whole table so the title does not detach from its dates. Do not sort one column alone. For handwritten pages, a small title index may work better than rewriting the rows into a new order. Choose a retrieval method that matches the size of your record.
FAQ
Can I use a different rating scale?
Yes. The plain tracker does not impose one. Write your scale beside the sheet so a later number has a clear meaning. Leaving the rating blank is also valid. A personal rating in this file is not an editorial recommendation or a customer-star claim about a product.
Can I track more than one format?
Note both formats on one attempt if you moved between them. Use separate rows when you want to compare different editions or rereads. The important point is to keep the row's meaning clear. A format switch by itself does not need to create another completed-book count.
Book tracker template verdict
Keep the book tracker template focused on states you can explain. Dates and ratings can wait; the title and status do most of the work.