Book Club Reading List Excel - Free Template

1. Open the Instructions sheet, then go to Reading List and use the next prepared row for a new selection.
2. Enter the Book ID, title, author, ISBN, page count and date added. The sample rows show the intended structure, including BC001 and BC002.
3. Select the genre, format and reading status from their dropdown lists. Use the supplied values rather than typing alternative spellings.
4. Enter the target meeting date, actual meeting date, club rating, Members Read and Total Members. Ratings accept whole numbers from 1 to 5.
5. Add the meeting location, discussion lead and discussion notes in columns S to U. Leave actual meeting details blank until the meeting has taken place.
6. Review the calculated Participation %, Reading Days, Recommended Pace and Overdue? columns. Do not overwrite these formula columns.
7. Check the Dashboard after adding or updating records. Edit the Lists sheet if the club needs to customise genres, reading days or discussion prompts.

A book club committee, volunteer organiser or rotating discussion lead can use the Reading List as the club's central record. It suits a monthly group choosing books in advance, a workplace reading group tracking attendance, or a local library group handing administration between volunteers.

For example, a committee might add BC003 for Lessons in Chemistry, record 400 pages, set a target meeting date of 06/05/2026 and assign Sophie as the discussion lead. The same row keeps the genre, hardback format, ISBN, meeting location and later discussion notes together.

Planning the next selections

Use Reading Status to distinguish a future choice from a book members are already reading. Planned, In Progress, Completed and Deferred are available from the Lists sheet. This gives an organiser a 12-book pipeline without relying on separate notes or messages.

The Lists sheet links each genre to a recommended reading pace. Fiction and Crime are shown as 21 reading days, while Historical Fiction, Biography, Science Fiction and Non-fiction are shown as 28 days. Fantasy is shown as 35 days. These are workbook planning values, not rules about how quickly members should read.

Running the meeting

Before a meeting, check the target date, location and discussion lead. Afterwards, enter the actual date, rating and participation figures. If 12 members belong to the club and 11 read the book, Members Read is 11, Total Members is 12, and calculated participation is approximately 91.67%.

Discussion Notes provide a record of the conversation. A sample entry for Small Things Like These records a rating of 5 from 12 members and notes discussion about community, silence and moral courage.

The workbook separates information you enter from values it calculates. On Reading List, you enter book details in columns A to N and meeting administration in columns S to U. Columns O to R calculate Participation %, Reading Days, Recommended Pace and Overdue?, so those outputs should not be replaced with typed figures.

Participation and meeting timing

Participation % uses Members Read divided by Total Members. If 12 members are registered and 9 read a book, the result is 75.00%; if both values are 12, it is 100.00%. The formula avoids displaying a misleading calculation on an empty row.

Reading Days is calculated from the target and actual meeting dates. A target of 05/02/2026 and an actual meeting date of 07/02/2026 gives 2 days. If the title, target date or actual date is missing, the calculation remains blank.

Lookup values and validation

Recommended Pace uses VLOOKUP to match the selected genre against Lists. If Fiction is selected, the lookup returns 21; if Fantasy is selected, it returns 35. A consistent dropdown choice is better than typing variations such as fiction or Fantasy fiction.

Seven validation rules support disciplined entry. Genre, format and status use lists; ratings accept whole numbers from 1 to 5; pages accept 1 to 5,000; and Members Read and Total Members accept whole numbers within the workbook's stated ranges.

Dashboard checks

The Dashboard counts book titles, status values and genres, calculates average club rating and average participation, and counts overdue records. Its four charts use status, genre, rating and participation ranges, so changing source rows changes the dashboard when Excel recalculates.

The most damaging error in a reading list is often a mismatch between status, dates and meeting figures. A book marked Completed with no actual meeting date cannot produce Reading Days, while a book left as In Progress after the meeting can appear in the wrong Dashboard count.

Inconsistent entries distort the summary

Suppose a 12-person club records Members Read as 12 for one book and Total Members as 10 for another, even though the membership has not changed. Both rows could show 100% participation, but the figures no longer describe the same club population. Agree the denominator before entering each meeting's figures.

Genre spelling creates another problem. The lookup expects values in Lists, such as Fiction, Crime or Memoir. A manually typed variation may fail to return a Recommended Pace and can put the book in the wrong genre summary. Use the dropdown rather than correcting values later.

Dates and status can disagree

A target meeting date of 17/03/2026 and an actual meeting date of 18/03/2026 gives a one-day difference. If the actual date is accidentally entered as 18/03/2025, Reading Days becomes a large negative interval and should be corrected before relying on the Dashboard.

The Overdue? formula checks whether a target date is earlier than today while the status is not Completed. A book left as In Progress after a postponed meeting may therefore be flagged. Update the status and dates to reflect the club's actual position.

Overwriting formulas removes the control

If someone types 80% over a calculated Participation % cell, later changes to Members Read and Total Members will not flow through. With 12 members changing from 9 readers to 10, the correct result changes from 75.00% to approximately 83.33%; a typed value would conceal that change.

A workbook becomes useful when one person owns the update at a fixed point in the club cycle. For a monthly meeting, update the next title immediately after the previous discussion, then review the row during the week before the next meeting. This creates two short checks instead of a large catch-up task.

Use a repeatable update sequence

• After the selection vote, enter the title, author, ISBN, format, genre, pages and Date Added.
• Set the Target Meeting Date, status and discussion lead before sharing the reading plan.
• After the meeting, enter Actual Meeting Date, Club Rating / 5, Members Read, Total Members and notes.
• Review the Dashboard for the changed status count, pages read, participation and overdue total.

For example, a club adding 12 books across a year can use one prepared row per selection and remain well inside the 100-row Reading List. Keeping the same Book ID pattern, such as BC001, BC002 and BC003, makes it easier to refer to a selection in messages and meeting notes.

Maintain the Lists sheet deliberately

Only change genre names, reading days or discussion focus when the club has agreed the new wording. Genre validation and Recommended Pace depend on the Lists values, so changing Fiction to another label without reviewing the lookup can disconnect existing entries from their pace.

Keep the Instructions sheet with the file when passing administration to another organiser. It explains the prepared rows, date format, statuses, Dashboard and Lists sheet, so a new volunteer does not need to reconstruct the workflow from the formulas.

Recognise when the file is no longer enough

This workbook is suitable for a single shared list and straightforward meeting administration. Consider a dedicated system when several organisers need simultaneous controlled access, when member-level attendance and comments must be retained separately, or when the club needs permissions and a fuller history than the 100 prepared rows provide.