Support accented characters when exporting in CSV
When I export one of my view in CSV, I get :
Record ID,NumÃ©ro de sÃ©rie,EmployÃ©,Status,Date,Description
instead of :
Record ID,Numéro de série,Employé,Status,Date,Description
Samuel Kay commented
Sorry for this late answer.
Chosing unicode as character encoding did the trick ! Thank you !
It sounds like you are trying to open the file using Microsoft Excel, which does not properly support the encoding of special characters. To continue using Excel, Microsoft's support website suggests importing the file to Excel and selecting the proper file origin. While the exact steps may differ depending on your version of Excel, we have posted the import instructions below:
1 - Open Microsoft Excel
2 - Click on the Data menu bar option.
3 - Click on the From Text icon.
4 - Navigate to the location of the file that you want to import. Click on the filename and then click on the Import button. The Text Import Wizard - Step 1 or 3 window will now appear on the screen.
5 - Choose the file type that best describes your data - Delimited or Fixed Width.
6 - Choose 65001: Unicode (UTF-8) from the drop-down list that appears next to File origin.
7 - Click on the Next button to display the Text Import Wizard - Step 2 or 3 window.
8 - Place a checkmark next to the delimiter that was used in the file you wish to import into Microsoft Excel. The Data preview window will show you how your data will appear based on the delimiter that you chose.
9 - Click on the Next button to display the Text Import Wizard - Step 3 of 3.
10 - Choose the appropriate data format for each column of data that you want to import. You also have the option to not import one or more columns of data if you want.
11 - Click on the Finish button to finish importing your data into Microsoft Excel.
Another option is to open the file in Notepad (Windows) first, then use the Save As feature outlined below:
1 - Open the CSV in notepad
2 - Save As > All Files (be sure to type '.csv' in the file name)
3 - Encoding > UTF-8
4 - Open the new CSV file using Excel and the non-English characters should display properly.
Lastly, to mitigate the additional steps needed to open the file in Excel, you could open the file using Open Office (Windows) or Numbers (Mac), as they can both properly encode the character formatting.
Let us know if you have further questions.