What and how to get certain data from a website and fill an Excel spreadsheet with it?

Question

Browsers

Please tell me how and how to get data from a website and fill in an Excel table with them?
There is a site, you need to get certain data from it and enter it into certain cells of an Excel table. How and with what help can this be done?
"Excel - Data - From the Web - Create a Web Query" - that doesn't work.

Answer 1

You can do it in python too. It has all the necessary libraries: xlwt, beatyfulsoap, json, selenium
Depends on the site...

Answer 2

I would do it using Excel itself
. It has a built-in VBA programming language.
You create an HTTP request object, send a request, receive data, parse, put into cells

Answer 3

It all depends on what you know. I would do it in php or golang if speed was important.
I would not use xls and replace it with csv , excel reads it with a bang.