character encoding mismatches

Hi,
I'm having an issue when downloading a dataset in CSV format, some of the characters are been introduced on the download such as ’s instead of " ' ". Is there a setting or function to prevent this issue?
Best regards,
Marco
Best Answers
-
Are you opening the csv in Microsoft Excel?
By default Excel uses ANSI encoding which causes special characters to display incorrectly. In Excel, navigate to Data > Import External Data > Import Data/Import From Text and choose 65001 Unicode (UTF-8)Alternatively, create a blank Excel file, go to Data > From Text/CSV, and select the exported file from the Data and Analysis tab. On the next page, use the origin as “UTF 8” and then delimiter comma then load the data.
Another option is to replace these special characters in Aperture before exporting.
The character you highlight is not an apstrophe, but instead is a "right single quotation mark" character (')
1 -
Opening up multibyte CSV files in Excel is always problematic.
Exported as CSV from Aperture and opened in Notepad++ - multibyte characters are displayed correctly:
Same file opened in Excel (without specifying the encoding first) - multibyte characters are incorrect / mojibaked:
1
Answers
-
@Josh Boxer Thanks for the reply. I've followed your advise and imported the data from the Aperture output to a table using the Data import in Excel.
0