How to display the temperature or weather of the day in the current Excel worksheet?

1. In EXCEL, click Data-Import External Data-New WBE Query to open the dialog box.

2. Enter the web address in the address box.

3. Check the sign on the left.

4. Set the import location.

5. Set the properties.

6. Press OK to get the data.

7. The data is displayed at the position starting from cell A 1.

8. Format the cell area where the data is displayed to beautify it.

9. The final effect.