Converting csv to xlsx character encoding
Hey all! I have created a workflow that is converting csv to xlsx.
I am facing an issue where Chinese character encoding is not handled right.
For example, character 五 is converted into something like
The node I am using is Spreadsheet File and I am self hosting n8n using Docker
Hi @stathisaska, welcome to the community!
Are you by any chance using v1 of the Spreadsheet File node? If so, a fix for the problem should hopefully be available with the next version of n8n: fix(Spreadsheet File Node): Read file as utf-8 in v1 by elsmr · Pull Request #7701 · n8n-io/n8n · GitHub
If that’s not it, can you share a workflow using which the problem can be reproduced and confirm the exact version of n8n you are running?
I am on the version before that fix, so will update and check whether the issue has been fixed.
Thank you for your input!