Skip to main content

In praise of spreadsheets!



event 1st name Surname date place mother father spouse abode notes
bur Thomas Holyland 28 Jan 1564 Desford




marr Jane or Jone Hollyland 20 jan 1570 Desford

Henry Dammaske
maybe 1571?
bur Elizabeth Hollyland 26 aug 1571 Desford




marr Thomas Hollyland 8 Aug 1573 Desford

Agnis Shepston

bap Henry Hollyland 9 March 1574/5 Desford






No, come back --I'll try not to make this too boring!

In late 2019,before I joined the Guild of One Name Studies (GOONS), I did an introductory online course about setting up such a study. The course tutor urged us to use spreadsheets for the collection and correlation of information and I have to say that I felt dubious.

I'm not particularly techie-minded. I can use the basic functions of a microsoft office spreadsheet but was hardly in thrall to them.

But over the long January evenings, when I was starting my ONS, I decided to give it a try. And I have been totally won over! Building my family groups and trees, and correlating dates and facts is so much easier via spreadsheets!

I started by downloading separate lists of birth, marriage and death registrations from FreeBMD, which turned out to be surprisingly easy. Other spreadsheets followed, for similar events before 1837, court appearances, Holyland wills - it was necessary to input these manually, which was tedious, but ultimately very useful. I've designed the headings of each spreadsheet to reflect the information that I find most useful.

With these spreadsheets I can spot patterns at a glance. I can organise the columns into any order I choose, then back again to the original (eg, alphabetical order has been invaluable for grouping children by mother's maiden names). A quick hit of the search button solves many a query. Cross correlation between, for example, the marriage spreadsheet and the wills spreadsheet backs up findings quickly and easily.

I could wax lyrical for much longer about my spreadsheets but I did promise not to bore you all, so I will simply say - if you haven't already tried it, then give it a go! You might, like me, find that you quite like it!



Comments

Post a Comment

Popular posts from this blog

A tale of three weddings, pt 3 – Hannah’s story.

                                                                                  The church at Kirk Ireton, Derbyshire Hannah Slater was born in the Derbyshire village of Kirk Ireton in 1842. In 1864 she married William Holyland in Ashbourne and their daughter was born the following day but lived only a few weeks. William subsequently joined the army and, many years later, remarried, but there was no record of Hannah’s death. Neither did any of the subsequent censuses include a Hannah Holyland of her age and birthplace. What had happened to her? I realised that my spreadsheets contained another possible clue ...
2 comments
Read more

Spreading out

Early records show Holyland (+variants) families in Leicestershire, London and Cheshire, but in this post I’ll deal solely with the geographical spread of the Leicestershire families. For over a hundred years after the start of the Desford church registers, there seems to have been little movement. Some of the Holyland men married in other parishes, even other counties, but brought their wives back to the village and raised their families there.  The first significant settlement outside Desford seems to have been in the late 1600s, with the appearance of a family just across the border in the north of Warwickshire. However, there was also movement within Leicestershire around this time.  Two wills from the 1720s/30s show the existence of a Holyland family with adult children, living in Botcheston. Botcheston is a small village barely 2 miles from Desford, and it seems inconceivable that these Holylands would not be part of the Desford clan; however, it has not (ye...
2 comments
Read more

The Holyland who wasn't

Years ago, when I was fairly new to genealogy, I was approached by someone who knew of my interest in the Holyland surname. They’d received a marriage certificate for their ancestor, Ann Holyland, which gave Ann’s father’s name as Peter. Did I know anything about this branch of the family? I had never come across a Peter Holyland a nd my correspondent and I agreed that Ann was probably illegitimate and had “invented” Peter Holyland to assuage Victorian propriety. More recently, someone else got in touch with the same query and this time, with more experience and resources to call on, I decided to look at this more carefully. Ann Holyland married Thomas Lant in a civil ceremony in Leicester on 5 September 1863. Ann was 19, and gave her father’s details as Peter Holyland (deceased), a maltster.  There are two girls called Ann Holyland of roughly the right age in the records; I discounted one who was the daughter of Thomas and Harriet Holyland. The other was bor...
1 comment
Read more