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.

To break that down

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