Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel sheet that contains data that I exported from an Oracle database, and now when I try to open this file from another machine (my laptop), the data appears as strange letters, like Chinese characters, although Arabic is downloaded on my laptop.

How can I read this file?

share|improve this question

migrated from Aug 18 '11 at 18:14

This question came from our site for professional and enthusiast programmers.

When you say exported, how did you do that? Are you sure you have the right file? – soandos Aug 18 '11 at 19:14
@soandos Excel supports many different types of database connections using ODBC – James Aug 19 '11 at 17:29
I know, but not my question. If he is just trying to read a raw oracle file, it would be unreadable in excel. That is what I am asking. – soandos Aug 19 '11 at 18:27

I was having the same problem, and what I was seeing was unknown charcaters like this

  • ????? ???? ????? ????
  • or like this

  • تمويل بدون تحويل راتب

The Solution

  • Create notepad.txt file
  • Copy the unknown characters in it, and then hit "ctrl+s" to save the file
  • Change the extension from .txt to .srt
  • Open the file using Microsoft Word
  • It will open with small windows in Word showing the encoding of the original form of the unknown characters, it automatically converts them to understandable Arabic language.
  • Just in case the if the automatically converting didn't work chose from the encoding list, choose "UTF-8" or "Arabic (Windows)" "Auto Select" and it will convert the unknown characters to Arabic characters
  • Take the Arabic data copy and paste them back in the Excel file.

Mission Accomplished :D

share|improve this answer

You must log in to answer this question.