Menu
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
575
One way to use Arabic in Excel is to change the language of the Excel interface. To do this, go to the "File" tab and select "Options." Then, select "Language" and choose "Arabic" from the drop-down menu.
Instead, this is due to the way Excel and other spreadsheet programs open a CSV file and display the data therein. Basically, spreadsheet programs are designed to be used for calculation purposes, so they tend to apply mathematical formats to numbers when the CSV file is opened directly into the program.
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.
70
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
