Column cell have comma(,). Convert Excel to CSV

New Contributor

I have Excel sheets with thousands of rows with name, address having comma (,) and values 

After converting to csv, the address column is taken as 2 or 3 different columns , as it has comma in that cell.

 

Is there any options to take the address cell as single column with comma, while reading from CSV?

1 Reply

@Kowsivenus 

If an address is one cell

image.png

when you save Excel file to csv it shall be as

image.png

If open such csv file in Excel it shows data correctly

image.png