What can we do if there are many mojibake or corrupted data in the exported data file?
You will need to use import the csv file to excel with UTF-8 if there is any Chinese character. It will be caused the mojibake or other error if you open the csv file directly.
Please refer to the guide
here on how to import the file to excel with UTF-8.