Generate CSV - how to keep special characters?

Does anyone have a tip for preserving special characters when generating a CSV export? For example foreign letters with accents?

When I import a file into Glide from Excel the characters are maintained. However, exporting out seems to lose them. For example ö or é.

Thanks I’m advance for any tips.

Is this using the Generate CSV integration?

If yes, it sounds like it night be a bug.

Yes that’s right. I think it needs to be saved with the ANSI format option. If this can be changed that would be great.

My workaround is to open with Notepad then save with ANSI format. Then open that file with Excel.