[Skip to main content](#vessel-content) # Export products - description ends in Product ID ## - **[dlarge](/forum/user/7977-dlarge "View dlarge's Profile")** - [![dlarge's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7977-dlarge "View dlarge's Profile") Topic Author - [ Offline](/forum/user/7977-dlarge) Less More - Posts: 55 - Thank you received: 2 - - 13 years 11 months ago [\#77916](#77916) by [dlarge](/forum/user/7977-dlarge "View dlarge's Profile") *[Export products - description ends in Product ID](/forum/2-general-talk-about-hikashop/76010-export-products-description-ends-in-product-id#77916 "I have tried to export my products and view them in excel, I open up excel, import the csv using ; as the delimiter but the first 1000 lines contain the product description in the product id column,...")* was created by *[dlarge](/forum/user/7977-dlarge "View dlarge's Profile")* I have tried to export my products and view them in excel, I open up excel, import the csv using ; as the delimiter but the first 1000 lines contain the product description in the product id column, then after all the descriptions are exhausted, the rest of the csv file looks fine and everything is where it should be. Maybe im importing into excel incorrectly? Any help greatly appreciated. Thanks Dave - [ ![exported_products_screenshot.png](/forum/attachment/7092) ](/forum/attachment/7092 "...screenshot.png") [ ](/forum/attachment/7092?download=1 "...screenshot.png") - [ ![bottom_of_exported_products.png](/forum/attachment/7093) ](/forum/attachment/7093 "...d_products.png") [ ](/forum/attachment/7093?download=1 "...d_products.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MDEwLWV4cG9ydC1wcm9kdWN0cy1kZXNjcmlwdGlvbi1lbmRzLWluLXByb2R1Y3QtaWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 11 months ago [\#77925](#77925) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Export products - description ends in Product ID](/forum/2-general-talk-about-hikashop/76010-export-products-description-ends-in-product-id#77925 "I have tried to export my products and view them in excel, I open up excel, import the csv using ; as the delimiter but the first 1000 lines contain the product description in the product id column,...")* Hi, Yes I think that the problem come from excel, try to open the csv file with another program. The following user(s) said Thank You: [dlarge](/forum/user/7977-dlarge "View dlarge's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MDEwLWV4cG9ydC1wcm9kdWN0cy1kZXNjcmlwdGlvbi1lbmRzLWluLXByb2R1Y3QtaWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dlarge](/forum/user/7977-dlarge "View dlarge's Profile")** - [![dlarge's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7977-dlarge "View dlarge's Profile") Topic Author - [ Offline](/forum/user/7977-dlarge) Less More - Posts: 55 - Thank you received: 2 - - 13 years 11 months ago [\#78242](#78242) by [dlarge](/forum/user/7977-dlarge "View dlarge's Profile") Replied by *[dlarge](/forum/user/7977-dlarge "View dlarge's Profile")* on topic *[Export products - description ends in Product ID](/forum/2-general-talk-about-hikashop/76010-export-products-description-ends-in-product-id#78242 "I have tried to export my products and view them in excel, I open up excel, import the csv using ; as the delimiter but the first 1000 lines contain the product description in the product id column,...")* Thanks - it appeared to work ok in google docs spreadsheet. Can anyone recommend a good csv file viewer so I can sort columns and edit properly? Thanks Dave Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MDEwLWV4cG9ydC1wcm9kdWN0cy1kZXNjcmlwdGlvbi1lbmRzLWluLXByb2R1Y3QtaWQ/dG1wbD1tYXJrZG93bg==) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 13 years 11 months ago [\#78261](#78261) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Export products - description ends in Product ID](/forum/2-general-talk-about-hikashop/76010-export-products-description-ends-in-product-id#78261 "I have tried to export my products and view them in excel, I open up excel, import the csv using ; as the delimiter but the first 1000 lines contain the product description in the product id column,...")* Hi, You can use OpenOffice. It can open and create CSV files. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MDEwLWV4cG9ydC1wcm9kdWN0cy1kZXNjcmlwdGlvbi1lbmRzLWluLXByb2R1Y3QtaWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dlarge](/forum/user/7977-dlarge "View dlarge's Profile")** - [![dlarge's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7977-dlarge "View dlarge's Profile") Topic Author - [ Offline](/forum/user/7977-dlarge) Less More - Posts: 55 - Thank you received: 2 - - 13 years 11 months ago [\#78613](#78613) by [dlarge](/forum/user/7977-dlarge "View dlarge's Profile") Replied by *[dlarge](/forum/user/7977-dlarge "View dlarge's Profile")* on topic *[Export products - description ends in Product ID](/forum/2-general-talk-about-hikashop/76010-export-products-description-ends-in-product-id#78613 "I have tried to export my products and view them in excel, I open up excel, import the csv using ; as the delimiter but the first 1000 lines contain the product description in the product id column,...")* Thanks - Completely forgot about open office! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MDEwLWV4cG9ydC1wcm9kdWN0cy1kZXNjcmlwdGlvbi1lbmRzLWluLXByb2R1Y3QtaWQ/dG1wbD1tYXJrZG93bg==) 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.061 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)