How to export store's csv that Excel will read properly?

Question

In Sales > Orders when I export csv and open it in excel some characters are not encoded properly. e.g: ü is exported as: Ã¼ etc.

Do suggest some solution to this problem. Thanks

Preferred This Link It May Help You!!! magento.stackexchange.com/questions/42929/… — R_Solanki, Jan 9 '17 at 11:33
@RushikeshSolanki I have tried it , but problem still persists, recommend some other solution please. — Irfan Ghaffar, Jan 9 '17 at 12:23

AspiringProgrammer · Accepted Answer · 2017-01-09 12:08:34Z

1

I'd like to extend from this and share my experience.

As well as that I also use an extension called https://www.magentocommerce.com/magento-connect/blue-jalappeno-order-export.html which is HIGHLY customizable in the extensions model - if you'd like to give a little bit more information on what you want the export to look like I can point you in the right direction.

answered Jan 9 '17 at 12:08

1141 silver badge14 bronze badges

Actually, when exported csv file is opened in other editors i.e other than Ms excel, there is no encoding problem but when I open it in MS excel, many characters have encoding problem. – Irfan Ghaffar Jan 9 '17 at 12:15
Suggest some solution other than using any extension. – Irfan Ghaffar Jan 9 '17 at 12:17
stackoverflow.com/a/26871596/2680550 – AspiringProgrammer Jan 9 '17 at 12:18
stackoverflow.com/questions/20215700/…, I have used this one but it do not works. – Irfan Ghaffar Jan 9 '17 at 12:20
,recommend some other solution please. – Irfan Ghaffar Jan 9 '17 at 12:24

Add a comment |

1 Answer 1