Unique pupil numbers

Guide for schools and local authorities on unique pupil numbers (UPNs) and a tool for generating them.


UPNs: guide for schools and local authorities

UPN generator

This file may not be suitable for users of assistive technology.

Request an accessible format.
If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email . Please tell us what format you need. It will help us if you say what assistive technology you use.


The unique pupil number (UPN) is a 13-character code that identifies each pupil in the local-authority-maintained school system.

The guide is for schools and local authorities, and provides information on UPNs, including:

  • guidelines on maintaining UPNs
  • data protection
  • how to generate UPNs

The spreadsheet is a tool for generating UPNs.

The ‘UPN generator’ document is not accessible because it has missing alternative text and uses control buttons and complex macros. This means it does not meet Web Content Accessibility Guidelines success criteria 1.1.1 non-text content and 2.1.1 keyboard. Our teams are working to fix it by December 2020.

Published 13 September 2013
Last updated 7 June 2019 + show all updates
  1. Replaced the UPN guide with an updated version.

  2. Updated 'UPNs: guide for schools and local authorities' and UPN generator.

  3. Reviewed and updated the unique pupil numbers guide, this includes data protection changes needed in 2018.

  4. Updated the UPN (unique pupil number) generator.

  5. Updated the UPN (unique pupil number) generator.

  6. Updated the UPN (unique pupil number) generator for the 2015 to 2016 academic year.

  7. Updated UPN generator for 2014 to 2015 academic year.

  8. First published.