Problem: When exporting Turkish character encoding into a csv file from an Excel Table (Excel 2013) as a source file I can´t import the resulting csv into QGIS to still displaying the characters correctly . I´m using: "Add Layer" - "Add Delimited Text Layer" and it doesn´t work no matter whether I use as encoding option "UTF-8" or "System".
This is possibly rather an excel problem since the problem concerns exporting from Excel. If anyone has any suggestion that would be great, otherwise anyone else reading this with the same problem could try the following workaround.
One possible workaround I use is using Access as an in-between-step:
Importing the Excel-Table into Access retains the special characters. Exporting from Access into a txt or csv file you have the special button called "Advanced options" in the lower left of the export window where you can specify the Encoding of the resulting exported file. If I use "UTF-8" here and then import the resulting csv or txt file into QGIS selecting "Encoding "UTF-8" everything works fine.
Another Question on this site concerns exporting the other way round: Exporting from QGIS to Excel retaining special characters, see here: Export shapefile with "non standard" characters to csv and read in excel
So how do I get Excel to export the characters correctly for QGIS to read them?
My System is
Windows 7 Professional 64-bit (6.1, Build 7601)
Service Pack 1
Language: German (Regional Setting: German)
QGIS Version is 2.12.0 since I haven´t had time to upgrade.