My bank app does that stuff automatically. They have identified and classified pretty much all merchants so the app can breakdown spending and tell you exactly how much you spend on essentials, restaurants, alcohol, etc.

You get the same info as your spreadsheet, but without any work.