Adding a newline character within a cell CSV

Question

I would like to import product descriptions that need to be logically broken according by things like description  dimensions  finishes etc  How  can I insert a line break so that when I import the file they will show up

User · Answer

I struggled with this as well but heres the solution  If you add   before and at the end of the csv string you are trying to display  it will consolidate them into 1 cell while honoring new line    csvString          Date Generated   n     csvString     Doctor        n           n

User · Answer

On Excel for Mac 2011  the newline had to be a  r instead of an  n  So     first line rsecond line      would show up as a cell with 2 lines

User · Answer

I was concatenating the variable and adding multiple items in same row  so below code work for me     n  new line code is mandatory to add first and last of each line if you will add it on last only it will append last 1-2 character to new lines      itemCode        foreach  returnData  repairdetail   as  checkkey  gt  repairDetailData        if  checkkey  gt 0            itemCode        n  trim   repairDetailData  ItemMaster  - gt Item Code    n        else           itemCode        n  trim   repairDetailData  ItemMaster  - gt Item Code    n                           repairDetaile    array           itemCode             pass all array to here  foreach   repairDetaile as  csvData         fputcsv  csv file  csvData             fclose  csv file

User · Answer

I have the same issue  when I try to export the content of email to csv and still keep it break line when importing to excel   I export the conent as this    Line 1  amp CHAR 10  amp  Line 2   When I import it to excel google   excel understand it as string  It still not break new line   We need to trigger excel to treat it as formula by  Format -  Number   Scientific   This is not the good way but it resolve my issue

User · Answer

This question was answered well at Can you encode CR LF in into CSV files    Consider also reverse engineering multiple lines in Excel  To embed a newline in an Excel cell  press Alt Enter  Then save the file as a  csv  You ll see that the double-quotes start on one line and each new line in the file is considered an embedded newline in the cell

[excel] Adding a newline character within a cell (CSV)

Examples related to excel

Examples related to csv