topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • August 18, 2019, 02:26 PM
  • Proudly celebrating 13 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Bloomberg Billionaires Index -> Google Spreadsheet?  (Read 428 times)

brotherS

  • Master of Good Ideas
  • Honorary Member
  • Joined in 2005
  • **
  • Posts: 2,178
    • View Profile
    • Donate to Member
Bloomberg Billionaires Index -> Google Spreadsheet?
« on: July 05, 2019, 05: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.c...illion/#58fa93a07515 )

wraith808

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 10,180
    • View Profile
    • Donate to Member
Re: Bloomberg Billionaires Index -> Google Spreadsheet?
« Reply #1 on: July 05, 2019, 11:26 AM »
Look for the attribute window.top500.  That seems to have the whole thing in a JSON Array.

Formatted in JSON: https://cryptpad.fr/...OWmXWr2g5B7vWz4MVl0/
« Last Edit: July 05, 2019, 11:36 AM by wraith808 »