min/max temperature

  • 1
  • Question
  • Updated 2 weeks ago
I need min/max temperatures for the previous day for an educational project. Without the wunderground API what source can you recommend?
Photo of PERRY J SAMSON

PERRY J SAMSON

  • 1 Post
  • 0 Reply Likes

Posted 1 month ago

  • 1
Photo of Tim

Tim

  • 8 Posts
  • 0 Reply Likes
Use Google Sheets to extract the data. There is probably a similar function in Excel, but I have not used Excel for so long now....

Enter ONE OF theseĀ formula in the firstĀ cell on a blank sheet.

Daily
=importhtml("https://www.wunderground.com/dashboard/pws/IBRACK14","Table",1)

Monthly
=importhtml("https://www.wunderground.com/dashboard/pws/IBRACK14/table/2020-02-01/2020-02-29/monthly","Table",4)

Change the URL for the name of the station you require.