[Skip to main content](#vessel-content) # Export Feature ## - **[bigchumpy](/forum/user/7427-bigchumpy "View bigchumpy's Profile")** - [![bigchumpy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7427-bigchumpy "View bigchumpy's Profile") Topic Author - [ Offline](/forum/user/7427-bigchumpy) Less More - Posts: 31 - Thank you received: 0 - - 13 years 8 months ago - 13 years 8 months ago [\#93711](#93711) by [bigchumpy](/forum/user/7427-bigchumpy "View bigchumpy's Profile") *[Export Feature](/forum/2-general-talk-about-hikashop/79121-export-feature#93711 "HI All, I'm sure I'm a huge Dunce, but I can't figure out how to make sense of the export products feature. It seems to be a jumbled mess when importing into excel.. It seems I have product data going across columns, but then stacked in rows. as well... like going in both directions. As far as I can see, the export feature is useless to the average user, but of course, I'm sure I'm just not that bright today. What is it I'm missing? How is this made useable. I would think all the product fields would be in columns as they seem to be, then the value data in a corresponding cell. Confused. Thanks for any help. See the attached image. The description spans all columns and is inappropriately arranged. bigchumpy")* was created by *[bigchumpy](/forum/user/7427-bigchumpy "View bigchumpy's Profile")* [ ![hikaexport.jpg](/forum/attachment/9014) ](/forum/attachment/9014 "hikaexport.jpg") HI All, I'm sure I'm a huge Dunce, but I can't figure out how to make sense of the export products feature. It seems to be a jumbled mess when importing into excel.. It seems I have product data going across columns, but then stacked in rows. as well... like going in both directions. As far as I can see, the export feature is useless to the average user, but of course, I'm sure I'm just not that bright today. What is it I'm missing? How is this made useable. I would think all the product fields would be in columns as they seem to be, then the value data in a corresponding cell. Confused. Thanks for any help. See the attached image. The description spans all columns and is inappropriately arranged. bigchumpy - [ ![hikaexport.jpg](/forum/attachment/9014) ](/forum/attachment/9014 "hikaexport.jpg") [ ](/forum/attachment/9014?download=1 "hikaexport.jpg") Last edit: 13 years 8 months ago by [bigchumpy](/forum/user/7427-bigchumpy "View bigchumpy's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MTIxLWV4cG9ydC1mZWF0dXJlP3RtcGw9bWFya2Rvd24=) 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: 86359 - Thank you received: 14296 - - 13 years 8 months ago [\#93748](#93748) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Export Feature](/forum/2-general-talk-about-hikashop/79121-export-feature#93748 "HI All, I'm sure I'm a huge Dunce, but I can't figure out how to make sense of the export products feature. It seems to be a jumbled mess when importing into excel.. It seems I have product data going across columns, but then stacked in rows. as well... like going in both directions. As far as I can see, the export feature is useless to the average user, but of course, I'm sure I'm just not that bright today. What is it I'm missing? How is this made useable. I would think all the product fields would be in columns as they seem to be, then the value data in a corresponding cell. Confused. Thanks for any help. See the attached image. The description spans all columns and is inappropriately arranged. bigchumpy")* Hi, It seems that you didn't configure excel's import system to handle line returns in your columns and because of that, each line return in your product description is interpreted as new line/new row. I don't use excel on my end but it should work fine by default with openoffice calc (it's the same as excel but open source and free) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MTIxLWV4cG9ydC1mZWF0dXJlP3RtcGw9bWFya2Rvd24=) 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.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)