Search code examples
excelcsvarabic

How to open a CSV file in excel with arabic in it


Hi Please help how to open a CSV file which has arabic in it. Have tried few things, but nothing seem to be working. It is displaying junk values.

Links which i tried:

https://support.office.com/en-us/article/language-accessory-pack-for-office-82ee1236-0f9a-45ee-9c72-05b026ee809f?ui=en-US&rs=en-US&ad=US


Solution

    1. Rename File Extension with Arabic Character from .csv to txt say MS DOS.
    2. Here is the sample file arabic 3

    When you first save the File from csv to txt after renaming it, a pop up dialog will appear arabic2

    3 Click cancel then a dialog box will appear

    arabic2

    1. Save the txt file in Dir and rename to csv.

      Here you will get choices for arabic characters.Arabic 708.720, 28596

    2. save the file and rename to txt, it opens with proper characters as shown below. But please ensure that , separation character is maintained, Some adjustment at line breaks and page may be required

    arabic1