Past Masters' archive

Together with Lord Mayors, Sheriffs, and other officers at the Mansion House, Guildhall, and Old Bailey; and clergy (see red note 5 below). Also livery clerks, see note 6 below.

This comprehensive archive is available to download here as an Excel spreadsheet, containing various (7) tabs (sheets) at the foot of the workbook.

Listed from the left, they are:

1. Sheriffs

2. Lord Mayors

3. LM&Sheriffs since 1832

4. Aldermen

5. LM, sheriffs & livery masters 

This sheet of the spreadsheet includes a great many columns recording the office holders of most City of London dignitaries through the centuries, in addition to the LMs, sheriffs & livery masters.

Reading from left to right they are:

Lord Mayor (columns D-H)

Lady Mayoress (I)

Sheriff1 (J-O)

Sheriff2 (R-V)

Livery masters (X-EC) [in precedence order Mercers col X, Arts Scholars EC]

Masters of guilds or companies without livery (ED-EJ)

Recorder of London (EL)

Common Serjeant (EM)

Chief Commoner (EN)

Town Clerk (EP)

Chamberlain (ER)

Clerk to the Chamberlain’s Court (ET) 

Remembrancer (EV)

City Marshal (EX)

Swordbearer (EZ)

Common Cryer & Serjeant-at-Arms (FB)

City Surveyor (FC)

Secondary & Under Sheriff (FE)

Livery Committee chairman (FF)

Past Masters Association (FG)

Prime Minister (FI)

Monarch (FJ)

Bishop of London (FL)

Dean of St Paul’s (FN)

Vicar of St Lawrence Jewry (FP)

The current cohort of 2023 livery masters will be added on 31st December.

6. Clerks, by company

7. Clerks, single list - no longer maintained after 2019

Two separate tabs for CLERKS show the historical archive of livery clerks who have served back in time, in two alternative formats. The Clerks’ tabs are to the right at the foot of the ss.

Generally speaking, those tab coloured sheets red and blue contain the basic information. For greater detail, please go to one of the other monochromed tabs for more (eg dates of birth, death etc).

The Alderman sheet has a new column (N) showing due date of the next election in each ward.

When you have opened the red worksheet, the dates/years down the left side of the page, and the column headings across the top (including the name of each livery company, in precedence order) can be frozen so that scrolling up/down, or left/right, leaves the headings in place.

With 110+2 livery companies listed, not to mention many columns of data about the LM & Sheriffs and others, clearly there is much data to navigate. So for example, the Modern Companies (lowest in the precedence order) will hence be well to the right hand end of the sheet. The Arts Scholars (110) are listed in column EC.

And with many archives going back to the middle ages, there are literally hundreds of years of records to scroll through. The masters for the year 2021 are in row 833! (2022 cohort will be added en bloc in December 2022)

Should you wish to create a list of all masters of a particular year, highlight all their names, and then (on a Mac) go to Edit: Paste Special: Transpose which will then produce a column list. Or follow this Help.

Feedback on this archive is welcome to its compiler. Or if you are having difficulty downloading the Excel spreadsheet, please email

© Nigel Pullman 2023