Search code examples
excelcsv

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?


Solution

  • 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.