Google Spreadsheet Unique Item Count

Google sheets can do some neat tricks. Here’s how you can generate a chart of unique words submitted and their counts.

The form for collecting a single word.

The formula to paste in column C. All credit to this Stack Overflow post.
=QUERY({B:B,B:B},”select Col1, count(Col2) where Col1 != ” group by Col1 label count(Col2) ‘Count'”,1)

The embedded chart.

In messing around with options around this, I was also looking at getting JSON data out of Google sheets.

https://spreadsheets.google.com/feeds/list/1gwiU0j-o50m1L5yEU7OR-v9GSuxNyQeD5_zosjBpYvE/1/public/values?alt=json

To break that down https://spreadsheets.google.com/feeds/list/YOUR_SHEETS_UNIQUE_ID/THE_NO_1_FOR_THE_FIRST_SHEET/public/values?alt=json

It works with Benson as seen over here which is pretty neat. Although I haven’t gotten search working.