How to Download Google Form Responses as CSV
Learn how to easily download Google Form responses as a CSV file using two different methods, either from a linked Google Sheet or directly from the form itself.
You're trying to download your Google form responses as a CSV and I'm going to show you two ways to do that. One is if you have them in a Google sheet already, we can go to file download. We can select comma separated values , CSV , and that will immediately download as a CSV the tab that we're on. Let's open that in C and this is what it looks like. Just pure data here, timestamp, name, score, date, time, all the data we have without all the extra columns and rows. But let's say we want to download it directly from the form. You may search in your Google Drive and find the form and not the sheet. I'll show you how to do that. Go up to Tools, Manage Form, Edit Form. There's three tabs here, Questions, Responses, and Settings. We're going to click on Responses and click on the three dots in the upper right corner and we can download responses.
This will download as a zip file. Notice, however, there is some data missing. That's because I went back and edited the date and time in the spreadsheet of these two first pieces of data . When you download a CSV from the Google form itself, It will not have any data you edit or manipulate in the sheet. So that's one reason why you may want to download either the Google Sheet to get all of the data if you've been manipulating that data or cleaning that data in some way. But also it might give you a reason to go and download the responses directly from the Google Form if you want the raw answers and responses as they were entered when they were entered. That gives you two ways to download Google Form responses as a CSV file.