Past Masters archive

To download a complete list (Excel ss) of all Lord Mayors, Sheriffs, Aldermen, AND most (but not yet all) livery company past masters, please click here.

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)

Hence there is a very large amount of data, and those not familar with Excel may find it a little daunting. You should not be!

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 are many columns of 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!

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 new archive is welcome to its compiler.

© Nigel Pullman 2019