# Encoding for CSV export?

**URL:** <https://integration.keap.com/t/encoding-for-csv-export/48507>\
**Category:** Max Classic\
**Tags:** export\
**Created:** [August 3, 2018, 5:49pm UTC](https://integration.keap.com/t/encoding-for-csv-export/48507 "2018-08-03T17:49:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bert\_Joseph-Pare](https://avatars.discourse-cdn.com/v4/letter/b/3ab097/32.png) [@Bert\_Joseph-Pare](https://integration.keap.com/u/Bert_Joseph-Pare)\
**Post date:** [August 3, 2018, 5:49pm UTC](https://integration.keap.com/t/encoding-for-csv-export/48507/1 "2018-08-03T17:49:02Z")

</div>

Hi,

We’re exporting contacts to CSV for use in an internal web application, but any special characters (é, è, etc) are coming out wrong in the CSV… (as “,” and “Š”, respectively). They appear correctly within Infusionsoft.  
Is this a bug on Infusionsoft’s side, and is there any known workaround? Has anyone else had this issue?

Thanks for any help!

---

<div class="post-metadata">

**Author:** ![martinc](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/martinc/32/14_2.png) [@martinc](https://integration.keap.com/u/martinc)\
**Post date:** [August 6, 2018, 6:21pm UTC](https://integration.keap.com/t/encoding-for-csv-export/48507/2 "2018-08-06T18:21:29Z")

</div>

Hi, @Bert_Joseph-Pare. I was just playing around with this and it worked for me. Are you still having an issue?

![image](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/a/a4ada3dfbb190648638030b1ebf74f42c358c2b9.png)

---

<div class="post-metadata">

**Author:** ![Joey\_Novak](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/joey_novak/32/2416_2.png) [@Joey\_Novak](https://integration.keap.com/u/Joey_Novak)\
**Post date:** [August 6, 2018, 6:59pm UTC](https://integration.keap.com/t/encoding-for-csv-export/48507/3 "2018-08-06T18:59:50Z")

</div>

I’m pretty sure this depends on the tool you open it with. The CSV file format has no file encoding header, so your tool of choice is free to use whatever character encoding it wants to interpret the file (in my limited experience with character encoding problems, the program usually uses the platforms default character set). If it’s not the right one, you will get giberish. It may work on a mac, but not on windows, or work with google sheets and not on a desktop, etc… What did you use @martinc?

Joey

---

<div class="post-metadata">

**Author:** ![martinc](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/martinc/32/14_2.png) [@martinc](https://integration.keap.com/u/martinc)\
**Post date:** [August 6, 2018, 7:10pm UTC](https://integration.keap.com/t/encoding-for-csv-export/48507/4 "2018-08-06T19:10:30Z")

</div>

Windows/Exel. I also imported the CSV file to Google Sheets and that worked too.

---

<div class="post-metadata">

**Author:** ![Oleksandra\_Lukavetsk](https://avatars.discourse-cdn.com/v4/letter/o/db5fbb/32.png) [@Oleksandra\_Lukavetsk](https://integration.keap.com/u/Oleksandra_Lukavetsk)\
**Post date:** [August 14, 2018, 8:24am UTC](https://integration.keap.com/t/encoding-for-csv-export/48507/5 "2018-08-14T08:24:47Z")

</div>

Hey,  
If you`re still struggling the issue, try to export the records using Data2CRM service.  
The SaaS will import all the fields putting each one of them into different CSV or Excel file and creating the connections between them. That means you will be able both to use it in an internal web application and to migrate the data to another CRM solution with the same relations between records as it was within Infusionsoft.

Also, a good news is that you can make the review on how your information will look like for free.  
For that, migrate a limited amount of the real data from Infusonsoft to CSV or Excel files by running free [Demo Migration](https://app.data2crm.com/wizard?utm_source=migration-salesforce-infusionsoft-integration&utm_medium=august_2018_infusionsoft&utm_campaign=CommentsCampaign).

Hope, it is a useful advice