Line break in Product description in .csv

  • When I export a .csv from woocommerce and I open it in Excel, it has put a \n a line break and a br en p behind it or in front of every sentence in my product description.
    When I click on: retrieve data from text, in excel and select the same .csv, then
    I select : parted and comma (see https://ibb.co/y0xfNMB) dan Excel puts every sentence in a new cel/row.
    So it messes up the columns.
    To download the .csv:https://easyupload.io/ndlz6h

    How can I prevent this from happening?

    • This topic was modified 4 years, 10 months ago by SLV.
Viewing 4 replies - 1 through 4 (of 4 total)

  • I have the same issue unfortunately. Any solution?

    Thread Starter SLV

    (@dwnl)

    Nope, I asked my theme authors just yet, maybe they can help…

    Thread Starter SLV

    (@dwnl)

    bumb

    Thread Starter SLV

    (@dwnl)

    Solved!
    I use Microsoft Office Professional plus 2019.
    I now use the free OpenOffice Calc: Openoffice.
    This program put’s the text in 1 cell, including the \n etc.

    • This reply was modified 4 years, 9 months ago by SLV.
    • This reply was modified 4 years, 9 months ago by SLV.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Line break in Product description in .csv’ is closed to new replies.