1. home
  2. Text
  3. Advanced SMS

How do I open a .CSV-file in Excel?

Method 1

  1. Right click on download .csv and click “save link as”. Save this text file in excel. Open the file in excel; it might instantly convert it to columns in which you can work.

  2. If not; Press data > Text to Columns

  3. Press delimited and select “comma” as a delimiter.

  4. Click “Finish”

Method 2

  1. Same as method 1.

  2. Press data > New Query > From File > From Text > Select the downloaded file

  3. Wait for the query editor to load

  4. Press close and load.

Last modified on 22/12/2017
Was this article helpful?