[Skip to main content](#vessel-content) # Change layout of the contents in exported CSV file ## - **[simon2012](/forum/user/6847-simon2012 "View simon2012's Profile")** - [![simon2012's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6847-simon2012 "View simon2012's Profile") Topic Author - [ Offline](/forum/user/6847-simon2012) Less More - Posts: 14 - Thank you received: 0 - - 13 years 11 months ago [\#75820](#75820) by [simon2012](/forum/user/6847-simon2012 "View simon2012's Profile") *[Change layout of the contents in exported CSV file](/forum/4-how-to/75661-change-layout-of-the-contents-in-exported-csv-file#75820 "Hi Can someone please tell me how to change the contents in the exported CSV file to a table layout? I want to create all my products in the excel file and import to Hikashop afterwards but the right now the contents are all in the same cell separated by commas. Thanks")* was created by *[simon2012](/forum/user/6847-simon2012 "View simon2012's Profile")* Hi Can someone please tell me how to change the contents in the exported CSV file to a table layout? I want to create all my products in the excel file and import to Hikashop afterwards but the right now the contents are all in the same cell separated by commas. Thanks *This attachment is hidden for guests. Please log in or register to see it.* [ ![pic.png](/forum/attachment/6862) ](/forum/attachment/6862 "pic.png") - [ ![pic.png](/forum/attachment/6862) ](/forum/attachment/6862 "pic.png") [ ](/forum/attachment/6862?download=1 "pic.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc1NjYxLWNoYW5nZS1sYXlvdXQtb2YtdGhlLWNvbnRlbnRzLWluLWV4cG9ydGVkLWNzdi1maWxlP3RtcGw9bWFya2Rvd24=) 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: 86358 - Thank you received: 14293 - - 13 years 11 months ago [\#75984](#75984) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change layout of the contents in exported CSV file](/forum/4-how-to/75661-change-layout-of-the-contents-in-exported-csv-file#75984 "Hi Can someone please tell me how to change the contents in the exported CSV file to a table layout? I want to create all my products in the excel file and import to Hikashop afterwards but the right now the contents are all in the same cell separated by commas. Thanks")* Hi, When you import your CSV in excel, you need to change the separator from , to ; so that it can display them nicely. Otherwise, you can change the separator used by HikaShop in the Files tab of the configuration. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc1NjYxLWNoYW5nZS1sYXlvdXQtb2YtdGhlLWNvbnRlbnRzLWluLWV4cG9ydGVkLWNzdi1maWxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")** - [![brentwilliams2's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile") - [ Offline](/forum/user/1200-brentwilliams2) Less More - Posts: 78 - Thank you received: 5 - - 13 years 9 months ago [\#88268](#88268) by [brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile") Replied by *[brentwilliams2](/forum/user/1200-brentwilliams2 "View brentwilliams2's Profile")* on topic *[Change layout of the contents in exported CSV file](/forum/4-how-to/75661-change-layout-of-the-contents-in-exported-csv-file#88268 "Hi Can someone please tell me how to change the contents in the exported CSV file to a table layout? I want to create all my products in the excel file and import to Hikashop afterwards but the right now the contents are all in the same cell separated by commas. Thanks")* Just as a little tip, if you still have this problem, before you open up the CSV file in excel, open it up in Notepad. Add a line at the top that says: sep=; Save that file and then open in Excel. That will then work, depending on your setup. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc1NjYxLWNoYW5nZS1sYXlvdXQtb2YtdGhlLWNvbnRlbnRzLWluLWV4cG9ydGVkLWNzdi1maWxlP3RtcGw9bWFya2Rvd24=) 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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)