[Skip to main content](#vessel-content) # problem with product export ## - **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")** - [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile") Topic Author - [ Offline](/forum/user/513-tanyatanya) Less More - Posts: 90 - Thank you received: 0 - - 14 years 9 months ago [\#35803](#35803) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile") *[problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35803 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* was created by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 9 months ago [\#35807](#35807) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35807 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* Hi, Could you switch to semi colon for both HikaShop and Excel and try again ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")** - [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile") Topic Author - [ Offline](/forum/user/513-tanyatanya) Less More - Posts: 90 - Thank you received: 0 - - 14 years 9 months ago [\#35872](#35872) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile") Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35872 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* ok thanks for getting back to me - i've tried that but it still won't work. i've attached a pic of what the text import wizard looks like on my end. I've also tried it on my home computer (newer version of excel on it) but it still mixes up the data. image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/text_import_wizard.jpg - [ ![text_import_wizard.jpg](/forum/attachment/2446) ](/forum/attachment/2446 "...ort_wizard.jpg") [ ](/forum/attachment/2446?download=1 "...ort_wizard.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 9 months ago [\#35875](#35875) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35875 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* Could you give the CSV so that we can check it ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")** - [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile") Topic Author - [ Offline](/forum/user/513-tanyatanya) Less More - Posts: 90 - Thank you received: 0 - - 14 years 9 months ago [\#35878](#35878) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile") Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35878 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* hi, yes i can give you the csv - just warning you though that its very large so you can't just click on it to open it. i had to import it manually using the data import options in excel (fits over more than one worksheet). its still set at semi colon for the separator. Tanya Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")** - [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile") Topic Author - [ Offline](/forum/user/513-tanyatanya) Less More - Posts: 90 - Thank you received: 0 - - 14 years 9 months ago - 14 years 9 months ago [\#35879](#35879) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile") Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35879 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* hi, yes i can give you the csv - just warning you though that its very large so you can't just click on it to open it. i had to import it manually using the data import options in excel (fits over more than one worksheet). its still set at semi colon for the separator. Tanya Last edit: 14 years 9 months ago by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")** - [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile") Topic Author - [ Offline](/forum/user/513-tanyatanya) Less More - Posts: 90 - Thank you received: 0 - - 14 years 9 months ago [\#35881](#35881) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile") Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35881 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* sorry i can't get it to attach - maybe its too large...the page just keeps loading and as you can see it didn't attach to the message. can i send it to you in an email? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 9 months ago [\#35940](#35940) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#35940 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* Sure. You can send it to nicolas at hikashop dot com. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 9 months ago [\#36063](#36063) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#36063 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* I've opened your CSV on my end with open office calc ( I don't have excel. That's a free equivalent to excel ) and it's displaying fine. So It must be excel not interpreting properly the CSV. I see that you ticked tab as a delimiter when opening the CSV. You might want to try again with that option unticked. That might help Excel. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")** - [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile") Topic Author - [ Offline](/forum/user/513-tanyatanya) Less More - Posts: 90 - Thank you received: 0 - - 14 years 9 months ago [\#36356](#36356) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile") Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#36356 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* ok I'll try that, if that doesn't work I'll try using the open office calc (I have that on my computer too). thanks, Tanya Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[PhilP](/forum/user/5076-philp "View PhilP's Profile")** - [![PhilP's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5076-philp "View PhilP's Profile") - [ Offline](/forum/user/5076-philp) Less More - Posts: 44 - Thank you received: 1 - - 14 years 7 months ago [\#45580](#45580) by [PhilP](/forum/user/5076-philp "View PhilP's Profile") Replied by *[PhilP](/forum/user/5076-philp "View PhilP's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#45580 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* I am also having problems with the export function. I am using semicolon as the CSV separator but can see on a single product export test that the field order in the file is disturbed when I read it back into Excel. The problem appears to be connected to the product description field, where I think that a character or string in the product description is causing a a new line to be started. In the attached file, if I do the following: 1. Import the csv file into Excel 2. Take all the data on the line after the field "xxTest_Product_Top" (which is the text product code) 3. Move that data so that it starts in the correct field (product_code) then the remaining data items will then be placed in the correct fields. I have attached the data file so that you can see the problem. My original objective was simply to check product names, codes, prices, tax status etc. I do not need the product description in order to do this. Is there any way to select which data items I want to appear in the exported CSV file (without using a SQL query?) so that I do not export the product description? Regards PhilP Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 7 months ago [\#45812](#45812) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#45812 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* Having several lines in a CSV field is not a problem. Could you try to open your CSV with libreoffice (openoffice) calc ? It should work better than with Excel. Excel has sometimes troubles to open CSV files properly... There is no option to only export some fields. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[PhilP](/forum/user/5076-philp "View PhilP's Profile")** - [![PhilP's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5076-philp "View PhilP's Profile") - [ Offline](/forum/user/5076-philp) Less More - Posts: 44 - Thank you received: 1 - - 14 years 7 months ago [\#45849](#45849) by [PhilP](/forum/user/5076-philp "View PhilP's Profile") Replied by *[PhilP](/forum/user/5076-philp "View PhilP's Profile")* on topic *[Re: problem with product export](/forum/3-bug-report/35803-problem-with-product-export#45849 "hello, I'm trying to export my products to excel, however they don't seem to be seperated properly. for example some of the product descriptions can be found in the product id collumn when i view them in excel. this is happening with other collums too. i've set the seperator to comma (in the configuration menu), and i've set the excel file import seperator to comma too when i import the file. is there something i'm missing...? any help would be much appreciated Tanya")* Ok Nicolas - thanks. I'll try that. PhilP Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8zNTgwMy1wcm9ibGVtLXdpdGgtcHJvZHVjdC1leHBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.141 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)