Choose where to save form responses (2024)

When responders fill out your form, you can choose if you want to find the responses in a linked Google Sheet.

Choose where to store responses

  1. Open a form in Google Forms.
  2. At the top, under “Responses,” click Summary.
  3. At the top right, click More Choose where to save form responses (1) Choose where to save form responses (2) Select destination for responses.
  4. Select an option:
    • Create a new spreadsheet: Creates a spreadsheet for responses in Google Sheets.
      • When you use your Google Forms data to create a new sheet, Google Sheets automatically puts your data in a table, bringing format and structure to your data. Learn how to use tables in Google Sheets.
    • Select existing spreadsheet: To store responses, select from your existing spreadsheets in Google Sheets.
  5. Click Create or Select.

Important:If you’ve shared a form with a collaborator, they may also have access to the form’s linked spreadsheet. If you want to remove a collaborator, you'll haveto remove them from the form and the spreadsheet separately.

Tip:You can find the response spreadsheet in the Google Sheets homescreen, the Google Sheets app, or in Google Drive.

Unlink a spreadsheet from your form

  1. Open a form in Google Forms.
  2. At the top, under “Responses,” click Summary.
  3. At the top right, click More Choose where to save form responses (3) Choose where to save form responses (4) Unlink form Choose where to save form responses (5).
  4. Click Unlink.

Delete a form or responses

Tip: If you keep responses in a spreadsheet, you have a separate file in Google Drive. You can delete the spreadsheet or the form without deleting the other connected file. If you delete any responses in a form, it can't be undone.

Delete all responses from a form

  1. Open a form in Google Forms.
  2. At the top, under “Responses,” click Summary.
  3. At the top right, click More Choose where to save form responses (6) Choose where to save form responses (7) Delete all responses Choose where to save form responses (8).
  4. Click OK.

Delete individual responses

  1. Open a form in Google Forms.
  2. At the top, under “Responses,” click Individual.
  3. To find the response you want to delete, click Previous Choose where to save form responses (9) or Next Choose where to save form responses (10).
  4. Click Delete Choose where to save form responses (11) Choose where to save form responses (12) YES.

Tip:If you store responses in Google Sheets, deleting a response from the form or sheet will not affect the other.

Choose where to save form responses (13)

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Choose where to save form responses (2024)

FAQs

Choose where to save form responses? ›

Any new response data in your form will be reflected in your workbook. If you've created your form in Excel for the web and select Open in Excel, your Excel workbook is automatically stored in OneDrive for work or school and contains a live data connection to your form.

Where do Microsoft Forms responses get saved? ›

Any new response data in your form will be reflected in your workbook. If you've created your form in Excel for the web and select Open in Excel, your Excel workbook is automatically stored in OneDrive for work or school and contains a live data connection to your form.

Where are the Google Forms responses saved? ›

A response in a Google form includes the replies to all questions made by a form respondent when they submitted the form. Google Forms counts a single form submission as one response. Data from all responses is available immediately after each form submission in the Responses tab.

How to save responses from Microsoft Forms? ›

In Microsoft Forms on the Responses tab, select Open in Excel. Your form responses will open in an Excel workbook. From Excel, you can export or save your form responses as a PDF file.

Where do form responses go? ›

View responses

Open a form in Google Forms. At the top of the form, click Responses. Click Summary.

Can Microsoft Forms responses be saved as a PDF? ›

Converting Microsoft Forms responses to PDF

Click on View results. Click on the three-dot menu button. Choose Print response. Choose Save as PDF from the printing options.

How do I save Microsoft Forms locally? ›

Forms customized with form pages
  1. Click the File tab.
  2. Click Save As.
  3. In the File name box, type a name for the form.
  4. In the Save as type box, click a file type. To save the form as an Outlook template, click Outlook Template, and then save the form in the Templates folder.
Sep 12, 2021

What are the destination options for storing and viewing responses to Google Forms? ›

Choose where to save form responses
  • Open a form in Google Forms.
  • At the top, under “Responses,” click Summary.
  • At the top right, click More. Select destination for responses.
  • Select an option: Create a new spreadsheet: Creates a spreadsheet for responses in Google Sheets. ...
  • Click Create or Select.

Where are my answered Google Forms? ›

Navigate to the Responses tab and click the Google Sheets icon in the top right corner. This will open a spreadsheet of all of your collected answers. Viewing your responses as a spreadsheet ensures you can access all of your answers from one place.

How do I save correct answers in Google Forms? ›

Create an answer key
  1. To add a question, click Add question .
  2. Fill out your question and answers.
  3. In the bottom left of the question, click Answer key.
  4. Choose the answer or answers that are correct.
  5. In the top right of the question, choose how many points the question is worth.

Where does Microsoft Forms save files? ›

The answer is that MS form attachments are stored in Microsoft Onedrive of the author of the form. This MS form tutorial also outlines an important note about sharing access to the Microsoft Form attachments. ​Check it out here!

How do I save individual responses in Google forms? ›

Open your form in Google Forms > Click Responses > Click More ⋮ icon > Click Download responses (. csv)

Where do you put the correct answer on Google Forms? ›

Fill out your question and answers. In the bottom left of the question, click Answer key. Choose the answer or answers that are correct.

Who can see Google Form responses? ›

Respondents can view your form and provide their responses. However, they can not edit the form or view other responses. Collaborators, on the other hand, can edit the form and the responses. You can add collaborators to a form by clicking on the “More options” button and selecting “Add collaborators.”

Where are my submitted Microsoft Forms? ›

Click your profile image at the top right corner of Microsoft Teams. Then, select “Your apps” & “Forms”. Here, you'll see all forms associated with your account, including the ones you submitted. Pro Tip: To save time, favorite commonly used forms.

How to retrieve Microsoft Forms data? ›

Recover a deleted form
  1. Go to the Deleted forms tab. This tab serves as your recycle bin. ...
  2. On the form you want to delete, select More options in the lower right corner of the form tile, and then click Restore. ...
  3. To see your recovered form, go to your All forms tab.

Where are Microsoft Forms Excel files stored? ›

In Microsoft Forms, you can easily view all of the response data for your form or quiz in Microsoft Excel. An Excel workbook with your response data will be downloaded to your desktop or stored in OneDrive, depending on the starting point of your form or quiz.

Top Articles
Top 6 Civil Engineering Design Problems
Save the Bees - Greenpeace USA
Find All Subdomains
Chalupp's Pizza Taos Menu
Wild Smile Stapleton
Walgreens Alma School And Dynamite
Call of Duty: NEXT Event Intel, How to Watch, and Tune In Rewards
Minn Kota Paws
Purple Crip Strain Leafly
Oscar Nominated Brings Winning Profile to the Kentucky Turf Cup
Reddit Wisconsin Badgers Leaked
Erskine Plus Portal
Echat Fr Review Pc Retailer In Qatar Prestige Pc Providers – Alpha Marine Group
Alexander Funeral Home Gallatin Obituaries
Nick Pulos Height, Age, Net Worth, Girlfriend, Stunt Actor
Northeastern Nupath
The Pretty Kitty Tanglewood
Canvasdiscount Black Friday Deals
Hannaford To-Go: Grocery Curbside Pickup
Wisconsin Volleyball Team Boobs Uncensored
Bocca Richboro
Cylinder Head Bolt Torque Values
Mastering Serpentine Belt Replacement: A Step-by-Step Guide | The Motor Guy
Craigslist Middletown Ohio
Gridwords Factoring 1 Answers Pdf
Otis Offender Michigan
Mrstryst
Urban Blight Crossword Clue
How to Destroy Rule 34
Go Smiles Herndon Reviews
Magicseaweed Capitola
Pitchfork's Top 200 of the 2010s: 50-1 (clips)
Collier Urgent Care Park Shore
Blasphemous Painting Puzzle
Discover Wisconsin Season 16
Join MileSplit to get access to the latest news, films, and events!
Walmart Pharmacy Hours: What Time Does The Pharmacy Open and Close?
Craigslist Farm And Garden Reading Pa
Exam With A Social Studies Section Crossword
Sour OG is a chill recreational strain -- just have healthy snacks nearby (cannabis review)
Exploring the Digital Marketplace: A Guide to Craigslist Miami
Random Animal Hybrid Generator Wheel
Costco The Dalles Or
Crigslist Tucson
Blog Pch
Mikayla Campinos Alive Or Dead
How To Win The Race In Sneaky Sasquatch
Parks And Rec Fantasy Football Names
Costco Tire Promo Code Michelin 2022
Latest Posts
Article information

Author: Neely Ledner

Last Updated:

Views: 5803

Rating: 4.1 / 5 (62 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Neely Ledner

Birthday: 1998-06-09

Address: 443 Barrows Terrace, New Jodyberg, CO 57462-5329

Phone: +2433516856029

Job: Central Legal Facilitator

Hobby: Backpacking, Jogging, Magic, Driving, Macrame, Embroidery, Foraging

Introduction: My name is Neely Ledner, I am a bright, determined, beautiful, adventurous, adventurous, spotless, calm person who loves writing and wants to share my knowledge and understanding with you.