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

  • Josh Boxer
    Josh Boxer Administrator
    edited May 1 Answer ✓

    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 (')

  • Henry Simms
    Henry Simms Administrator
    edited May 1 Answer ✓

    Opening up multibyte CSV files in Excel is always problematic.

    Exported as CSV from Aperture and opened in Notepad++ - multibyte characters are displayed correctly:

    image.png

    Same file opened in Excel (without specifying the encoding first) - multibyte characters are incorrect / mojibaked:

    image.png

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.