Hi,
I have a proposal for a solution, but I am not sure if is what you want. Lets try!

Use the command "Data / Import external data / Import data...".
Import your file, set formats as you like etc.

When this is finished you have it imported in Excel. If your data source (he csv-file) is updated, you can just right-click in your excelsheet (on the existing data) and choose "update". This can also be automated in different ways. Please see different possibilities by right-cklicking (for example the choice "Properties for data area..."). You can also use it to import csv-files with different data, but same structure.

After this you can use pivot tables and database formulas/functions within Excel.

A more complex solution is briefly to link an Access database to the csv-file, and then use Excel MS Query linked to this Access database to create questions and results in your excel sheet.

Kind regards
Bjorn