Write CSV as CSV instead of CSV UTF-8

Hi all,

I am using this write csv method

image
image

but I want to specify it so that it is saved as “CSV” instead of “CSV UTF-8”
image
image

Right now I think it is saved as “CSV UTF-8” and I can’t upload the file to the platform that only accept “CSV”…

Any idea? Do I have to put something in the Encoding field??
Thanks!

Lavina

1 Like

Hi @lavint

You’re on the right track. Check out the topic for the activity for extra information:

There is a link in there to the list of valid encodings.

1 Like

Hi @loginerror,

Thanks for your respond! I am aware of this page but I am still unsure which one is for just the “CSV”? I see the UTF-8… Any hint? Thanks

Warm regards,
Lavina

@lavint

I checked the files in Notepad++ and these are the results:
CSV (Comma delimited):
image

CSV UTF-8 (Comma delimited):
image

I also found this topic, maybe it helps:

3 Likes

Hi @loginerror,

Thanks a lot! I tested different encoding and “us-ascii” works - it saves the csv as “CSV” instead of “CSV UTF-8”

Have a nice weekend :slight_smile:

Lavina

7 Likes

Thank you. It worked!

2 Likes

i am also facing same problem i have a csv file which is UTF-8 encoded and i have to convert in into excel but when try with above method all data in single column. how to fix this issue
please help me to fix it