u/aneurysm1985

I am creating a Google Sheets spreadsheet to keep track of my expenses.

My bank provides me with a CSV file that includes data such as Date, Expense value, Details

So examples would be:

2026-05-20 | $50.00 | Pizza Hut
2026-05-21 | $39.95 | Netflix
2026-05-22 | $49.50 | Local hairdresser
2026-05-23 | $19.45 | McDonalds
2026-05-24 | $40.00 | Pizza Hut

I would like to add a 'category' colum to this spreadsheet. That includes broad categories such as 'Dining out', 'Groceries', 'Streaming services', etc.

There are plenty of businesses that I regularly spend money at. I would like a way to autofill this Category column based on the name that appears in the Details column. e.g. a way to know that if the Details column has 'Pizza Hut' or 'McDonalds', to add a value saying "Dining out' into the category column.

Can someone please suggest a way to do this in Google Sheets?