Extracting a HTML Table from a Cell

  • 19 June 2020
  • 1 reply

Userlevel 1

Hello All,


I have an HTML Table that gets exported from an HTML Page.  The HTML code and Table in embedded into one cell - i.e. A1 on a google sheet.


Does anyone know if there is a way to extrapualte this data back into rows & cols in a google/excel sheet?


I guess this would be similar to the importhtml function but I cannot get this to work.


Any Ideas anyone?






This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +10

Hi @Michael.Thomas 

I think this would be quite difficult, because Zapier needs column headers set in the sheet already to be able to write row(s) - and they wouldn’t exist in your scenario.