Main Area and Open Discussion > General Software Discussion

Bloomberg Billionaires Index -> Google Spreadsheet?

(1/1)

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.com/sites/danalexander/2017/11/07/the-case-of-wilbur-ross-phantom-2-billion/#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/code/#/2/code/view/dClY7fJjy2FcaBnNVF9swaIzOWmXWr2g5B7vWz4MVl0/

Navigation

[0] Message Index