Past Masters' archive

To download a complete list (Excel spreadsheet) of all Lord Mayors, Sheriffs, Aldermen, AND all bar one livery companies' past masters/prime wardens/upper bailiff, and now Clerks, please click here.

In this MS Excel workbook is a database showing historic details of ALL lord mayors and sheriffs (as far back as the first LM Henry Fitzailwyn in 1189), and 109 livery company masters and clerks going back varying numbers of years.

Also including, at the extreme right of the red sheet, the Recorders of London, recent Livery Committee chairmen, and the monarchs and prime ministers of each year (columns EK and EL)

Once you have downloaded the Excel workbook, first be aware of the various (7) tabs (sheets) at the foot of the spreadsheet.

Listed from the left, they are:


Lord Mayors

LM&Sheriffs since 1832


LM, sheriffs & livery masters

Clerks, by company

Clerks, single list

The one you want for past masters is that named LM, sheriffs & livery masters.

And now, from January 2020, there are also two new separate tab for CLERKS, showing 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.

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 2019 are in row 831! (2020 cohort will be added en bloc in December 2020)

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 2020