[Skip to main content](#vessel-content)

#   CSV export Cyrillic encoding error

##

- **[alexintras](/forum/user/4141-alexintras "View alexintras's Profile")**
- [![alexintras's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4141.jpg)](/forum/user/4141-alexintras "View alexintras's Profile") Topic Author
- [ Offline](/forum/user/4141-alexintras)

Less More

- Posts: 32
- Thank you received: 0
-
-
-
-

15 years 1 month ago [\#27154](#27154) by [alexintras](/forum/user/4141-alexintras "View alexintras's Profile")  *[CSV export Cyrillic encoding error](/forum/3-bug-report/27154-csv-export-cyrillic-encoding-error#27154 "Then exporting Order to CSV, all data of product write en Cyrillic have broken encoding. Can you check this problem?")* was created by *[alexintras](/forum/user/4141-alexintras "View alexintras's Profile")*

Then exporting Order to CSV, all data of product write en Cyrillic have broken encoding. Can you check this problem?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzE1NC1jc3YtZXhwb3J0LWN5cmlsbGljLWVuY29kaW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

15 years 1 month ago [\#27161](#27161) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: CSV export Cyrillic encoding error](/forum/3-bug-report/27154-csv-export-cyrillic-encoding-error#27161 "Then exporting Order to CSV, all data of product write en Cyrillic have broken encoding. Can you check this problem?")*

The data is exported as a CSV in UTF8. If you don't see the characters properly, make sure that you open your CSV file with the UTF8 encoding. We tried with cyrillic, japanese, arabic characters and it works fine for us.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzE1NC1jc3YtZXhwb3J0LWN5cmlsbGljLWVuY29kaW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[alexintras](/forum/user/4141-alexintras "View alexintras's Profile")**
- [![alexintras's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4141.jpg)](/forum/user/4141-alexintras "View alexintras's Profile") Topic Author
- [ Offline](/forum/user/4141-alexintras)

Less More

- Posts: 32
- Thank you received: 0
-
-
-
-

15 years 1 month ago [\#27166](#27166) by [alexintras](/forum/user/4141-alexintras "View alexintras's Profile")  Replied by *[alexintras](/forum/user/4141-alexintras "View alexintras's Profile")* on topic *[Re: CSV export Cyrillic encoding error](/forum/3-bug-report/27154-csv-export-cyrillic-encoding-error#27166 "Then exporting Order to CSV, all data of product write en Cyrillic have broken encoding. Can you check this problem?")*

You are right!
With notepad all is good, but when open with MS Excel (2007) encoding is broken...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzE1NC1jc3YtZXhwb3J0LWN5cmlsbGljLWVuY29kaW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

15 years 1 month ago [\#27172](#27172) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: CSV export Cyrillic encoding error](/forum/3-bug-report/27154-csv-export-cyrillic-encoding-error#27172 "Then exporting Order to CSV, all data of product write en Cyrillic have broken encoding. Can you check this problem?")*

There should be an option to select the encoding when you open the file in Excel (not via the explorer but via the open menu of Excel).

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzE1NC1jc3YtZXhwb3J0LWN5cmlsbGljLWVuY29kaW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[alexintras](/forum/user/4141-alexintras "View alexintras's Profile")**
- [![alexintras's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4141.jpg)](/forum/user/4141-alexintras "View alexintras's Profile") Topic Author
- [ Offline](/forum/user/4141-alexintras)

Less More

- Posts: 32
- Thank you received: 0
-
-
-
-

15 years 1 month ago [\#27243](#27243) by [alexintras](/forum/user/4141-alexintras "View alexintras's Profile")  Replied by *[alexintras](/forum/user/4141-alexintras "View alexintras's Profile")* on topic *[Re: CSV export Cyrillic encoding error](/forum/3-bug-report/27154-csv-export-cyrillic-encoding-error#27243 "Then exporting Order to CSV, all data of product write en Cyrillic have broken encoding. Can you check this problem?")*

Yes, with import working, but this process is required many "steps"...
So, conclusion: this is MS Excel problem, not the component.

Thank you!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yNzE1NC1jc3YtZXhwb3J0LWN5cmlsbGljLWVuY29kaW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.059 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
