What web tools are best for building an HTML table like an Excel PivotTable from a hefty .CSV?

Question

MySQL

Good afternoon!
There is a very large array of data in .csv: rates of various banks on deposits + various parameters of these deposits (currency, amount, term, type of deposit, the possibility of replenishment / withdrawal, etc.) + the date on which the specified rates are relevant.
Every week the file is supplemented with new relevant data and quickly becomes unbearable for work in Excel. Now it works for me in Excel, but I understand that it will only get worse (the number of rows in the array tends to a million)
Task:
1. Build an HTML-pivot table, where the MAXimum rate is shown in the cell in the context of the terms and amounts of the deposit by banks. In addition, various filters are supposed to be implemented on the table. For example, if you chose "Type of deposit" --> "Pension" and/or "Possibility of replenishment" --> "Yes" and the data in the pivot table would be automatically updated in accordance with the selected filter. Plus, I supplemented the original table with more up-to-date data and the data was automatically updated for a more up-to-date date.
2. I collect the history of rates in one file, because in the future, next to this table there will be a visualization of the dynamics of maximum rates, which should also be automatically updated in accordance with the selected filters.
Question.
I'm not asking for a specific solution, I ask for a hint,In what area do I need to find a programmer in order to implement the task? I myself understand web tools very superficially. Tried to look for solutions on the Internet, but got even more confused. Is it possible to solve the problem only with the help of JS libraries, or do you still need to calculate something on the server side? What web tools are optimal for solving the problem?
Thanks for the hints.
Clarification: I plan to implement it in HTML, because such a report is sent to different banks. The link would make it much more convenient for everyone to use the report.

Answer 1

It seems to me that you need to start with:
1) create a database to store this data.
2) Implement data import into it from .CSV
, then when you have structured data, you can do whatever you want with it.
1) display to the user in a convenient way (by moderating access to one or another part of the information)
2) generate any reports
3) upload reports in the required format (xls, pdf etc)
4) add new reports without changing the main data structure
for the implementation of the database, you need a server. The most common MySQL tool (there are others)
PS JS is usually used on the client (although of course not always). On the server most often PHP.

Answer 2

You will need a
server anyway Any server language will do ─ php, python, something else...