What are the services for processing data from Excel spreadsheets?

Question

Database

Hello! I have a number of different excel files. One of them has the following structure (see screenshot)

It is a table of debtors. The data is located in the columns "Group" (group number), "Individual" (student's full name), "Gradebook" (gradebook number), "Subject" (name of the discipline), "Type of control" (test, exam, etc.). etc.), "Mark" (failed, unsatisfied, etc.), "Control period" (semester number), "Type of statement" (main, retake), "Individual statement" (yes, no).
Maybe there are some services, programs in order to store such information for a long time, based on this data, perform various queries, comparisons, analysis?
There are several such files. They can be divided into several groups. Each file in a group has the same structure.
The problem is that before that, these documents are unloaded into the excel-table format, and it is necessary to obtain various selections from them based on queries

Answer 1

If you want to do various queries, comparisons and analysis, then why was it necessary to export the data to Excel?
Let the data stay in a database that has tools for querying, comparing, and analyzing.
And export the results to Excel for viewing and printing.
Databases themselves are designed to work with data in tables.

Answer 2

I think the problem is that someone else is uploading and the author gets these xls-files, which the author has to work with.
This is a standard task for any financial ERP systems. For example, you need to upload invoices from different banks, and each bank has its own format and data set in the invoice files. There is no magic here - just a handler is written for each bank that reads data from a file and loads it into the database. And in the database you can play with them as you like.
In your case, it will be a (rather trivial) script, for example, in python, which loads the data from the columns into the database (possibly deleting the old data from the table beforehand).
I also came across some kind of plugin for Excel, which allows you to query data as if it were a database. Perhaps this will be an easier way out, Google to help.

Answer 3

Maybe there are some services, programs in order to store such information for a long time

Depends on the size of the data:
Tens of thousands of rows or less - Excel is enough
Millions of records or more - then a database, for example, in SQL.
Hundreds of thousands of rows - try, if Excel slows down - move to the database.
Excel: Google "Pivot Tables". There may be several sources.
DB: the required output is formed on the basis of queries that the programmer will write to you.

Answer 4

You can immediately see the unloading of data from 1C, so why allocate data processing and calculations to another system if it is more convenient and logical to do this in the same system.