Free Reading Tracker Spreadsheet by ReadersGuild

Start with one sitting

1. Save your own copy and open Tracker. Change the reading year in the amber cell if needed.
2. Open Sessions and enter a date, book title and positive number of minutes. Enter pages read during that sitting if you want to track pages, or leave them blank for audio or time-only reading.
3. Add a thought or a next step. A row marked Ready contributes to totals for its year. Check input means a required value is missing or invalid.
4. Return to Tracker for the monthly table and chart. Use Example to see the calculation with fictional data. Keep your real log separate from those sample rows.

What the totals mean

Each Ready row is a session, not a unique book or a day. Two sittings on one book count twice. Pages are the pages you enter for each sitting, not an edition's total length. Blank pages add no pages. Invalid rows are excluded; do not treat an unfinished row as a zero-minute sitting.

The template includes formulas for 500 rows. To log more, save a new workbook or deliberately extend the formulas and summary ranges. It does not promise automatic expansion. It does not estimate reading speed, compare editions or count books finished.

Open, check and keep your copy

Use an XLSX-capable spreadsheet app. If you import it into Google Sheets, keep the original and check Example: January has two sessions, 50 minutes and 25 pages; the year has four sessions, 100 minutes and 45 pages. Native Excel and Google Sheets rendering were not tested here.

The generated workbook was checked for blank/sample totals, edits, year boundaries, zero-minute handling, formula errors and exported chart bindings. It contains no macros, external workbook links or automatic uploads. Saving a copy in your chosen cloud service is separate from downloading this blank file.

Questions before you start