# Generate CSV - how to keep special characters?

**URL:** https://community.glideapps.com/t/generate-csv-how-to-keep-special-characters/61452
**Category:** Ask for Help
**Created:** [May 7, 2023, 5:12pm UTC](https://community.glideapps.com/t/generate-csv-how-to-keep-special-characters/61452 "2023-05-07T17:12:09Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [May 7, 2023, 5:12pm UTC](https://community.glideapps.com/t/generate-csv-how-to-keep-special-characters/61452/1 "2023-05-07T17:12:09Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 7, 2023, 6:04pm UTC](https://community.glideapps.com/t/generate-csv-how-to-keep-special-characters/61452/2 "2023-05-07T18:04:37Z")

</div>

Is this using the Generate CSV integration?

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

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [May 7, 2023, 7:22pm UTC](https://community.glideapps.com/t/generate-csv-how-to-keep-special-characters/61452/3 "2023-05-07T19:22:59Z")

</div>

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.