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
Go to full version