ArcGIS users that work with tabular data that include Hebrew/Arab characters occasionally need to save it as CSV file. This happens especially when using ArcGIS.com or Portal for ArcGIS.
When there are non-Lain characters in the tables, it turns into gibberish after converting the table to CSV.
The following workflow suggest a method for keeping the readability of those characters, using Excel and Notepad:
- Make sure that your operating system regional settings are defined according to your region and language for:
- Open the table in Excel
- Save the table as CSV file (instead of ANSI)
- Open the CSV file in Notepad
- Save the CSV file as CSV with Unicode encoding
That's it - You're done - the CSV table would preserve the original characters.