How do I convert a csv file into xlsx (Excel) or 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 or Excel:

2762

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.

Google Sheets

If you're working with Google Drive, there are a few ways to open the file when you receive it in your inbox.

  1. You can click directly on the Edit button (pencil shaped) to open it with Google Sheets.
2140

This way, the file will already be opened correctly:

2738
  1. 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.

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

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:
2770
  • 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:
954

Microsoft Excel

Similarly, when opening the file with Excel, you have a few options:

  1. Downloading the file from your email and opening it regularly: the software might already recognize the csv and divide the data into columns automatically.

  2. 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
1200
  • 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:
1226
  1. 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.
966

In the next step, you will be asked to choose a how the data is separated in the file you're importing. Choose Delimited.

1196

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

1226

After completing the last steps, the final file will look something like this:

2808