A Listening Log That Remembers the Voices: How the Audiobook Ledger Works
An audiobook log with narrators, stages, started and finished dates and ratings: how the Audiobook Ledger logs each title from your phone, form to sheet
An audiobook log is worth keeping for as long as it can answer four questions: what is next, what is playing right now, what did I think of the last one, and whose words and voices do I want to hear again. The Audiobook Ledger is built around those questions. It is a Google Sheet with a phone form: each time a title is added, started or finished, the entry travels form to sheet and the list updates from it. Logged in-the-moment, the day the last chapter ends and the story is still fresh, the sheet holds a listening life worth coming back to.
See Audiobook Ledger on Etsy ↗
The form that writes to the list
The form is called Log Audiobooks, and a link to it sits on the Dashboard under the heading "In-the-moment entry." It asks for the date, which falls back to today when it is left blank; the audiobook, chosen from a dropdown of every title on the list; a new-title question for an audiobook that is not on the list yet; what happened, which is Added, Started or Finished; a rating from 1 to 5, meant for a Finished entry; and a note.
Everything the form collects lands as one row on the Audiobook Log tab, so the whole history sits in one place, in order.
Three words for three kinds of moment
Added puts a title on the list: from a library hold, a subscription credit or a friend's tip. It starts on Want to Listen. Started is the day the listener presses play; its Stage becomes Listening and the date goes in its Started column. Finished is the day the last chapter ends; its Stage becomes Finished, the date goes in its Finished column and the rating is copied onto the title.
A rating is optional. A Finished entry with no rating is fine, and the title is still Finished. The latest rating logged is the one the title keeps, so a second listen can earn a new one.
A new title, typed on the phone
A title mentioned at dinner or a series a friend swears by is not on the list yet. The new-title question takes its name, the title joins the Items tab on Want to Listen, and the entry is logged against it. Typing the same title again, in any capitals, finds the existing row and never makes a twin.
The Items tab is the list
Every title has one row on the Items tab. The owner's columns are Item, Category (the genre), Source, Series #, Author, Narrator, Series, Length (hours) and Notes. The sheet fills in the rest from the log: Rating, Stage, Started, Finished and Finished (12 months).
Source can be a library app, a subscription, a purchase, a library CD or a borrowed copy. Series # holds the book's place in its series, such as Book 1 or Stand-alone, and Length holds how long it runs, in hours. The Author and Narrator columns sit on the same row as the rating, and writing each name the same way every time keeps a favorite writer or voice on one line.
Up Next, Listening Now and the favorites
The Dashboard shows a row of counts across the top: audiobooks on the list, and how many sit at Want to Listen, Listening and Finished, with a count of the titles finished in the last 12 months. Below it, Up Next lists every title still on Want to Listen, ordered by genre, with its author, narrator and length. With nothing left to hear, it says "Your Want to Listen list is empty." Beside it, Favorite Authors lists every author with a title rated 4 or 5.
Listening Now lists every audiobook that has been started and not finished, with its narrator, the date play was pressed and its length. With nothing playing, it says "Nothing playing right now. Log Started from your phone when you press play."
Beside it, Favorite Narrators does the same for narrators. Both favorites lists put the most loved first and show the name, how many of their titles were rated 4 or higher, and the average of every rating given to their titles. Recent Activity, below, shows the latest entries from the log.
Genres and sources, in the owner's words
The Customize Forms tab holds two short lists: Source and Categories. They start with Library app, Subscription, Purchased, Library CD and Borrowed, and Fiction, Mystery & Thriller, Romance, Fantasy & Sci-Fi, Nonfiction, Memoir, History, Self-Help, Kids & Family and Poetry & Essays. They fill the dropdowns on the Items tab, and any of them can be renamed, added to or removed, so the sheet describes the owner's own listening rather than a template's.
Starting with a sample list, then making it your own
The Audiobook Ledger arrives filled with a sample list of 40 audiobooks across every stage, genre and source, with a few months of log entries, so every list on the Dashboard shows something real. The titles, authors and narrators are invented. Clear Sample Data, on the custom Ledger & Light menu, empties the log and the titles, keeps the genres and sources, and leaves the Items tab ready for the owner's own list.
Owned, not rented
The Audiobook Ledger is a Google Sheet bought once and kept, living in the owner's own Google Drive with no subscription to renew. Because the log is a list of rows, a listening life that grows simply adds rows to the same sheet, and the history stays in one file.
This article describes how the Audiobook Ledger works. It keeps the listener's own list, in the listener's own words and ratings.
Common questions
What is the Audiobook Ledger?
The Audiobook Ledger is a Google Sheet with a phone form for logging audiobooks. Each time a title is added, started or finished, the entry travels form to sheet, and the Items tab and Dashboard update from it.
Can an audiobook log show which authors and narrators I like best?
Yes. The Dashboard's Favorite Authors and Favorite Narrators lists show every author and every narrator with a title rated 4 or 5, with how many of their titles were rated that high and the average of every rating given to them, most loved first.
Does the Audiobook Ledger record ratings and finished dates?
Yes. A Finished entry puts the day's date in the title's Finished column and copies the 1 to 5 rating onto the title. A rating is optional, and the latest one logged is the one the title keeps.
Can the genres and sources be changed in the Audiobook Ledger?
Yes. The Customize Forms tab holds two lists, Source and Categories. Either one can be renamed, added to or removed, so the dropdowns describe the listener's own sources and genres.
Does the Audiobook Ledger come with sample data?
Yes. It arrives with a sample list of 40 invented audiobooks across every stage, genre and source. Clear Sample Data, on the custom Ledger & Light menu, empties the log and the titles and keeps the genres and sources.