Click For Photo: https://static.makeuseof.com/wp-content/uploads/2013/08/colorpapercohdra15-1680x840.jpg
If Google Forms is not yet your go-to form maker, it’s time for us to change your mind. There are a lot of powerful tools hidden away in places you may not find unless you know what you’re looking for. We’re here to make sure you know some advanced Google Forms tips and tricks.
Unlock the "Essential Google Drive Keyboard Shortcuts" cheat sheet now!
User - Google - Forms - Results - Spreadsheet
If you’re a moderate user of Google Forms, you probably already know that you can choose between storing your results as a spreadsheet or keeping them within the form. However, you may not know which one to choose or why.
You can choose your results destination by clicking the More (three-dot icon) button and picking Select Response Destination. Then either create a new spreadsheet or add the responses as another tab to an existing spreadsheet.
Responses - Spreadsheet - Create - Spreadsheet - Button
If you want to quickly send your responses to a spreadsheet, you can also click the green Create Spreadsheet button. Or to download right to your computer, Select More > Download responses (.csv).
If you decide to create a new spreadsheet, it will reside in Google Sheets with the name you assign or the default which is the form name. If you choose to add to an existing spreadsheet, you’ll pick the one you want in the pop-up window for Google Sheets.
Spreadsheet - Results - Data - Results - Forms
Using a spreadsheet to store results is ideal if you want to manipulate the data. You might prefer to keep the results in forms though if you are expecting more than 400,000 responses as that’s the limit of rows in a regular Google Sheets spreadsheet.
Regardless of which destination you choose, you can always go to Responses > Summary to get a more visual view of the results, which is perfect if most of your questions are multiple choice or can be graphed in some way.
Wake Up To Breaking News!
Hell sometimes looks an awful lot like an office cubicle.