Going from paper to a spreadsheet

Image by 200 Degrees from Pixabay

by Sam Milsom, Programme Development Manager at Open Data Manchester

Therapy4Healing (T4H) is a not-for-profit organisation that operates in the South East of England. It aims to improve people’s health and wellbeing by providing therapy and counselling services, especially to those with long-term conditions. It began out of an awareness that many who would benefit greatly from therapy often cannot afford it. Some of the services it offers include low-cost clinics, complementary-health pain clinics and counselling. During the pandemic, it has been able to offer many of those services over-the-phone, or using Zoom.

Naomi Louise has been CEO and Chair at T4H since 2012. She has a background in HR, so understands that having good and accessible data can be vital for funding and delivering better services. However, T4H is a very small organisation with very limited resources, with very little time to dedicate to the role of data within the organisation. Data was collected manually using paper and only very recently moved towards a spreadsheet system.

Bookings were made over-the-phone or through what Naomi describes as “an antiquated email system”. Any client and services data were created as paper records, and organised and stored in a physical filing cabinet. Gathering data for funding or impact reporting would mean physically seeking out paper copies, or having them scanned and emailed to her, and then any information was counted and worked out manually. 

T4H got busier during 2019 and then, when the COVID-19 pandemic hit in 2020, it saw an overnight increase in demand for its services of 500%. 

“We didn’t really have any data. We only had very small amounts of data because we only did very small amounts of work… And then we started to grow in 2019, then we kind of exploded last year. And we didn’t have any systems because we never needed any. And then we didn’t have any means of getting any systems because we kind of exploded as lockdown started.”

For Therapy4Healing to be able to cope with demand, it needed to quickly adopt a simple data-management system. This data would be vital to not only ensure it could continue to deliver therapies to its communities during lockdown, but to better understand its client base, and therefore respond to demand and focus delivery. However, with everything internally being directed towards delivery of services, T4H had neither money, time nor human resources to implement any changes. 

Under normal circumstances, an organisation like T4H might be able to attend networking events or industry exhibitions to seek help and advice, but during lockdown, this was simply not possible. So Naomi began to use a free Google Drive account. She started using it as a simple filing system – a place to store information on clients and funders, but now all of the organisation’s data about their clients is held on a spreadsheet, where previously it would have been “on real pieces of paper, in a real filing cabinet”.

Now, with client data held in a spreadsheet, there was more of an opportunity to start exploring it – postcodes, age groups, gender and ethnicity, along with what services they accessed. If T4H wants to know how many of its clients come from a certain postcode, it can easily do a count, rather than having to search through physical pieces of paper held in another location. The data they held is becoming more accessible and more visible across the organisation.

To better understand the organisation’s data, Naomi participated in a number of data literacy workshops, which were provided by Superhighways, as part of the COVID-19 Response Fund. In one of these sessions, participants used Google My Maps to get a better understanding of the areas where clients were being referred from. Combining this with T4H’s own knowledge of the communities it serves, the team was able to start asking questions of the data that they simply wouldn’t have been able to before.

“If I analyse the data I may find that a lot of people have accessed our services from one postcode. I could be tempted to draw a conclusion that there is a lot of need in that postcode. However, that may not be the case. It may be that people living in that postcode feel better able to access our services than those living in another area with greater need.”

Not only was T4H able to see where services were being used, but the team was also beginning to question what the data was – and wasn’t – telling them, and this can be highly valuable.

“It will give me much more power to be able to obtain more funding and get more sort of leverage with the people who need to understand the problems.”

T4H is very much at the start of its data journey. Like many small organisations, the team simply doesn’t have time or resources to invest in systems or training, or to pay to get someone in to help. But, simply by taking the plunge and moving its data from a paper-based system to a spreadsheet-based one, it is starting to take steps to opening up the deeper value its data holds.

In future, the team plans to implement a full CRM, and Naomi feels this will be much easier, not just from a technical standpoint, but from a growing understanding of the usefulness of having this data readily available, and the time and effort that can be saved. 

“At least if we migrate now, I’ve got somewhere to migrate from, as opposed to presenting a shed-load of papers to somebody at a cost of probably two weeks of work. We haven’t got ten days time or £500. So it saves us money in the long term, as well as for the migration. Hopefully, we’ll be able to do that ourselves.”

T4H’s cultural barrier was one of time, cost, capacity and need. In the end, the organisation overcame it by taking the plunge. In a way, the pandemic forced its hand. The team found help by seeking assistance from external organisations, and were very quickly able to visualise and question the data. This has given the team confidence and has them in good standing for continuing their data journey.

This case study informs part of a report, ‘How the Social Sector is Overcoming Cultural Barriers Around Data Use to Transform the Services it Provides to the People Who Need Them Most’ by Open Data Manchester, in collaboration with Catalyst, to understand how the use of data is transforming the social sector. Find out more and download the full report here: