The UK Governments have signed up to providing Open Data, but it still is not Accessible to us ordinary IT-literate V-Lookup Excel-using or Access Database-using folks

I wish to start using data about the Community and Voluntary Organisations in my local counties, so am seeking Open Data for Charities, Companies, and those without Legal Status (particularly focussing on the Digitally Excluded organisations)

Examples of purposes, achieved through collaboration opportunities identified through this Data to identify organisations:
- to proactively offer focussed help, rather than wait for a larger crisis that's more difficult to recover from
- to identify and share running cost reduction opportunities e.g. insurances
- to increase the proportion of more dependable funding e.g. Charitable Earned Income

Examples of current data sources that are not in an accessible or downloadable Excel or CSV format:
Charities Commission https://register-of-charities.charitycommission.gov.uk/register/full-register-download
CharityBase https://search.charitybase.uk/chc
Companies House http://download.companieshouse.gov.uk/en_accountsdata.html
InfoEngine https://en.infoengine.cymru/
DEWIS Wales https://www.dewis.wales/
Volunteering Wales (registrations) https://volunteering-wales.net/vk/volunteers/search.htm
ADoddle (Community Mapping) ​https://adoddle.org/app/search

Does anyone know of a suitable source of accessible data that covers the above resources or similar, please?