All Collections
Random characters showing in downloaded excel file
Random characters showing in downloaded excel file

Opening an excel file to find your data showing random characters?

Updated over a week ago

You might export or download a file from the portal and then open it in excel, only to find the Excel sheet showing random characters in certain data.
The issue could be due to Excel not being able to detect the correct character encoding.

Firstly, visit the portal and check if the detail showing correctly in the portal.
If yes, then kindly apply a workaround below to fix the issue of random characters showing in the excel file.


  1. Open a blank sheet in excel, and from the data ribbon choose import from text. Select the exported file.

  2. Change the file origin to unicode(UTF-8). Follow the wizard and select other options as required. then click on finish.

  3. The text should now be correct.

Did this answer your question?