Excel Exporting Arabic English mix text to CSV file contains Question Marks

excel csv text utf-8 arabic
24,541

I found this was because Excel is not exporting the file as UTF-8. Unfortunately to do so, I had to install Open Office which lets you select the encoding type when saving an Excel spreadsheet as CSV. Hence I was able to select UTF-8 from a drop down. The resultant file now even in Notepad, shows the correct mixture of Arabic and English characters.

Share:
24,541

Related videos on Youtube

Hashim Akhtar
Author by

Hashim Akhtar

C#, Objective-C developer.

Updated on June 27, 2020

Comments

  • Hashim Akhtar
    Hashim Akhtar almost 4 years

    When I export an Excel spreadsheet that contains a mix of Arabic and English characters to CSV, the resultant file contains question marks instead of the Arabic text

  • Hashim Akhtar
    Hashim Akhtar almost 11 years
    I tried that but it still doesn't save in UTF-8.
  • haakym
    haakym about 10 years
    I had the UTF-8 option but it didn't work sadly
  • Ehsan Khodarahmi
    Ehsan Khodarahmi over 9 years
    It didn't work for me too!
  • thanos.a
    thanos.a almost 8 years
    Doesn't work for me either
  • sorrow poetry
    sorrow poetry almost 7 years
    its not working

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

Opening CSV with UTF-8 BOM via Excel
PHP generated csv file is displaying £ for a UK pound sign (£) in Excel 2007
What's the best way to export UTF8 data into Excel?
Encoding issues for UTF8 CSV file when opening Excel and TextEdit
Javascript export CSV encoding utf-8 issue
Is it possible to force Excel recognize UTF-8 CSV files automatically?
Excel to CSV with UTF8 encoding
Excel VBA - How to read csv file line by line but not the whole file
How to add filename and file extension to window.open method that exports a JSON array to a CSV string then to a file in javascript?
Writing to a text file error - Must be str, not list