Skip to main content

When I export a LucidChart diagram to a CSV shape data file the text of any lines that have soft line breaks (Shift-enter) in them are rendered in the exported CSV file as the text characters '
' which Excel interprets as '
'


IE. "Initiation
Performed" is exported as "Initiation
Performed" which Excel converts to "Initiation
performed"


Why aren't the line breaks properly exported as correct UTF-8 style characters / symbols in the CSV file.

I can't paste the UTF-8 symbol in this discussion board.


 


The UTF-8 code is xe2x80xa8 and the rendered text looks like this image:



So the text "Initiation
Performed"


is rendered in the text document as this:



which Excel interprets as "Initiation
performed"


I've found that the UTF-8 character that Lucid Chart is placing in the CSV text file is U+2028 or HTML entity code 



Hi David thanks for posting! I wasn't able to reproduce the issue with soft returns in CSV exports on my end. I created a Support ticket from your post so we can take a closer look at your specific document and CSV export and troubleshoot this directly via email. Once we identify the issue I'll update this thread so any other users experiencing the same issue can stay informed. 


Reply