[Skip to main content](#vessel-content) # CSV Export Problem With Microsoft Excel ## - **[ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile")** - [![ansaryibrahim's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile") Topic Author - [ Offline](/forum/user/6631-ansaryibrahim) Less More - Posts: 5 - Thank you received: 0 - - 14 years 7 months ago [\#45228](#45228) by [ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile") *[CSV Export Problem With Microsoft Excel](/forum/3-bug-report/45228-csv-export-problem-with-microsoft-excel#45228 "Hi, I am trying to export hikashop "Orders" sheet to excel so i can manage them it. However - The problem is everything is being displayed in 1 column. I have gone through the forum and even tried to edit \administrator\components\com_hikashop\views\dashboard\views.html.php line (70) .. But the problem persists. I guess the column seperation is ";" .. but its not working properly. My Microsoft Excel is the latest version. the header is of type : 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_discount_code";"order_created";"order_ip";"order_currency_id";"order_shipping_price";"order_discount_price";"order_shipping_id";"order_shipping_method";"order_payment_id";"order_payment_method";"order_full_price";"order_modified";"order_partner_id";"order_partner_price";"order_partner_paid";"order_type";"order_partner_currency_id";"order_shipping_tax";"order_discount_tax";"order_number";"order_tax_info";"id";"name";"username";"email";"password";"usertype";"block";"sendEmail";"registerDate";"lastvisitDate";"activation";"params";"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_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_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_options";"item1_order_product_option_parent_id";"item1_order_product_tax_info";"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_options";"item2_order_product_option_parent_id";"item2_order_product_tax_info" Awaiting your reply ! Thank you..")* was created by *[ansaryibrahim](/forum/user/6631-ansaryibrahim "View ansaryibrahim's Profile")* Hi, I am trying to export hikashop "Orders" sheet to excel so i can manage them it. However - The problem is everything is being displayed in 1 column. I have gone through the forum and even tried to edit \administrator\components\com_hikashop\views\dashboard\views.html.php line (70) .. But the problem persists. I guess the column seperation is ";" .. but its not working properly. My Microsoft Excel is the latest version. the header is of type : 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_discount_code";"order_created";"order_ip";"order_currency_id";"order_shipping_price";"order_discount_price";"order_shipping_id";"order_shipping_method";"order_payment_id";"order_payment_method";"order_full_price";"order_modified";"order_partner_id";"order_partner_price";"order_partner_paid";"order_type";"order_partner_currency_id";"order_shipping_tax";"order_discount_tax";"order_number";"order_tax_info";"id";"name";"username";"email";"password";"usertype";"block";"sendEmail";"registerDate";"lastvisitDate";"activation";"params";"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_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_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_options";"item1_order_product_option_parent_id";"item1_order_product_tax_info";"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_options";"item2_order_product_option_parent_id";"item2_order_product_tax_info" Awaiting your reply ! Thank you.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NTIyOC1jc3YtZXhwb3J0LXByb2JsZW0td2l0aC1taWNyb3NvZnQtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Goldingarts](/forum/user/6413-goldingarts "View Goldingarts's Profile")** - [![Goldingarts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6413-goldingarts "View Goldingarts's Profile") - [ Offline](/forum/user/6413-goldingarts) Less More - Posts: 23 - Thank you received: 0 - - 13 years 11 months ago [\#79371](#79371) by [Goldingarts](/forum/user/6413-goldingarts "View Goldingarts's Profile") Replied by *[Goldingarts](/forum/user/6413-goldingarts "View Goldingarts's Profile")* on topic *[CSV Export Problem With Microsoft Excel](/forum/3-bug-report/45228-csv-export-problem-with-microsoft-excel#79371 "Hi, I am trying to export hikashop "Orders" sheet to excel so i can manage them it. However - The problem is everything is being displayed in 1 column. I have gone through the forum and even tried to edit \administrator\components\com_hikashop\views\dashboard\views.html.php line (70) .. But the problem persists. I guess the column seperation is ";" .. but its not working properly. My Microsoft Excel is the latest version. the header is of type : 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_discount_code";"order_created";"order_ip";"order_currency_id";"order_shipping_price";"order_discount_price";"order_shipping_id";"order_shipping_method";"order_payment_id";"order_payment_method";"order_full_price";"order_modified";"order_partner_id";"order_partner_price";"order_partner_paid";"order_type";"order_partner_currency_id";"order_shipping_tax";"order_discount_tax";"order_number";"order_tax_info";"id";"name";"username";"email";"password";"usertype";"block";"sendEmail";"registerDate";"lastvisitDate";"activation";"params";"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_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_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_options";"item1_order_product_option_parent_id";"item1_order_product_tax_info";"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_options";"item2_order_product_option_parent_id";"item2_order_product_tax_info" Awaiting your reply ! Thank you..")* Open the file in notebook and 'replace all' the ; characters with , The file is not formatted properly. Save it and you can open in excel as a CSV file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NTIyOC1jc3YtZXhwb3J0LXByb2JsZW0td2l0aC1taWNyb3NvZnQtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Goldingarts](/forum/user/6413-goldingarts "View Goldingarts's Profile")** - [![Goldingarts's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6413-goldingarts "View Goldingarts's Profile") - [ Offline](/forum/user/6413-goldingarts) Less More - Posts: 23 - Thank you received: 0 - - 13 years 11 months ago [\#79525](#79525) by [Goldingarts](/forum/user/6413-goldingarts "View Goldingarts's Profile") Replied by *[Goldingarts](/forum/user/6413-goldingarts "View Goldingarts's Profile")* on topic *[CSV Export Problem With Microsoft Excel](/forum/3-bug-report/45228-csv-export-problem-with-microsoft-excel#79525 "Hi, I am trying to export hikashop "Orders" sheet to excel so i can manage them it. However - The problem is everything is being displayed in 1 column. I have gone through the forum and even tried to edit \administrator\components\com_hikashop\views\dashboard\views.html.php line (70) .. But the problem persists. I guess the column seperation is ";" .. but its not working properly. My Microsoft Excel is the latest version. the header is of type : 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_discount_code";"order_created";"order_ip";"order_currency_id";"order_shipping_price";"order_discount_price";"order_shipping_id";"order_shipping_method";"order_payment_id";"order_payment_method";"order_full_price";"order_modified";"order_partner_id";"order_partner_price";"order_partner_paid";"order_type";"order_partner_currency_id";"order_shipping_tax";"order_discount_tax";"order_number";"order_tax_info";"id";"name";"username";"email";"password";"usertype";"block";"sendEmail";"registerDate";"lastvisitDate";"activation";"params";"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_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_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_options";"item1_order_product_option_parent_id";"item1_order_product_tax_info";"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_options";"item2_order_product_option_parent_id";"item2_order_product_tax_info" Awaiting your reply ! Thank you..")* [ www.hikashop.com/en/forum/4-how-to/75661...-csv-file.html#75984](http://www.hikashop.com/en/forum/4-how-to/75661-change-layout-of-the-contents-in-exported-csv-file.html#75984) This solves the issue! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NTIyOC1jc3YtZXhwb3J0LXByb2JsZW0td2l0aC1taWNyb3NvZnQtZXhjZWw/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: 4077 - - [](http://obsi.dev) - 13 years 11 months ago [\#79527](#79527) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[CSV Export Problem With Microsoft Excel](/forum/3-bug-report/45228-csv-export-problem-with-microsoft-excel#79527 "Hi, I am trying to export hikashop "Orders" sheet to excel so i can manage them it. However - The problem is everything is being displayed in 1 column. I have gone through the forum and even tried to edit \administrator\components\com_hikashop\views\dashboard\views.html.php line (70) .. But the problem persists. I guess the column seperation is ";" .. but its not working properly. My Microsoft Excel is the latest version. the header is of type : 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_discount_code";"order_created";"order_ip";"order_currency_id";"order_shipping_price";"order_discount_price";"order_shipping_id";"order_shipping_method";"order_payment_id";"order_payment_method";"order_full_price";"order_modified";"order_partner_id";"order_partner_price";"order_partner_paid";"order_type";"order_partner_currency_id";"order_shipping_tax";"order_discount_tax";"order_number";"order_tax_info";"id";"name";"username";"email";"password";"usertype";"block";"sendEmail";"registerDate";"lastvisitDate";"activation";"params";"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_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_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_options";"item1_order_product_option_parent_id";"item1_order_product_tax_info";"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_options";"item2_order_product_option_parent_id";"item2_order_product_tax_info" Awaiting your reply ! Thank you..")* Hi, Yes, the problem does not came from the separator, it's just that the software which open the file as to use the right separator. When opening an CSV, most of software propose to select theses options. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80NTIyOC1jc3YtZXhwb3J0LXByb2JsZW0td2l0aC1taWNyb3NvZnQtZXhjZWw/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.095 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)