Opening a csv file

How to open a csv file in excel

There are 2 ways to open a csv file in excel properly:

1. Using the data import wizard
2. Converting the data to columns after double clicking the .csv file

After opening the .csv file the sheet can be stored as .xlsx.

The data import wizard

Import the CSV Data (for better formatting)

1. Open Excel and go to a blank worksheet.
2. Click on the Data tab.
3. Select Get Data (or From Text/CSV in older versions).
4. Choose your CSV file and click Import.

5. Follow the import wizard to properly format your data.

   1. select the comma as the delimiter

Converting the data after double clicking the file

Using "Text to Columns"

1. Select the column containing your CSV data.
2. Go to the Data tab in Excel.
3. Click Text to Columns.
4. Choose Delimited and click Next.
5. Select the correct delimiter (Comma) and click Next.
6. Click Finish—your data should now be split into separate columns.

Official microsoft resource on working with .csv files