Promoted
Tech

A Glimpse Into Google’s Brain, Hidden In A Spreadsheet App

Give it two examples, and Google’s spreadsheet can make a list of almost anything. A strange peek at how Google — and by proxy, the internet — sees the world.

Yesterday TechCrunch reported that if you make a spreadsheet in Google Drive (Google Docs, formerly), enter and highlight the names of two beers, and pull down on the corner of the spreadsheet cell while holding Option or Control, the app will automatically fill the following cells with the names of other beers. The information is pulled, seemingly, from nowhere.

“Someone at Google really likes beer,” the post said, implying that the categories were created by Google employees. Turns out, the lists are pulled from Google’s search database using an algorithm that creates sets, or categories, of common words and names. It’s essentially Google-powered word association — not a window into the world of Google engineers, but into the internet’s collective view of how things are related to one another.

It doesn’t work just for beer, car brands, colors, states, and websites, as reported, but just about any category you can think of. The feature was an outgrowth of a discontinued Google Labs project called Google Sets, so it’s no longer pulling real-time information.

There are useful applications — it’s easy to imagine using the list of states, for example, in creating a survey. “It is also one of those things we do things at Google that’s whimsical and just for fun,” says a Google spokesperson. “It is a snapshot of words and concepts that are connected to each other on the web.” And, in a small but real way, a peek into the giant data-logged brain of the most powerful search engine in the world.

3. Strains of marijuana:

4. Drugs, from heroin to menthols:

5. “The Simpsons” characters:

6. Star Wars characters:

7. Canada is now officially the 58th state:

8. Extreme bucket list:

9. There are almost 100 different names for San Francisco neighborhoods:

10. B-list celebrities (sorry, Emma Watson!):

11. A-list celebrities (plus Zac Efron, Ashton Kutcher, and Josh Holloway?):

12. Top religions, including Zoroastrian:

15. Types of candy:

Check out more articles on BuzzFeed.com!

 
 
Here Are The Top Stories
  • Britain marks 10 years since 52 people were killed in terrorist attacks in London.
  • Bill Cosby testified in 2005 that he obtained sedatives to give to women he wanted to have sex with, the AP reports.
  • The South Carolina legislature took a key step toward removing the Confederate flag from statehouse grounds.
  • Reddit's CEO apologized for the site's "long history of mistakes."
Get The News App

More News

More News

Now Buzzing