How to automate the process of downloading and checking excel file?

Question

Automation

Input data: there are excel files that can be downloaded from the site. The authorities want after each deployment (conditionally) to check these files (they are generated somewhere on the server) to check for correctness, that is, that the columns, etc. are in their places.
How can this process be automated using qa? We just need ideas on how this can be done, what technologies / approaches can be used, etc.

Answer 1

Python has a very rich library for working with tabular data, plus it’s convenient to automate all this routine with a jump in python