CSV files use a comma and Unicode Transformation Format (UTF) to share text between apps. UTF-8, UTF-16, and UTF=32 work better with specific apps.

A CSV (comma-separated values) file is a text file in which information is separated by commas. CSV files are most commonly encountered in spreadsheets and databases.

Yes, we can change setting with other columns delimiter, but the column value can contains other columns delimiter too. the csv file type only use comma delimiter whatever you have quotes in strings, ...