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 ...
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