DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: Bloomberg Billionaires Index -> Google Spreadsheet?  (Read 4,832 times)

brotherS

  • Master of Good Ideas
  • Honorary Member
  • Joined in 2005
  • **
  • Posts: 2,261
Bloomberg Billionaires Index -> Google Spreadsheet?
« on: July 05, 2019, 10:15 AM »
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 )
Thank you.

wraith808

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 11,205
    • Participated in NANY Challenge Fourteen Times
    • Coding Snacks
    • Writer
    • Hardware Hacker
Re: Bloomberg Billionaires Index -> Google Spreadsheet?
« Reply #1 on: July 05, 2019, 04:26 PM »
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/
« Last Edit: July 05, 2019, 04:36 PM by wraith808 »

Original address: https://www.donationcoder.com/forum/index.php?topic=48045.0