- Do you want to analyse what people say about your product on Amazon Marketplace?
• Or the reviews that people leave on your Facebook page?
Not a problem!
You can do some basic sentiment analysis with VBA!
As an example, I’ll be analysing 1000 fine food reviews posted on Amazon. Since I am mostly interested in the very positive and the very negative ones, I’ll be using the code below to loop through each review and highlight in green the words I’ve identified as positive and in red the ones I’ve identified as negative.
That way, I can then easily determine if the general perception of my product is mostly positive or negative.
You can download the full spreadsheet here – 1000 Amazon Fine Food Reviews
Happy VBA coding!