See attached screenshots.
In csv while downloading using (,comma) delimeter , it is downloaded as .csv , extension still looks like a regular excel sheet.
The same thing when we try with (:colon ) delimeter the values are in one column separated by colon.
I need Colon separator like file for comma separator also.
Hi,
This is because of your machine region setting. Your CSV file should know the separator character and it picks from region setting.
Go to region setting >> Additional settings >> list separator and change to ":" your csv would load correctly
Your answer is not solved my problem.
Hi ,
As a second option you can define the separator in your csv file . open the csv file in notepad and define the separator as below
In first line write sep=: save it and open in excel.
Hope this would help.
Best regards
Devendra
