Forum Discussion

dscheikey's avatar
dscheikey
Bronze Contributor
Sep 17, 2022

Tilak_Q 

Hello, unfortunately I don't have a solution that works alone in Excel. The table is not recognised.

But you can use a function in Google Sheets. This works.

 

=IMPORTHTML("https://market.todaypricerates.com/egg-rate-in-Patna","table",1,"en_GB")

 

The file must be opened in Google Sheets to update it. You can then copy the data into a separate worksheet within Excel.

 

 

I have been collecting prices in Google Sheets now since 28/08/2022. It actually works perfectly. Have you tried it too?

 

  • eggsrate's avatar
    eggsrate
    Copper Contributor
    Apr 14, 2023

    https://eggsrate.in/egg-rate-in-barwala/

     

    I have been collecting prices in Google Sheets now since 28/08/2022. It actually works perfectly. Have you tried it too?

Resources