Bloomberg Billionaires Index -> Google Spreadsheet?

[brotherS]

A friend asked me to put the top 500 billionaires from https://www.bloomberg.com/billionaires/ (sorted by descending net worth, Jeff Bezos as #1) into a Google Spreadsheet, everything in its column. "Easy" I said... and then failed. I've tried "importhtml", I've tried copy/paste - any other ideas?

Btw: I like their sense of humor: below the top 500 billionaires, they list Wilbur Ross with a "n/a" rank and a net worth of $860 million. (It's funny because of https://www.forbes.c...illion/#58fa93a07515 )

[wraith808]

Look for the attribute window.top500.  That seems to have the whole thing in a JSON Array.

Formatted in JSON: https://cryptpad.fr/...OWmXWr2g5B7vWz4MVl0/