Sorting wordpress data in excel

I'm looking for a way to more quickly input wordpress data into excel.I need to create an overview of evaluations we receive for events, that include ratings (very satisfied etc) and sections where people can input comments etc. Right now we are inputting everything manually, sorting the data by day (it's all in the same file from wordpress) and counting how many people gave what rating. Then we enter that onto a separate sheet for each day and copy-paste the comments below, so it ends up looking something like this:

Very Satisfied 5 Satisfied 10 Neutral 4 Dissatisfied 3 Very Dissatisfied 1 Comments:I had fun!

...but with multiple questions.

Is there a way to automatically count ratings, or to input comments in certain sections, especially when we want to sort the days onto different sheets at the end?

I am not terribly wordpress or excel savvy but surely there must be a simpler way to do this.