[Skip to main content](#vessel-content) # export xls utf8 ## - **[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")** - [![aminweb's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar38602.png)](/forum/user/38602-aminweb "View aminweb's Profile") Topic Author - [ Offline](/forum/user/38602-aminweb) - Amin Less More - Posts: 138 - Thank you received: 4 - - - 10 years 3 months ago [\#245621](#245621) by [aminweb](/forum/user/38602-aminweb "View aminweb's Profile") *[export xls utf8](/forum/37-import-export-csv-xls/885595-export-xls-utf8#245621 "hi. how I can export xls (utf8) of product? thanks")* was created by *[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")* hi. how I can export xls (utf8) of product? thanks --- Joomla Developer \| am.ebrahimzadeh\[at\]gmail.com Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODU1OTUtZXhwb3J0LXhscy11dGY4P3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 10 years 3 months ago [\#245624](#245624) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[export xls utf8](/forum/37-import-export-csv-xls/885595-export-xls-utf8#245624 "hi. how I can export xls (utf8) of product? thanks")* Hi, Go in the menu System>Mass actions. Click on the "new" button, there, in the "actions" area, select an action "export a csv file", and select the "xls" format and click on the "process" button at the top. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODU1OTUtZXhwb3J0LXhscy11dGY4P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")** - [![aminweb's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar38602.png)](/forum/user/38602-aminweb "View aminweb's Profile") Topic Author - [ Offline](/forum/user/38602-aminweb) - Amin Less More - Posts: 138 - Thank you received: 4 - - - 10 years 3 months ago [\#245636](#245636) by [aminweb](/forum/user/38602-aminweb "View aminweb's Profile") Replied by *[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")* on topic *[export xls utf8](/forum/37-import-export-csv-xls/885595-export-xls-utf8#245636 "hi. how I can export xls (utf8) of product? thanks")* hi nicolas. I do this mass action.and select xls format... but export finaly format csv!!!!!!!!! and not support utf8... attachment. --- Joomla Developer \| am.ebrahimzadeh\[at\]gmail.com Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODU1OTUtZXhwb3J0LXhscy11dGY4P3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 10 years 3 months ago [\#245641](#245641) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[export xls utf8](/forum/37-import-export-csv-xls/885595-export-xls-utf8#245641 "hi. how I can export xls (utf8) of product? thanks")* Hi, If you get a CSV, you didn't select the "XLS" setting in the mass action. Please check on that. But yes, Excel can also read CSV files so you can also use the CSV file, it's the same thing. And that CSV file IS UTF8. See for yourself when I open it: [ take.ms/w266g](http://take.ms/w266g) So the problem is with the way you open it in Excel. You probably didn't select the UTF8 charset when you imported the CSV to your Excel and thus it used another charset and messed the display. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODU1OTUtZXhwb3J0LXhscy11dGY4P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mhalvaee](/forum/user/45428-mhalvaee "View mhalvaee's Profile")** - [![mhalvaee's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45428-mhalvaee "View mhalvaee's Profile") - [ Offline](/forum/user/45428-mhalvaee) Less More - Posts: 1 - Thank you received: 0 - - 10 years 2 weeks ago [\#251997](#251997) by [mhalvaee](/forum/user/45428-mhalvaee "View mhalvaee's Profile") Replied by *[mhalvaee](/forum/user/45428-mhalvaee "View mhalvaee's Profile")* on topic *[export xls utf8](/forum/37-import-export-csv-xls/885595-export-xls-utf8#251997 "hi. how I can export xls (utf8) of product? thanks")* hi nicolas how can export csv file in seprate columns see the attachment - [ ![Capture.PNG](/forum/attachment/33870) ](/forum/attachment/33870 "Capture.PNG") [ ](/forum/attachment/33870?download=1 "Capture.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODU1OTUtZXhwb3J0LXhscy11dGY4P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 10 years 1 week ago [\#252576](#252576) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[export xls utf8](/forum/37-import-export-csv-xls/885595-export-xls-utf8#252576 "hi. how I can export xls (utf8) of product? thanks")* Hi, It is separated in columns but you need to open the CSV with the right column separator. Regarding your image, it looks like it's a " | " while in common CSV it's a coma (CSV = Comma-separated values) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODU1OTUtZXhwb3J0LXhscy11dGY4P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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.198 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)