Need to open .csv file in Excel? The whole row of all delimited “coma separated” values are shown in the same cell? Fix it simple way.

HHot to open .CSV file?

How to open a .CSV file?

Here is a situation – you received a .csv file (stands for “coma separated values”) but when opening it in Excle see that The whole row of all delimited “coma separated” values are shown in the same cell.

To open it properly to see each coma delimited value in its separate cell, you need to use Excel’s “Import Text File” wizard:.

1) From the Data menu, select “Get External Data,”

2) Clcik “Import Text File.”

3) Change “Files of Type” to “All Files,”

4) Browse to the place where you file is located and select the .csv file you want to import.

The wizard will look like this:

csv coma delimited coma separated values file - how to open in Excel?

csv coma delimited coma separated values file – how to open in Excel?

“Delimited” means that data points in your file are separated by specific characters, so that is the right choice. If you are using a Macintosh computer, change File Origin to “Macintosh.” If you are using windows, leave it as “Windows (ANSI).” Click Next. The window will now look like this:

csv coma delimited coma separated values file - how to open in Excel?

csv coma delimited coma separated values file – how to open in Excel?

This screen lets you select the character that separates your data points. Uncheck “Tab” and check “Comma.” When you select Comma, the preview window below should show your data points divided by vertical lines. Quickly scroll through the data to make sure they are divided correctly. Click Next. The window will now look like this:

csv coma delimited coma separated values file - how to open in Excel?

csv coma delimited coma separated values file – how to open in Excel?

This step allows you to declare what types of data you have. Click on the column that contains the object IDs, then click “Text.” Excel will now read that column as a text string rather than a number. Leave the rest of the columns as “General.” Click “Finish.” Select where you want to paste the data, then click OK. You should now see your data, with the object IDs complete.

Share Button