---
title: How to open a csv file with Google Sheets
description: Read more about the csv files in this article
image: https://talenthub.io/hubfs/analytics_tabs.png
---

[Skip to content](https://help.starred.com/how-to-open-a-csv-file-with-google-sheets#main-content)

[![Starred Logo B2B Primary - White](https://help.starred.com/hubfs/Starred%20Logo%20B2B%20Primary%20-%20White.svg)](https://help.starred.com/)

Open main navigation

Close main navigation

- [Get in touch](mailto:support@starred.com)

[Get in touch](mailto:support@starred.com)

 How can we help?

- There are no suggestions because the search field is empty.

1. [Starred Help Center](https://help.starred.com/)
2. [Starred](https://help.starred.com/starred)
3. [FAQs](https://help.starred.com/starred#faqs)

# How to open a csv file with Google Sheets

## Read more about the csv files in this article

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:

![](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<https://support.starred.com/docs/how-do-i-convert-a-csv-file-into-xlsx-excel-or-google-sheets#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.

![](https://files.readme.io/bb3f30a-Screenshot_2023-01-02_at_12.52.48_PM.png)

This way, the file will already be opened correctly:

![](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.

![](https://files.readme.io/0c2c91d-Screenshot_2023-01-02_at_1.00.23_PM.png)

1. You can open an empty spreadsheet and import the file. The file might look like this when you first open it:

![](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*:

![](https://files.readme.io/85c0dce-Screenshot_2023-01-02_at_1.22.58_PM.png)

- 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:

![](https://files.readme.io/c5399c7-Screenshot_2023-01-02_at_1.24.47_PM.png)

- [Starred 2.0](https://help.starred.com/starred-2-0#main-content)

    - [Starred for Admins](https://help.starred.com/starred-2-0#starred-for-admins)
    - [🔗 Integrations](https://help.starred.com/starred-2-0#integrations)
    - [Dashboards](https://help.starred.com/starred-2-0#dashboards)
- [Starred](https://help.starred.com/starred#main-content)

    - [Integrations](https://help.starred.com/starred#integrations)
    - [Starred for Admins](https://help.starred.com/starred#starred-for-admins)
    - [How to send surveys](https://help.starred.com/starred#how-to-send-surveys)
    - [How To's](https://help.starred.com/starred#how-tos)
    - [FAQs](https://help.starred.com/starred#faqs)
- [Talenthub](https://help.starred.com/talenthub#main-content)

    - [Driver Framework](https://help.starred.com/talenthub#driver-framework)
    - [Integrations](https://help.starred.com/talenthub#integrations)
    - [Get started](https://help.starred.com/talenthub#get-started)
    - [Understand your data](https://help.starred.com/talenthub#understand-your-data)
    - [Benchmarks](https://help.starred.com/talenthub#benchmarks)
    - [Analysis page](https://help.starred.com/talenthub#analysis-page)
    - [Survey builder](https://help.starred.com/talenthub#survey-builder)
    - [Question Configuration](https://help.starred.com/talenthub#question-configuration)
    - [Career Page & Job Ad Widget](https://help.starred.com/talenthub#career-page-job-ad-widget)
    - [Career page pop-up](https://help.starred.com/talenthub#career-page-pop-up)
    - [Email notification reports](https://help.starred.com/talenthub#email-notification-reports)
    - [Exporting](https://help.starred.com/talenthub#exporting)
    - [Account Management](https://help.starred.com/talenthub#account-management)
    - [Building and Editing Surveys](https://help.starred.com/talenthub#building-and-editing-surveys)
    - [Setting up Custom Variables](https://help.starred.com/talenthub#setting-up-custom-variables)
    - [Survey Setup and Management](https://help.starred.com/talenthub#survey-setup-and-management)
    - [Data Collection](https://help.starred.com/talenthub#data-collection)
    - [Implementation](https://help.starred.com/talenthub#implementation)
    - [Tips and tricks](https://help.starred.com/talenthub#tips-and-tricks)
    - [Branding](https://help.starred.com/talenthub#branding)
    - [How to guides and FAQ](https://help.starred.com/talenthub#how-to-guides-and-faq)
    - [Account management, user roles and more](https://help.starred.com/talenthub#account-management-user-roles-and-more)
    - [NPS and CPS](https://help.starred.com/talenthub#nps-and-cps)
    - [Score calculations](https://help.starred.com/talenthub#score-calculations)
    - [No collection](https://help.starred.com/talenthub#no-collection)
    - [Help Center](https://help.starred.com/talenthub#help-center)
    - [SmartRecruiters](https://help.starred.com/talenthub#smartrecruiters)
    - [Comment tags](https://help.starred.com/talenthub#comment-tags)
    - [Exporting & Reporting](https://help.starred.com/talenthub#exporting-reporting)
    - [Dashboard](https://help.starred.com/talenthub#dashboard)

[![Starred Logo B2B Primary - White](https://help.starred.com/hubfs/Starred%20Logo%20B2B%20Primary%20-%20White.svg "Starred Logo B2B Primary - White")](https://starred.com)

Starred Group A/S  
Indiakaj 1, 1.   
2100 Copenhagen

<https://linkedin.com/company/starred-com> <https://youtube.com/starred> [mailto:support@starred.com](mailto:support@starred.com)

Copyright © 2026 | Starred Group