Automatic categorisation tool for transactions

twister_teddy

I have exported my credit card statements for past 5 years in a spreadsheet. I would like to categorise them and was wondering if there is a tool out there which can perform  automatic categorisation for each transaction based on the merchant name and/or description.
Sample data as below. 

Date DESCRIPTION Amount01/12/2019 Taco Bell Restaurant (Android Pay) 7.5625/03/2019 The Card Factory 57.7617/03/2019 Primark 20.66So in above example there can be a new column and should assign something like "Eat out", "Shopping" and "Clothing" respectively for each row.
I can save the data in a different format if needed CSV, Excel, PDF etc
This will save me going through 6000+ records.