CSV files exported from the system are not displayed in Excel.

CSV file: tab (\ t) is separated. You need to save the file as a unicode encoding format. After opening the CSV file in Excel, the file is loaded correctly.

CSV file: comma (,) segmentation, you need to save the file as UTF-8 encoding format, Excel open the CSV file and load correctly.

CSV files separated by tab (\ t:

After the CSV file is separated by tab (\ t), if the file is ANSI or the UTF-8 encoding format is not correctly displayed in Excel, if you change the CSV file to the Unicode encoding format, it can be correctly displayed in Excel., As follows:

In addition, if the exported file is separated by commas (,), then the CSV file encoding format must be UTF-8 format in order to use Excel correct loading, Other encoding will not be able to load correctly!