Excel for mac does not recognize ascii code 160

broken image
broken image

You must first change the General Settings, so export files use the correct encoding.

If data has been corrupted, there is nothing we can do the only thing to do is to input the characters again in DEAR, or input the characters in Excel, save to CSV, and import. xlsx) with the correctly formatted Chinese characters (or other Unicode characters) in case files from DEAR get overwritten. We recommend keeping a backup in Excel format (.xls or. This is a limitation of the CSV format that is beyond DEAR's control. If the overwritten file is then imported into DEAR, it will overwrite the characters in the system, and they CANNOT be recovered. NOTE: If you export a file in the correct format and save it as a simple CSV, the characters will be overwritten and CANNOT be reverted to the correct format. any non-Latin scripts (Hebrew, Cyrillic, Japanese, etc.).However, it is possible to import/export Unicode characters following these steps. This is a limitation of the CSV format and not something that can be changed in DEAR. Simple CSV files do not support Unicode/UTF-8 characters.