My girlfriend has been given the task of getting all the data from a webpage. The web page belongs to an adult education centre. To get to the webpage, you must first log in. The url is a .asp file. 
She has to put the data in an Excel sheet. The entries are student names, numbers, ID card number, telephone, etc. There are thousands of entries. HR students alone has 70 pages of entries. This all shows up on the webpage as a table. It is possible to copy and paste.
I can handle Python openpyxl reasonably and I have heard of web-scraping, which I believe Python can do.
I don't know what .asp is.
Could you please give me some tips, pointers, about how to get the data with Python? 
Can I automate this task? 
Is this a case for MySQL? (About which I know nothing.)
Try using the tool called Octoparse.
Disclaimer: I've never used it myself, but only came close to using it. So, from my knowledge of its features, I think it would be useful for your need.
Get data from an .asp file