Past Masters' archive

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

Also now including, at the extreme right of the spreadsheet, the monarchs and prime ministers of each year (columns EG and EH)

At this MS Excel spreadsheet 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 going back varying numbers of years.

Once you have downloaded the ss, first be aware of the various tabs at the foot of the spreadsheet. Hopefully, these are self explanatory, but the one you want for past masters is that named LM, sheriffs & livery masters.

When you have opened that 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, 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 2018 are in row 830! (2019 cohort will be added en bloc in January 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 2019