Streaming live at 10am (PST)

CSV import other language characters / umlaut

I have a site that is in German. So the texts in my csv have German characters like ä, ö, ü und ß.
When I import the csv to Webflow these characters and also some punctuation marks are displayed as question marks or other glyph-symbols.

I have tried exporting the csv from Numbers, Excel and Libre Office with different specifications: Unicode UTF-8, West European (ASCII), West European (Windows Latin), West European (Mac OS) – all with the same result.

Does anyone know how I should export the csv or if there is anything else I can do to get all characters to show up correctly?

Any help is very much appreciated!
Thanks, Philipp

@Heldentaten
You will need to encode all those characters to html entities. This can be done in most developer editors. When you import csv data into a rich text field, the contents need to be formatted in HTML. When you choose a font to render the contents, you need to make sure it also supports the characters and glyphs your trying to display.

Here is an online tool where you could process some text and have it encode it for you . There are probably lots.

https://www.web2generators.com/html-based-tools/online-html-entities-encoder-and-decoder

@webdev Thanks a lot for your fast reply! That works and helped a lot!!

Hi Jeff! does this workaround only work for rich text fields or can something similar be used for plain text fields? I can’t get it to work for my project - any input would be appreciated! :slight_smile:
Thank you so much!

@valepop - I can’t answer your question without more information. I would need a specific instance / demonstration of the issue you are having an issue with.

Thank you so much for replying!! I actually just figured it out and I feel really silly - I just opened the CSV file on notepad and changed the encoding from ANSII to UTF-8. For some reason even though I was exporting from excel as UTF-8, it wasn’t going through.

Thank you so much!! Take care,
Valeria

1 Like