[Skip to main content](#vessel-content) # Excel not recognizing the Export CSV file ## - **[ian.plumb](/forum/user/6811-ian-plumb "View ian.plumb's Profile")** - [![ian.plumb's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-11-17.png)](/forum/user/6811-ian-plumb "View ian.plumb's Profile") Topic Author - [ Offline](/forum/user/6811-ian-plumb) Less More - Posts: 27 - Thank you received: 2 - - [](http://griffingrove.com.au) - 12 years 8 months ago [\#144911](#144911) by [ian.plumb](/forum/user/6811-ian-plumb "View ian.plumb's Profile") *[Excel not recognizing the Export CSV file](/forum/37-import-export-csv-xls/866041-excel-not-recognizing-the-export-csv-file#144911 "-- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Looks like something has gone badly astray. Is there a trick to doing the export?")* was created by *[ian.plumb](/forum/user/6811-ian-plumb "View ian.plumb's Profile")* -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Code: "product_id;""product_parent_id"";""product_name"";""product_description"";""product_quantity"";""product_code"";""product_published"";""product_hit"";""product_created"";""product_sale_start"";""product_sale_end"";""product_delay_id"";""product_tax_id"";""product_type"";""product_vendor_id"";""product_manufacturer_id"";""product_url"";""product_weight"";""product_keywords"";""product_weight_unit"";""product_modified"";""product_meta_description"";""product_dimension_unit"";""product_width"";""product_length"";""product_height"";""product_max_per_order"";""product_access"";""product_group_after_purchase"";""product_min_per_order"";""product_contact"";""product_last_seen_date"";""product_sales"";""product_waitlist"";""product_layout"";""product_average_score"";""product_total_vote"";""product_page_title"";""product_alias"";""product_price_percentage"";""product_canonical"";""product_msrp"";""product_display_quantity_field"";""categories_ordering"";""parent_category"";""categories_image"";""categories"";""price_value"";""price_currency_id"";""price_min_quantity"";""price_access"";""files"";""images"";""related"";""options"";""1 Inch Floor Tiles"";""1.5 Inch Floor Tiles"";""Wall Blocks"";""Roof Tiles""",,,,,,,,,,, Code: "294;0;""Citadel Foundation Paint"";""<p>Citadel Foundation Paint. List required colours in the box.</p>"";50;""Citadel_Foundation_Paint"";1;257;1361659791;0;0;0;11;""main"";0;0;"""";0.050;"""";""kg"";1361659791;"""";""m"";0.000;0.000;0.000;0;""all"";"""";0;0;1392817297;0;0;"""";0;0;"""";"""";0.0000000;"""";0.0000000;0;0;"""";"""";""Citadel"";3.53600;""USD"";0;""all"";"""";""paints/citadelfoundationpaint.jpg"";"""";"""";"""";"""";"""";""""",,,,,,,,,,, Looks like something has gone badly astray. Is there a trick to doing the export? --- Regards, Ian P. Griffin Grove Gaming [ www.griffingrove.com.au](http://www.griffingrove.com.au) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYwNDEtZXhjZWwtbm90LXJlY29nbml6aW5nLXRoZS1leHBvcnQtY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 8 months ago [\#144928](#144928) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Excel not recognizing the Export CSV file](/forum/37-import-export-csv-xls/866041-excel-not-recognizing-the-export-csv-file#144928 "-- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Looks like something has gone badly astray. Is there a trick to doing the export?")* Hi, I think that the problem is probably coming from your excel which modify the structure of your CSV file, can you download the last hikashop version (2.3.0) through our website, install it and test it again ? The following user(s) said Thank You: [ian.plumb](/forum/user/6811-ian-plumb "View ian.plumb's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYwNDEtZXhjZWwtbm90LXJlY29nbml6aW5nLXRoZS1leHBvcnQtY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ian.plumb](/forum/user/6811-ian-plumb "View ian.plumb's Profile")** - [![ian.plumb's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-11-17.png)](/forum/user/6811-ian-plumb "View ian.plumb's Profile") Topic Author - [ Offline](/forum/user/6811-ian-plumb) Less More - Posts: 27 - Thank you received: 2 - - [](http://griffingrove.com.au) - 12 years 8 months ago [\#145104](#145104) by [ian.plumb](/forum/user/6811-ian-plumb "View ian.plumb's Profile") Replied by *[ian.plumb](/forum/user/6811-ian-plumb "View ian.plumb's Profile")* on topic *[Excel not recognizing the Export CSV file](/forum/37-import-export-csv-xls/866041-excel-not-recognizing-the-export-csv-file#145104 "-- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Looks like something has gone badly astray. Is there a trick to doing the export?")* Hi, Rather than installing the newer software I simply saved the export file rather than sending it directly to Excel. Opened the file in a text editor and it looks fine to me. --- Regards, Ian P. Griffin Grove Gaming [ www.griffingrove.com.au](http://www.griffingrove.com.au) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYwNDEtZXhjZWwtbm90LXJlY29nbml6aW5nLXRoZS1leHBvcnQtY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CPSD](/forum/user/32107-cpsd "View CPSD's Profile")** - [![CPSD's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32107.png)](/forum/user/32107-cpsd "View CPSD's Profile") - [ Offline](/forum/user/32107-cpsd) Less More - Posts: 2 - Thank you received: 0 - - 12 years 6 months ago [\#151442](#151442) by [CPSD](/forum/user/32107-cpsd "View CPSD's Profile") Replied by *[CPSD](/forum/user/32107-cpsd "View CPSD's Profile")* on topic *[Excel not recognizing the Export CSV file](/forum/37-import-export-csv-xls/866041-excel-not-recognizing-the-export-csv-file#151442 "-- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Looks like something has gone badly astray. Is there a trick to doing the export?")* I have the same issue when opening an exported file either directly in Excel or saved first. Everything gets dumped into column A so the data can not be used. HikaShop 2.3.0 | Joomla 3.2.3 A1 contents Code: "user_id";"user_cms_id";"user_email";"user_partner_email";"user_params";"user_partner_id";"user_partner_price";"user_partner_paid";"user_created_ip";"user_unpaid_amount";"user_partner_currency_id";"user_created";"user_currency_id";"user_partner_activated";"order_id";"order_billing_address_id";"order_shipping_address_id";"order_user_id";"order_status";"order_type";"order_number";"order_created";"order_modified";"order_invoice_id";"order_invoice_number";"order_invoice_created";"order_currency_id";"order_full_price";"order_tax_info";"order_discount_code";"order_discount_price";"order_discount_tax";"order_payment_id";"order_payment_method";"order_payment_price";"order_payment_params";"order_shipping_id";"order_shipping_method";"order_shipping_price";"order_shipping_tax";"order_shipping_params";"order_partner_id";"order_partner_price";"order_partner_paid";"order_partner_currency_id";"order_ip";"id";"name";"username";"email";"password";"block";"sendEmail";"registerDate";"lastvisitDate";"activation";"params";"lastResetTime";"resetCount";"otpKey";"otep";"shipping_address_id";"shipping_address_user_id";"shipping_address_title";"shipping_address_firstname";"shipping_address_middle_name";"shipping_address_lastname";"shipping_address_company";"shipping_address_street";"shipping_address_street2";"shipping_address_post_code";"shipping_address_city";"shipping_address_telephone";"shipping_address_telephone2";"shipping_address_fax";"shipping_address_state";"shipping_address_country";"shipping_address_published";"shipping_address_vat";"shipping_address_default";"billing_address_id";"billing_address_user_id";"billing_address_title";"billing_address_firstname";"billing_address_middle_name";"billing_address_lastname";"billing_address_company";"billing_address_street";"billing_address_street2";"billing_address_post_code";"billing_address_city";"billing_address_telephone";"billing_address_telephone2";"billing_address_fax";"billing_address_state";"billing_address_country";"billing_address_published";"billing_address_vat";"billing_address_default";"order_full_tax";"item1_order_product_id";"item1_order_id";"item1_product_id";"item1_order_product_quantity";"item1_order_product_name";"item1_order_product_code";"item1_order_product_price";"item1_order_product_tax";"item1_order_product_tax_info";"item1_order_product_options";"item1_order_product_option_parent_id";"item1_order_product_wishlist_id";"item1_order_product_shipping_id";"item1_order_product_shipping_method";"item1_order_product_shipping_price";"item1_order_product_shipping_tax";"item1_order_product_shipping_params";"item2_order_product_id";"item2_order_id";"item2_product_id";"item2_order_product_quantity";"item2_order_product_name";"item2_order_product_code";"item2_order_product_price";"item2_order_product_tax";"item2_order_product_tax_info";"item2_order_product_options";"item2_order_product_option_parent_id";"item2_order_product_wishlist_id";"item2_order_product_shipping_id";"item2_order_product_shipping_method";"item2_order_product_shipping_price";"item2_order_product_shipping_tax";"item2_order_product_shipping_params" Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYwNDEtZXhjZWwtbm90LXJlY29nbml6aW5nLXRoZS1leHBvcnQtY3N2LWZpbGU/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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 6 months ago [\#151520](#151520) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Excel not recognizing the Export CSV file](/forum/37-import-export-csv-xls/866041-excel-not-recognizing-the-export-csv-file#151520 "-- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Looks like something has gone badly astray. Is there a trick to doing the export?")* Hi, I don't see problem with this content. The quotes looks good and the cell separator is the semicolon ( ; ) but not the comma ( , ). HikaShop have a detection algorithm which allow it to detect the cell separator, so it should work as long as the all file use the same cell separator for each lines. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYwNDEtZXhjZWwtbm90LXJlY29nbml6aW5nLXRoZS1leHBvcnQtY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Baktrak](/forum/user/32124-baktrak "View Baktrak's Profile")** - [![Baktrak's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32124-baktrak "View Baktrak's Profile") - [ Offline](/forum/user/32124-baktrak) Less More - Posts: 1 - Thank you received: 2 - - 12 years 6 months ago [\#151537](#151537) by [Baktrak](/forum/user/32124-baktrak "View Baktrak's Profile") Replied by *[Baktrak](/forum/user/32124-baktrak "View Baktrak's Profile")* on topic *[Excel not recognizing the Export CSV file](/forum/37-import-export-csv-xls/866041-excel-not-recognizing-the-export-csv-file#151537 "-- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Looks like something has gone badly astray. Is there a trick to doing the export?")* I have the same problem. The simple answer is that a semicolon is not a comma. In most EN configurations, Excel expects a CSV to be comma-separated. In Windows, you can change that in Control Panel > Region and Language > Formats > Additional settings > List separator. Alternative 1: Add "sep=;" (without quotes) as the first line of the CSV file. Alternative 2: Use excel's text file import wizard and specify the separator as a semicolon. Alternative 3: Replace all the separator semicolons with commas. The following user(s) said Thank You: [Xavier](/forum/user/4105-xavier "View Xavier's Profile"), [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYwNDEtZXhjZWwtbm90LXJlY29nbml6aW5nLXRoZS1leHBvcnQtY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[CPSD](/forum/user/32107-cpsd "View CPSD's Profile")** - [![CPSD's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32107.png)](/forum/user/32107-cpsd "View CPSD's Profile") - [ Offline](/forum/user/32107-cpsd) Less More - Posts: 2 - Thank you received: 0 - - 12 years 6 months ago [\#151755](#151755) by [CPSD](/forum/user/32107-cpsd "View CPSD's Profile") Replied by *[CPSD](/forum/user/32107-cpsd "View CPSD's Profile")* on topic *[Excel not recognizing the Export CSV file](/forum/37-import-export-csv-xls/866041-excel-not-recognizing-the-export-csv-file#151755 "-- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 My website works fine, people can buy stuff through the store without issue. However when I exported my prodcuts to CSV and opened it in Excel it displayed each product's details in the first cell. I renamed the file extension to txt, opened the file in Excel, set the delimiter to semicolon. So I opened the file in a text editor... Looks like something has gone badly astray. Is there a trick to doing the export?")* DOH! :blush: Thanks for the replies. Once I realised my mistake was able to reorganize in Excel 2010 via Data Ribbon > Text to Columns. This opens a wizard that allows you to set the Delimiter using check-boxes. And yes Baktrak, my EN install was expecting commas. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYwNDEtZXhjZWwtbm90LXJlY29nbml6aW5nLXRoZS1leHBvcnQtY3N2LWZpbGU/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.279 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)