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?
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.