CSV exports: troubles with accents

General
1

Hi,

I tried to export my observations through a CSV file. I have troubles with accents in french places
and common species names. Accents are not recognised and special characters appear instead, like this :

iNat-csv-capture

I usully use utf-8 encoding with csv files to avoid this problem, but I didn’t find a way to do so for iNat exports.

How would you do?

Thanks,
Matthieu

2

(moved this from Feature Requests to General since this is a question and not a specific request.)

3

the files do appear to be delivered as utf-8 csv files. i was able to successfully import into Microsoft Excel and get all the accents by:

  1. opening a blank workbook
  2. initiating a text import
  3. in the text import wizard, select “65001: Unicode (UTF-8)” as the file origin, and comma as the delimiter:
    tbd_utf8_csv_import_1
    tbd_utf8_csv_import_1901×690 151 KB

    tbd_utf8_csv_import_2
    tbd_utf8_csv_import_2901×690 99.3 KB

    (note that in my screenshots above, i did not check the “my data has headers” box, and i should have.)
4 Likes
4

Great, thank you @pisum!

This works and fully solves my problem.

Thanks for your help,
Matthieu

3 Likes
5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.