CSV File download using CSVUtil Extension

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


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.