Your first useful Google Sheets pivot table

A long spreadsheet is a record of events. A useful summary answers a specific question. A pivot table connects the two without requiring you to copy each category into a separate sheet and manually add the numbers.

This guide uses an invented learning log and Google's documented computer workflow. Building and changing pivot tables is easiest in a desktop browser; do not assume every editing control is available in the mobile app. The same data can still support a practical mobile entry and review routine.

Start with a small clean dataset

Create columns called Date, Topic and Minutes. Enter these four records: AI, 30 minutes; Spreadsheets, 45 minutes; AI, 20 minutes; and Writing, 25 minutes. Use actual date values in the Date column and numbers in Minutes, without adding “min” inside each numeric cell.

Each row should represent one session. Keep one header row and avoid merged cells in the data area. Decide whether “AI” and “Artificial intelligence” should mean the same topic before entering dozens of records. A consistent dropdown can help prevent accidental category variations.

Build the first summary

On a computer, select the source cells including their headers. Choose Insert → Pivot table and place the result on a new sheet. In the pivot editor, add Topic to Rows. Add Minutes to Values and choose SUM as the summary operation.

Your result should show AI = 50, Spreadsheets = 45 and Writing = 25, with a total of 120 minutes. If you see counts instead, check the selected calculation and whether the source contains text where numbers should be. The question here is “How much time?” rather than “How many sessions?”

Ask one question at a time

Changing Values to a count can answer the second question. Both results may be valid, but they describe different things. Name the summary accordingly so a later reader does not confuse session count with time spent.

You can also use filters to focus the view. Keep a note of active filters when reporting a total. A number that excludes a topic or date range should not be presented as the total for the complete log.

Check the source range as data grows

Google states that a pivot table refreshes when its source cells change. That does not mean every new row outside the selected source range is automatically included. Inspect the range when you add more records, and expand it deliberately if needed.

As a test, add another AI session of ten minutes inside the included source range. The AI total should become 60 and the grand total 130. If it does not, investigate before relying on the summary. Keep the original records as the evidence behind the calculation.

Make daily entry simpler

Use a short dropdown for Topic and clear column headings. Google Sheets supports sorting and filtering on Android, while some setup and analysis features have different desktop and mobile capabilities. Build the summary once in the supported interface, then test the actual phone workflow you intend to use.

A good first pivot table is deliberately small. It has a clear question, clean inputs, an understandable calculation and a total you have independently checked. More charts and calculated fields can wait until that basic result is trustworthy.