Skip to main content
Astromonte
Participant
February 15, 2023

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

  • February 15, 2023
  • 2 replies
  • 1274 views

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

This topic has been closed for replies.

2 replies

johnrellis
Legend
February 16, 2023

[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:

 

 

Rikk Flohr_Photography
Community Manager
February 15, 2023

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

Rikk Flohr: Adobe Photography Org