Is there an easier way to get text into Lightroom?
Updated video
Coming soon to my ListView plug-in, automatic updating from Excel to Lightroom. Have you ever seen an easier way to get text data into Lightroom?
For the technically-minded, it’s an Excel macro which reads the spreadsheet and communicates directly with the open Lightroom catalogue. In my former life as a financial IT consultant I used to do a lot of work with Excel’s VBA programming language, and the use of a custom formula is very similar to how Excel communicates with many business systems, so I’m confident it’s a solution which will work.
It’s worth adding that I’m not doing anything dubious like hacking into Lightroom’s SQL database or XMP files – the automation is entirely via Adobe’s authorised method, the SDK.
I will need testers – ideally existing ListView users. It will only work with Lightroom 5 and you would need to have one of the very latest versions of Excel – definitely Office 2011 on Mac as the previous version omitted VB. If you want to try it in advance of release, let me know by email or by adding a comment to this post.