Known Participant

Question

View Aspect Ratio of existing photo in Lightroom

Forum|Forum|2 years ago
January 25, 2024
3 replies
1137 views

We know how to change the aspect ratio of an existing photo. However, how can you view the aspect ratio of an existing picture? A client is sending us 12,000 images for cropping and we have to document what the original aspect ratio was for each.

Thank you for the assistance

Windows

This topic has been closed for replies.

GoldingD

Legend

If you want/need to document the metadata from those images (including the dimensions) consider using google to search on:

How to export image metadata to excel

Several articles on the how, and on what program to use.

johnrellis

Legend

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

"What my staff agreed to was to report the aspect ratio based on the 7 default aspect ratios that appear when the customer activates the crop tool and drop-down menu. We eliminated 16:10"

Building on the previous replies, you could use the Any Filter plugin's Sort command to export a spreadsheet with the columns Filename and Numeric Aspect Ratio:

In Excel, add a column Ratio that looks up the Numeric Aspect Ratio in a separate Ratios table to find the closest of the 7 Crop tool ratios:

The Ratios table is a little tricky, containing midway points between each of the 7 ratios (each in portrait and landscape mode), and "Other" for very small and very large numeric aspect ratios:

I've attached the spreadsheet for my test catalog.

example.xlsx

johnrellis

Legend

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

Also, you can filter by numeric aspect ratio using the Any Filter plugin:

GoldingD

Legend

In the metadata. One place is dimensions under EXIF metadata. If you use the default metaedata option, customize that to include the dimensions (also found in Camera data)

Rob_Cullen

Community Expert

You are going to encounter thousands of possible ratios for that many images, and Lightroom won't show those. The slightest difference in pixel dimensions will mean another ratio!

If you just report the original PIXEL dimensions (w:h) you are somewhat on the way.

You might be able to use spreadsheet math to reduce the pixel dimensions to the lowest common denominator. (eg 4000x6000px = 2:3 5700x3900px = 19:13 )

Regards. My System: Windows-11, Lightroom-Classic 15.1.1, Photoshop 27.3.1, ACR 18.1.1, Lightroom 9.0, Lr-iOS 10.4.0, Bridge 16.0.2 .

KostFan2Author

Known Participant

Rob:
Thank you for the quick response. What my staff agreed to was to report the aspect ratio based on the 7 default aspect ratios that appear when the customer activates the crop tool and drop-down menu. We eliminated 16:10

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded