How to open a csv file with Google Sheets
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:
![Screenshot 2023-01-02 at 1.19.46 PM.png 2762](https://files.readme.io/236a305-Screenshot_2023-01-02_at_1.19.46_PM.png)
No worries, though, becauseit's very easy to transform this view in a much more user friendly file.
Opening the 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:
![Screenshot 2023-01-02 at 12.58.42 PM.png 2738](https://files.readme.io/9a35dff-Screenshot_2023-01-02_at_12.58.42_PM.png)
- 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:
![Screenshot 2023-01-02 at 1.19.46 PM.png 2762](https://files.readme.io/eb82211-Screenshot_2023-01-02_at_1.19.46_PM.png)
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:
![Screenshot 2023-01-02 at 1.24.47 PM.png 954](https://files.readme.io/c5399c7-Screenshot_2023-01-02_at_1.24.47_PM.png)
Updated about 1 year ago