How to set up automatic data collection and synchronization in Excel tables?

First, open Excel and click: Data-From Website in the menu bar.

You will see a query dialog box open, and your ie homepage will open automatically. Enter the URL you want in the address bar, and then click Go.

We see that a web page has been opened. If we want to import this table data, let's look at the second picture below, and then click the yellow button in the upper left corner. When a table is selected, the yellow button turns green.

Then click the import button and you will see the second picture below. Wait a few seconds.

Opens a dialog box and prompts you where to put the data. Click OK to import the data.