Welcome to EdListen; Podcast for educators.
Never Stop Learning
Please Join the EdListen G+ Community

How To: See New Google Form Results At The Top

Google Forms is great at adding data to a spreadsheet, but often all you want to see is the new results and that could be several hundred rows down.   Instead of scrolling down all the way down here is quick formula you can use to create a sheet that always shows the data at the top.

  1. In your form results create a new Sheet.
  2. In cell A1 enter this formula:
    1. =query('Form Responses 1'!1:100002, "Select * order by A desc",1)


  • =query() is a function built into google: more info
  • 'Form Responses 1'!1:100002 is the sheet name and range of the form data
  • Select * tells the query to select all the columns, This can be changed to Select A,B,C format also
  • order by A desc tells the query to reverse the order based on column A
  • ,1 tells the query to include the headings.

Also check out:
  • Also check out the EZ Query add-on.   This gives you a graphical interface to create simple queries.  At the time of this blog post "order by A desc" is not an option but it is on my road map to include in the future. 

Edu on Air: Creating a culture: Google Apps add-on slam

Edu On Air 2015 event page: https://plus.google.com/u/0/events/c7cndlfsplecdcjfqgf5as1rj3c

My school went 1:1 this year which meant a whirlwind of change. Creating this new culture meant creating or adapting school workflows. I'll showcase the add-ons that have helped me like autoCrat for automated Mail Merges, Choice Eliminator for parent teacher conferences, CheckItOut and Lab Scheduler.  Also my newest add-on EZ Query.

This session is part of Education on Air, the free online conference from Google. Register for free at http://goo.gl/Gkww6N.

The journey of creating a culture.
  1. Get everybody on board, starting with the office staff and administration
  2. Change common workflows
  3. Give teachers time to start using it in the classroom. 

Workflows that I have changed and the tools I used to help me do it.

Author Links:

Announcing EZ Query Add-on

EZ Query will help make spreadsheets and form data easily readable.  The Add-on utilizes the built-in query function, so data is always up to date.  With this add-on you can easily select the columns to show and add filters so you only see want.