[Skip to main content](#vessel-content) # Column Data not in correct Columns following .CSV export ## - **[stonedbloke](/forum/user/3215-stonedbloke "View stonedbloke's Profile")** - [![stonedbloke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3215-stonedbloke "View stonedbloke's Profile") Topic Author - [ Offline](/forum/user/3215-stonedbloke) Less More - Posts: 19 - Thank you received: 0 - - 6 years 1 month ago - 6 years 1 month ago [\#324001](#324001) by [stonedbloke](/forum/user/3215-stonedbloke "View stonedbloke's Profile") *[Column Data not in correct Columns following .CSV export](/forum/37-import-export-csv-xls/900802-column-data-not-in-correct-columns-following-csv-export#324001 "-- url of the page with the problem -- : hallamfc.co.uk -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.8.7 Hello, We are exporting our Orders to .csv and have noticed that the " appears in every cell surrounding the data. We are having to Find and Replace this with a Space to remove it. When we then Separate the data into Columns using the Semicolon the data is not sitting under the right Columns. item1_order_product_name contains City data as an example. I have shared a snip of an export showing some of this behavior. We assume we are not doing this correctly so require some assistance on exporting and separating in Excel. Able to help please? John")* was created by *[stonedbloke](/forum/user/3215-stonedbloke "View stonedbloke's Profile")* -- url of the page with the problem -- : [ hallamfc.co.uk](https://hallamfc.co.uk) -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.8.7 Hello, We are exporting our Orders to .csv and have noticed that the " appears in every cell surrounding the data. We are having to Find and Replace this with a Space to remove it. When we then Separate the data into Columns using the Semicolon the data is not sitting under the right Columns. **item1\_order\_product\_name** contains **City** data as an example. I have shared a snip of an export showing some of this behavior. We assume we are not doing this correctly so require some assistance on exporting and separating in Excel. Able to help please? John - [ ![HSSpreadsheet.PNG](/forum/attachment/50568) ](/forum/attachment/50568 "HSSpreadsheet.PNG") [ ](/forum/attachment/50568?download=1 "HSSpreadsheet.PNG") Last edit: 6 years 1 month ago by [stonedbloke](/forum/user/3215-stonedbloke "View stonedbloke's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDA4MDItY29sdW1uLWRhdGEtbm90LWluLWNvcnJlY3QtY29sdW1ucy1mb2xsb3dpbmctY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[stonedbloke](/forum/user/3215-stonedbloke "View stonedbloke's Profile")** - [![stonedbloke's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3215-stonedbloke "View stonedbloke's Profile") Topic Author - [ Offline](/forum/user/3215-stonedbloke) Less More - Posts: 19 - Thank you received: 0 - - 6 years 1 month ago [\#324004](#324004) by [stonedbloke](/forum/user/3215-stonedbloke "View stonedbloke's Profile") Replied by *[stonedbloke](/forum/user/3215-stonedbloke "View stonedbloke's Profile")* on topic *[Column Data not in correct Columns following .CSV export](/forum/37-import-export-csv-xls/900802-column-data-not-in-correct-columns-following-csv-export#324004 "-- url of the page with the problem -- : hallamfc.co.uk -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.8.7 Hello, We are exporting our Orders to .csv and have noticed that the " appears in every cell surrounding the data. We are having to Find and Replace this with a Space to remove it. When we then Separate the data into Columns using the Semicolon the data is not sitting under the right Columns. item1_order_product_name contains City data as an example. I have shared a snip of an export showing some of this behavior. We assume we are not doing this correctly so require some assistance on exporting and separating in Excel. Able to help please? John")* Following further reading I have found that going into the System Configuration and changing the CSV separator from the default Semicolon to a Comma output the data into the correct columns in Excel without having to find and replace the speech marks. Hope this helps someone else. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDA4MDItY29sdW1uLWRhdGEtbm90LWluLWNvcnJlY3QtY29sdW1ucy1mb2xsb3dpbmctY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 6 years 1 month ago [\#324008](#324008) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Column Data not in correct Columns following .CSV export](/forum/37-import-export-csv-xls/900802-column-data-not-in-correct-columns-following-csv-export#324008 "-- url of the page with the problem -- : hallamfc.co.uk -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.8.7 Hello, We are exporting our Orders to .csv and have noticed that the " appears in every cell surrounding the data. We are having to Find and Replace this with a Space to remove it. When we then Separate the data into Columns using the Semicolon the data is not sitting under the right Columns. item1_order_product_name contains City data as an example. I have shared a snip of an export showing some of this behavior. We assume we are not doing this correctly so require some assistance on exporting and separating in Excel. Able to help please? John")* Hi, For others reading this, not that you can actually not change anything in HikaShop and open the CSV file fine in Excel, but you need to do it via the import tool there so that you can choose the separator etc: [ www.copytrans.net/support/how-to-open-a-csv-file-in-excel/](https://www.copytrans.net/support/how-to-open-a-csv-file-in-excel/) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDA4MDItY29sdW1uLWRhdGEtbm90LWluLWNvcnJlY3QtY29sdW1ucy1mb2xsb3dpbmctY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) 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.044 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)