CODEWITHSUNDEEP
excelcsv
user2997761
user2997761

Reputation:

Adding a newline character within a cell (CSV)

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?

Upvotes: 91

Views: 324212

Answers (7)

MustardMan
MustardMan

Reputation: 101

I converted a pandas DataFrame to a csv string using DataFrame.to_csv() and then I looked at the results. It included \r\n as the end of line character(s). I suggest inserting these into your csv string as your row separation.

Depending on the tools used to generate the csv string you may need escape the \ character (\r\n).

Upvotes: 0

Jonathan
Jonathan

Reputation: 883

supposing you have a text variable containing:

const text = 'wonderful text with \n newline'

the newline in the csv file is correctly interpreted having enclosed the string with double quotes and spaces

'" ' + text + ' "'

Upvotes: 3

Luan Nguyen
Luan Nguyen

Reputation: 322

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"&CHAR(10)&"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.

Upvotes: 1

Sam
Sam

Reputation: 6112

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

Upvotes: 2

kantsverma
kantsverma

Reputation: 636

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=>$repairDetailData){

    if($checkkey >0){
        $itemCode   .= "\n".trim(@$repairDetailData['ItemMaster']->Item_Code)."\n";
    }else{
        $itemCode   .= "\n".trim(@$repairDetailData['ItemMaster']->Item_Code)."\n";             
    }
    $repairDetaile[]= array(
        $itemCode,
    )
}
// pass all array to here 
foreach ($repairDetaile as $csvData) { 
    fputcsv($csv_file,$csvData,',','"');
}
fclose($csv_file);

Upvotes: 0

Dan Robidoux
Dan Robidoux

Reputation: 627

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";

Upvotes: 61

rajah9
rajah9

Reputation: 12329

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.

Upvotes: 55

Related Questions