P: Export Keywords Includes Keyword tags options (CSV) does not export diacritics correctly

[Astromonte]

System Windows 10 Home built 19045.2604

Lightroom version 12.2 (2013-02-13)

Windows Keyboaoard activated: ENG CAFR

Module Library

Menu Metatadata> Export Keywords > Includes Keyword tags options (CSV)

The action does not export diacritics for words that possess them

Activité becomes Activité

Université Laval becomes Université Laval

François Côté becomes François Côté

etc.

It works fine in the original mode (to text file)

D. Gascon

[Rikk Flohr: Photography]

Thank you for your report. I was able to replicate this failure and have logged a bug with the team. 

[johnrellis]

[This post contains formatting and embedded images that don't appear in email. View the post in your Web browser.]

I think you're opening the .csv file in Excel, which by default will treat the file as encoded in the current Windows code page rather than in Unicode UTF-8, causing Excel to display non-ASCII characters incorrectly.

If you open the .csv in Notepad, you'll see that the non-ASCII characters are properly encoded:

It's quite tedious to force Excel to read a .csv encoded in UTF-8:

1. Make a blank workbook.

2. Do Data > Get Data > From File > From Text/CSV.

3. Navigate to the .csv file, select it, and click Import.

4. Set File Origin: to Unicode (UTF-8).

5. Click Transform Data.

6. Click Use First Row As Headers.

7. Click Close & Load.

Now the characters will be properly displayed: