Translating...

Cancel

Jason Kolb
1 year agoPublic
This little hack is an absolute gem for doing market research. Try putting in some keywords relevant to your customer base, and see what Google pops out as related. It can be pretty enlightening.
Alireza Yavari originally shared:

Google Sets
Give it two examples, and Google's spreadsheet can make a list of almost anything. 

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.

It doesn't just work for beer, car brands, colors, states, or 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.

See more examples at http://goo.gl/rHrYN
176
Samuel Hart1 year ago
Good lord, why wasn't this advertised more? It's a fantastic idea!+20
Jason Kolb1 year ago
+Samuel Hart I'm not sure, I was pretty surprised when I saw it too. I guess it's part of an old Google tool that I had never heard of called "Google Sets" which is no longer available. Pretty neat that they folded it into Google docs though. I'm curious how you could actually use this within a larger spreadsheet to do some interesting things.+1
Mark Valdez1 year ago
Awesome feature...wish we knew about it sooner!+1
Andy Thornton1 year ago
I couldn't get this to run when I tried it.+6
Jason Kolb1 year ago
Are you guys holding down Ctrl or Option while you do this? (Only option/alt works on my Mac)+5
It is somewhat documented at http://support.google.com/drive/bin/answer.py?hl=en&p=spreadsheets_autofill&answer=75509
This page lacks information about importance of control/alt key at the moment.
+1
Gustavo Zapico1 year ago
Magic? Google should advertise this feature. Sometimes good geeks do great things ;) Thanks Google sets.
James Wade1 year ago
The unfortunate side affect of this is when you are working with numbers. You get the first few, then you get things like prev and next instead of numbers because its baked on their index which has lots of page numbers. Annoying!
James Wade1 year ago
The unfortunate side affect of this is when you are working with numbers. You get the first few, then you get things like prev and next instead of numbers because its baked on their index which has lots of page numbers. Annoying!
James Wade1 year ago
The unfortunate side affect of this is when you are working with numbers. You get the first few, then you get things like prev and next instead of numbers because its baked on their index which has lots of page numbers. Annoying!
James Brown1 year ago
Too bad it is no longer supported and therefore the data is stale (and will get more stale over time) apparently.
Ryan Fox1 year ago
This used to be available in the Google Labs under the name "Google Sets", with a web frontend.
Noah Koch1 year ago
This is great! My guess would be Google Sets uses the same engine which powers the related people/results page on my Google searches, or visa versa.
Craig Perry1 year ago
I was wondering how it works, i found a little info as there's a patent for this: http://www.google.co.uk/patents/US7350187 but would be interested in a better writeup if anyone knows of one.
Dimitar Ignatov1 year ago
hahaha briliant 
James Brown1 year ago
+Michael Francois
I wonder if that really means that "google sets" is not really dead.  In other words, the data is being refreshed by some backend service.

We need a test case of something that didn't exist prior to sets being canceled and see if it shows up in a list created in google drive.  Anyone have a suggestion?  Maybe tropical storm names or something similar.