'How to use IMPORTHTML for COVID results

There is this link: https://covid19.who.int/table

COVID 19 table view

It is a table with latest COVID 19 cases.

I tried getting the results in a spreadsheet using a formula

=IMPORTHTML("https://covid19.who.int/table","table",1)

It gives the error:

Error Imported content is empty.

How can I make it work? What is wrong?

When I do "inspect" it says <div role="table" class="sc-pBzUF dgtvEZ"



Solution 1:[1]

try this instead

=IMPORTDATA("https://covid19.who.int/WHO-COVID-19-global-table-data.csv",",","en_US")

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Gabriel Pierce