LrExcel is a pair of integrated tools:

  • Lightroom plugin
  • Excel add-in

Used in conjunction, they

  • Get metadata from Lightroom
  • Send metadata from Excel to Lightroom either:
    • from marked-up cells in a carefully-structured spreadsheet
    • using the LrExcelSend formula
    • the Send button only sends selected cells

The tools will be released in September 2021, and I’m using this page to build up notes and tips.

Installation

You must install both tools:

  • Lightroom Plugin
    • Standard Lightroom plugin installation via Plugin Manager
    • There’s no UI in Lightroom except what you see in Plugin Manager
  • Excel Addin
    • Put the xlam file wherever you want, maybe in the same folder as the Lightroom plugin?
    • Addin installation is different depending on your operating system and sometimes version of Excel:
      • Windows: File > Options > Add-ins > Manage > Browse
      • Mac: Tools > Add-ins > Browse
    • You should see an extra bar added to Excel’s ribbon

Easy way to Get and Send Metadata

  • Select items in LR
  • Go to Excel and choose a Generate option – this triggers LR
  • Return to Excel and click the Find button to identify cells set up for sending back to LR
  • Click the Mark button to mark them so the can be sent
  • Select the cells you want to send
  • Click the Send button
  • Lr-Excel sends the value of the cell

LrExcelSend formula

 

Hyperlink Warnings – Windows

When you click the Generate and Send buttons you will get a warning like this.

It’s because the add-in is using a hyperlink in the form lightroom:// to communicate with Lightroom which listens for URLs with this protocol. Microsoft rightly questions whether it is appropriate.

If you answer No, the add-in stops and cannot work. In this case, LR-Excel is unable to operate. If you answer Yes, LR-Excel operates normally.

You will get this message each time you click one of these buttons. However, once you are happy with LR-Excel it is possible to tell Windows that lightroom:// can be trusted.

 

How to enable or disable all hyperlink warnings

I am still working on how to allow the lightroom:// protocol.

To disable the display of security warnings in general, follow these steps:

  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate the following registry subkey: HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\xx.0\Common\Security\

Note In this subkey, replace xx.0 with 16.0 or your current Office version.

  1. Right click Security in the left column and point to New, and then choose DWORD.

Type (or paste) DisableHyperlinkWarning as the Value name and enter

Double click on DisableHyperlinkWarning.

Enter 1 as the Value data to disable the warning.

To restore the warning, go back to the above key and delete it or set a value of 0

Hyperlink Warnings Mac

Not yet resolved

Mac – Grant Access message


When you run Get, you will see a dialog like this:

 

Click select:

That takes you to a screen like this:

Just click “Grant Access” – don’t select anything, just click the button