Default CSV format

Should be UTF-8

Example in test.csv

"id";"name";"value";"metadata"
1;"Alice Cooper";3.14;"{""role"":""admin""}"
2;"Bob; Jr.";5.67;"{""role"":""user""}"
3;"Carol ""C"" Smith";8.90;"{""role"":""manager""}"
4;"ÕõÄäÖöÜü "" ' Tähestik";8.90;"{""role"":""manager""}"

Excel → Data → Get Data → From Text/CSV