Some Excel versions have issues when opening CSV files that can cause newline/linebreak characters trigger a new spreadsheet row instead of inserting the newline character into the data cell.

Here's how to work around it:

  • Open Excel and navigate to File > Open...

  • Select your file

  • Confirm all CSV options:

    • Delimiter = ,

    • Quoted Identifier = "

Did this answer your question?