When downloading responses or comments from Starred, the file format is CSV.
CSV means comma-separated values. CSV files are delimited text files that use a comma to separate values.
This might cause the file to look like this when you first open it with Google Sheets or Excel:
No worries, though, because, whether you're using Google Sheets or Excel, it's very easy to transform this view in a much more user friendly file.
If you're working with Google Drive, there are a few ways to open the file when you receive it in your inbox.
- You can click directly on the Edit button (pencil shaped) to open it with Google Sheets.
This way, the file will already be opened correctly:
- If you choose to download it and import it into Google Sheets.
The app will prompt you to choose a separator type. You can click on Detect automatically to let Google Sheets find the separator (usually it's a semicolumn) and divide the data properly into columns.
- You can open an empty spreadsheet and import the file. The file might look like this when you first open it:
When the file is loaded, you can follow these steps to separate the data into columns:
- Click on Data and select Split text to columns:
- The separator will be detected automatically and the file will be organized into columns. You can always change the separator by choosing your preferred one in the dropdown menu:
Similarly, when opening the file with Excel, you have a few options:
Downloading the file from your email and opening it regularly: the software might already recognize the csv and divide the data into columns automatically.
If that does not happen, you can separate the text yourself by following these steps:
- After opening the file, click on Data
- Choose Text to Columns
- You will be prompted to choose a separator, meaning to indicate to Microsoft Excel what to look for in the text to divide the text into columns. Choose Comma:
- Lastly, you can open an empty spreadsheet and import the file:
- Open the Excel spreadsheet where you want to save the data and click the Data tab.
- In the Get External Data group, select From Text.
In the next step, you will be asked to choose a how the data is separated in the file you're importing. Choose Delimited.
This step is crucial because in a csv file data with a comma, and by selecting Delimited here you'll prompt the software to divide the data into separate columns based on the delimiter.
In the next step, choose you delimiter (here, Comma) and you'll already see a preview of how the file will look like. Click Next
After completing the last steps, the final file will look something like this:
Updated about 1 month ago