CSV export - Line breaks are not exported as UTF-8 characters but weird symbols

Forum|Forum|5 years ago
December 7, 2020
3 replies
100 views

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.

David B103Author

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"

David B103Author

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  

Emma D

Lucid support team

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.

Create an account in the community

Log in to the community