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

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:

13. Birds:

14. Poets:

15. Types of candy: