How to Open Product Feed in Arabic?

Excel is not capable to process UTF-8 characters correctly when CSV is opened directly in Excel.

The solution is to use data import:

  1. Save the exported file as a csv
  2. Open Excel
  3. Import the data using Data–>Import External Data –> Import Data
  4. Select the file type of “csv” and browse to your file
  5. In the import wizard change the File_Origin to “65001 UTF” (or choose correct language character identifier)
  6. Change the Delimiter to comma
  7. Select where to import to and Finish