Forum Discussion
Column cell have comma(,). Convert Excel to CSV
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
If an address is one cell
when you save Excel file to csv it shall be as
If open such csv file in Excel it shows data correctly
