Downloaded CSV File Shows Mojibake While Opened With Excel

Created by Deleted Agent, Modified on Mon, 17 Feb, 2020 at 12:07 PM by Deleted Agent

If there is mojibake after downloading the CSV file from Talent Search Engine folder (opened with Excel), you can solve it in the following ways:

【Solution A】

1. After downloading the CSV file, right click and open it by “Notepad”.

2. After opening notepad, click on “Save as” to save the file or overwrite the old file directly. Save and close.

3. Right click to select the file again and open it with Excel. It can now be displayed in a normal condition.

【Solution B】

1. Create a new blank Excel workbook. Click on “From Text” in “Data” tab and import the CSV file. (For Mac OS, select “Import” from “File”, select the CSV file.)

2. Select “65001: Unicode (UTF-8)” at “File origin” and click on "Next".

3. Check “Comma” and uncheck other boxes. Click “Finish”.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article