School Report Comment Generator

Write your whole class’s school reports in far less time, and still make them sound like you. This Google Sheets and Excel tool is made for UK primary teachers in Years 1 to 6. Type a level from 1 to 4 for each subject, add one personal line, choose two next steps, and each child’s report builds itself.

There are no macros and no add-ons, and nothing is sent to an AI tool. Everything stays in your own file, so you can keep it wherever your school’s data rules say it belongs.

Why it doesn’t read like a template:

• 186 original sentences, all written for this product, and all editable
• 3 versions of each subject sentence at each of 4 levels, rotated through your class so that children next to each other on your list don’t get the same words
• Reads correctly for she, he and they, with every sentence written to work for all three
• A personal line for each child, in your own words
• A repeat check that tells you when two children have ended up with the same wording, and a Reword column to change it

WHAT’S INSIDE (7 tabs)

• Start Here: plain-English instructions
• Pupils: up to 40 pupils with levels, personal line, next steps and a status for each child
• Reports: every finished report with word count, character count, word limit check and a place to tick off the ones you’ve read
• Print Report: choose a pupil to get a one-page report, with or without levels. It also makes a handy parents’ evening summary
• Class Overview: how many children are at each level in each subject, and which next steps come up most
• Comment Bank: all the sentences, ready for you to change
• Settings: school, class, report heading, word limit and which subjects to include

12 subjects are ready to go, and you can rename any of them or turn them off: attitude to learning, reading, writing, maths, science, history and geography, art, design and music, PE, RE, computing, speaking and listening, and friendships and behaviour.

With all 12 on, reports are about 220 to 260 words. Turn subjects off for shorter ones.

You get a clean copy ready to use and a filled-in sample of a made-up class, so you can see it all working first.

This is a writing aid, not an assessment tool. Please read every report before it goes home, follow your school’s rules and save the file somewhere secure. For primary pupils (not EYFS or secondary).

WHAT YOU GET

• 1 clean spreadsheet (.xlsx for Excel and Google Sheets)
• 1 filled-in sample spreadsheet

HOW IT WORKS

• Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
• Excel: just open it (Excel 2010 or later, Windows or Mac, or Excel for the web)
• Type in the cream cells. Everything else updates on its own
• Formula cells are locked (no password) so you can’t break them by accident