'Import a Coingecko table to Google Spread Sheets

I want to import the TOP LOOSERS table from this page to a Google Spreadsheet but I have no idea whatsoever how to do it.

google-sheets

Solution 1:^[1]

You can import data by this way, i.e in D2

=IMPORTHTML("https://www.coingecko.com/fr","table",1)

but it is difficult to order the result since values are in string format including %. You can then compute in A3, with % format in column B

=query(arrayformula({F3:F,1*(J3:J)}),"select * order by Col2 limit 10")

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

Solution	Source
Solution 1