Actual postgres odbc excel 2016 utf-8 issues

#Actual postgres odbc excel 2016 utf 8 issues how to
#Actual postgres odbc excel 2016 utf 8 issues manual

I make the same experience: Writing russian or greek data into a UTF8 CSV file with BOM results in garbage in Excel:ДЄ solution is to not use CSV at all. 'I also tried specifying UTF-8 BOM EF BB BF, but Excel ignores that.' This is already part of the question of Lyubomyr Shaydariv: Well at least in Excel 2007 this is not possible if you use CSV files because the UTF8 BOM is ignored and you will see only garbage.

#Actual postgres odbc excel 2016 utf 8 issues how to

So the question is how to make Excel show UTF8 data with a simple double click?

#Actual postgres odbc excel 2016 utf 8 issues manual

You would need a manual for each Excel version. The answer marked as the accepted answer with 200+ up-votes is useless for me because I don't want to give my users a manual how to configure Excel.ДЄpart from that: this manual will apply to one Excel version but other Excel versions have different menus and configuration dialogs. 'When I was asking this question, I asked for a way of opening a UTF-8Д¬SV file in Excel without any problems for a user.' It is incredible that there are so many answers but none answers the question: So I'm accepting Mark's answer as the best one. I really hope it wasn't a technical issue and I hope there is no more discussion on which answer is greater now. Both answers are great, but Alex's one fits my not clearly specified question a little better.ДЇive months later after the last edit, I've noticed that Alex's answer has disappeared for some reason. Mark's answer promotes a more complicated way for more advanced users to achieve the expected result. That is what I confused with automatically here. From the usability point of view, Excel seemed to have lack of a good user-friendly UTF-8 CSV support, so I consider both answers are correct, and I have accepted Alex's answer first because it really stated that Excel was not able to do that transparently. There are two answers for this questions that I appreciate the most: the very first answer by Alex, and I've accepted this answer and the second one by Mark that have appeared a little later. That is very confusing and it clashes with VBA macro automation. However, I used a wrong formulation asking for doing it automatically. When I was asking this question, I asked for a way of opening a UTF-8 CSV file in Excel without any problems for a user, in a fluent and transparent way. I have to say that I've confused the community with the formulation of the question. Which tools may potentially behave like Excel does? I also tried specifying UTF-8 BOM EF BB BF, but Excel ignores that. And I don't know how to force Excel understand that the open CSV file is encoded in UTF-8. diacritics, cyrillic letters, Greek letters) in Excel does not achieve the expected results showing something like Р“вЂћ/Р“В¤, Р“вЂ“/Р“В¶. But opening such CSV files (containing e.g. The application always uses UTF-8 because of its multilingual nature at all levels. I'm developing a part of an application that's responsible for exporting some data into CSV files.

Actual postgres odbc excel 2016 utf-8 issues