[Skip to main content](#vessel-content) # Unexpected end of line \[CF\]\[LR\] in exported CSV ## - **[fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile")** - [![fg80hun's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8461-fg80hun "View fg80hun's Profile") Topic Author - [ Offline](/forum/user/8461-fg80hun) Less More - Posts: 38 - Thank you received: 2 - - 14 years 1 month ago [\#67861](#67861) by [fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile") *[Unexpected end of line \[CF\]\[LR\] in exported CSV](/forum/3-bug-report/67861-unexpected-end-of-line-cf-lr-in-exported-csv#67861 "Hi all, I have found a strange thing when I tried to open up the exported product.csv in notepad++ with displaying the special characters CF LR also. Example: where "23" is the first coloumn: product_id. For some reasons, CR LF exist in the line and breaks the folowing coloumns of the product to the next line, which is not correct. I'm also using an Open source CSV editor called CSVed where I noticed the coloumns shifting, and makes impossible to deal with the exported data at all. Thanks in advance.")* was created by *[fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile")* Hi all, I have found a strange thing when I tried to open up the exported **product.csv** in notepad++ with displaying the special characters CF LR also. Example: Code: "23";"0";"Product Title";"<p> </p> CR LF where "23" is the first coloumn: product_id. For some reasons, **CR LF** exist in the line and breaks the folowing coloumns of the product to the next line, which is not correct. I'm also using an Open source CSV editor called **CSVed** where I noticed the coloumns shifting, and makes impossible to deal with the exported data at all. Thanks in advance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82Nzg2MS11bmV4cGVjdGVkLWVuZC1vZi1saW5lLWNmLWxyLWluLWV4cG9ydGVkLWNzdj90bXBsPW1hcmtkb3du) 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: 86555 - Thank you received: 14304 - - 14 years 1 month ago [\#67862](#67862) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Unexpected end of line \[CF\]\[LR\] in exported CSV](/forum/3-bug-report/67861-unexpected-end-of-line-cf-lr-in-exported-csv#67862 "Hi all, I have found a strange thing when I tried to open up the exported product.csv in notepad++ with displaying the special characters CF LR also. Example: where "23" is the first coloumn: product_id. For some reasons, CR LF exist in the line and breaks the folowing coloumns of the product to the next line, which is not correct. I'm also using an Open source CSV editor called CSVed where I noticed the coloumns shifting, and makes impossible to deal with the exported data at all. Thanks in advance.")* Hi, The CRLF end of line is the standard one on windows: [ en.wikipedia.org/wiki/Newline](http://en.wikipedia.org/wiki/Newline) Also, Macs understands CR and linux understands LF Having both CR LF allows you to have line returns on all major OSes. It's normal that you see them at the end of each line in notepad++ when you display the return carriages (there is an option to not display them). I don't know CSVed but both OpenOffice (LibreOffice) and MS Office are able to open the CSVs of HikaShop just fine. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82Nzg2MS11bmV4cGVjdGVkLWVuZC1vZi1saW5lLWNmLWxyLWluLWV4cG9ydGVkLWNzdj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile")** - [![fg80hun's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8461-fg80hun "View fg80hun's Profile") Topic Author - [ Offline](/forum/user/8461-fg80hun) Less More - Posts: 38 - Thank you received: 2 - - 14 years 1 month ago [\#67863](#67863) by [fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile") Replied by *[fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile")* on topic *[Re: Unexpected end of line \[CF\]\[LR\] in exported CSV](/forum/3-bug-report/67861-unexpected-end-of-line-cf-lr-in-exported-csv#67863 "Hi all, I have found a strange thing when I tried to open up the exported product.csv in notepad++ with displaying the special characters CF LR also. Example: where "23" is the first coloumn: product_id. For some reasons, CR LF exist in the line and breaks the folowing coloumns of the product to the next line, which is not correct. I'm also using an Open source CSV editor called CSVed where I noticed the coloumns shifting, and makes impossible to deal with the exported data at all. Thanks in advance.")* Hi Nicolas, Yes, CF LR needed on win, at the end of line closing a product row. I attach an image where you can see that it breaks a line. In most cases, they are at the right place -> at the end of line. But sometimes breaking the lines to two or more like on the image. - [ ![shot_75.jpg](/forum/attachment/6020) ](/forum/attachment/6020 "shot_75.jpg") [ ](/forum/attachment/6020?download=1 "shot_75.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82Nzg2MS11bmV4cGVjdGVkLWVuZC1vZi1saW5lLWNmLWxyLWluLWV4cG9ydGVkLWNzdj90bXBsPW1hcmtkb3du) 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: 86555 - Thank you received: 14304 - - 14 years 1 month ago [\#67869](#67869) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Unexpected end of line \[CF\]\[LR\] in exported CSV](/forum/3-bug-report/67861-unexpected-end-of-line-cf-lr-in-exported-csv#67869 "Hi all, I have found a strange thing when I tried to open up the exported product.csv in notepad++ with displaying the special characters CF LR also. Example: where "23" is the first coloumn: product_id. For some reasons, CR LF exist in the line and breaks the folowing coloumns of the product to the next line, which is not correct. I'm also using an Open source CSV editor called CSVed where I noticed the coloumns shifting, and makes impossible to deal with the exported data at all. Thanks in advance.")* That's your product description. It's on several lines because you have it on several lines. That's not a problem. most CSV software like OpenOffice and Microsoft Office support multiple lines. I can't do anything for you if your software does not support it besides telling you to use another software or not use several lines for your descriptions. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82Nzg2MS11bmV4cGVjdGVkLWVuZC1vZi1saW5lLWNmLWxyLWluLWV4cG9ydGVkLWNzdj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile")** - [![fg80hun's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8461-fg80hun "View fg80hun's Profile") Topic Author - [ Offline](/forum/user/8461-fg80hun) Less More - Posts: 38 - Thank you received: 2 - - 14 years 1 month ago [\#67952](#67952) by [fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile") Replied by *[fg80hun](/forum/user/8461-fg80hun "View fg80hun's Profile")* on topic *[Re: Unexpected end of line \[CF\]\[LR\] in exported CSV](/forum/3-bug-report/67861-unexpected-end-of-line-cf-lr-in-exported-csv#67952 "Hi all, I have found a strange thing when I tried to open up the exported product.csv in notepad++ with displaying the special characters CF LR also. Example: where "23" is the first coloumn: product_id. For some reasons, CR LF exist in the line and breaks the folowing coloumns of the product to the next line, which is not correct. I'm also using an Open source CSV editor called CSVed where I noticed the coloumns shifting, and makes impossible to deal with the exported data at all. Thanks in advance.")* Right, Finally I will switch back to Excel. Regards FG Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82Nzg2MS11bmV4cGVjdGVkLWVuZC1vZi1saW5lLWNmLWxyLWluLWV4cG9ydGVkLWNzdj90bXBsPW1hcmtkb3du) 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)