How to include " in the string of CSV file?

Hi everyone,
I’m trying to import CSV files to the string tables. But the strings include double quotation marks failed to be imported and pop up “BadDataException: You can ignore bad data by setting BadDataFound to null.” error.

I’ve tried using ", but it’s not working.

How can I include double quotation marks in the string?
Thank you in advance.

If you are editing the csv file by hand then you need to add double quotations (“”)

E.G
This contains quoted text => “This contains ““quoted”” text”
Some Text => “““Some Text””

If you are unsure, then add the quotes in the table editor and export them to CSV through the table editor, it will generate the correct quotation formatting for you.

1 Like

It works! Thank you a lot!

1 Like