Encoding issues special characters (ä, é, ü) for CSV creation

How To
, ,
1

Context
My goal is to create CSVs for an FTP-upload (stock status, product descriptions,…). Mostly working well, but I’m now running into an issue with the encoding of special characters. The CSV files need to be UTF-8 encoded (which seems to be the case by default), and they will contain special, non-english characters (ä, é, ü, ö,…).

Issue
I cannot make it working and each time the CSV is created, the special characters are not correctly encoded. In make.com, the characters are correctly represented but in the final CSV generated, they’re not.

image
image1600×529 51.1 KB

Attempts
I setup a separate test scenario to simply test all different encoding/ manipulation methods (toString, convert encoding, encodeURL,…). These were some strategies mentioned in other threads: #1, #2.

Using ascii (e.g. described here) is not an option, since i need the special characters to be there in the final CSV.

Any help would be greatly appreciated.

To reproduce
Attached are:

  • Blueprint
  • Screenshots
  • Sample CSV generated

image
image2263×826 89 KB

blueprint (1).json (28.6 KB)
file.csv (134 Bytes)

1 Like
2

Hello @tj-may-20; you sure your CSV reader is using UTF-8 to view the file?

Can other files with the targeted characters be viewed as wanted in your CSV reader?