Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1

Opening exported keywords in Excel

LEGEND ,
Feb 15, 2023 Feb 15, 2023

LR 12.2 tweaked the Metadata > Export Keywords command to export in two formats, .csv and .txt:

johnrellis_0-1676480876625.png

 

The industry-standard .csv format includes all the keyword attributes (Include On Export, Export Containing Keywords, etc.), while the .txt includes just the keywords. (In prior versions, LR exported in a custom .txt format that wasn't easy to manipulate.)

 

In both formats, nested keywords have their names preceeded by the corresponding number of tab characters.  Most text editors will display the tabs correctly:

johnrellis_1-1676481198650.png

 

But if you open the .csv in Excel, all the indenting of nested keywords appears lost:

johnrellis_2-1676481297425.png

 

Don't panic -- Excel preserves the tabs but normally doesn't display them. If you select a cell and then click in the formula bar, you'll the tab displayed:

johnrellis_3-1676481507418.png

 

 

 

 

TOPICS
macOS , Windows
334
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation