Auto categorisation of spending in statements

Would you train it so Sainsburys is groceries? What about the engine oil and clothing? No app will break your receipt down for you in the same way you could.
But if you are happy to have a brand classed as one category only, then you could do it in a spreadsheet quite simply. If the store is Sainsburys then the category box auto fills as Groceries.
It is no different to the way in which the apps work

Not sure on on the excel question, but I do know most banks do offer this as standard within the digital access to your bank?

Which bank are you with?

Have you tried Money Dashboard? It is free and works pretty well by using the Open Banking protocol and connecting to your online bank & credit card accounts. You need to train it when the categorisation is incorrect but it is right about 90-95% of time. The app is quite dated but still works fine; there is a web version as well. I prefer the Classic version over the Neon and have been using it for many years.

Thanks all, will look at money hub and money dashboard. Not heard of those.
Not keen on connecting my bank details to an app though!