View Aspect Ratio of existing photo in Lightroom

[KostFan2]

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

[Rob_Cullen]

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  )

[KostFan2]

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

[GoldingD]

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)

[GoldingD]

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.

[John R Ellis]

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

[John R Ellis]

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

[KostFan2]

Dear @John R Ellis  and @GoldingD 

• Your Contribution & Impact:
  I am dumbfounded!  In this age where there is so much war and hate, you “Legends” and “Community Experts” are a breath of fresh air.  Please know that I value your information tremendously, as well as the personal time it required to create.  I am also sharing it with a team of 15 staff.
• “Impact” Badge:
  I wish I had discovered this Forum years ago.  My understanding of Lightroom and Photoshop would be lightyears ahead of where it is today. I wish Adobe would add an additional “Impact” badge for suggestions that have a significant beneficial impact on the original poster.  I know there is a badge that tracks “Correct Answers”.  However, I think there should be a new badge that rewards people like both of you who take so much time and care to try and help another person. I hope @RikkFlohr  sees this post.
• Useful Tools for the Community:
  @RikkFlohr : Does this forum have a location where members can post tools they find useful for their work?  This way we can give back to the entire community.  The tools may seem trivial to you. However, for people beginning their Photoshop or Lightroom journey, it would be an invaluable resource to help them accelerate their learning and get much more out of both programs.  You could even add a notification email alert so that when a member posts a tool the other members could be notified if they want.  Please let me know if this already exists.
• Clarifications of your answers:
  @John R Ellis: would you be able to edit your Ratios table spreadsheet and add two columns to the left that present the width and height in Pixels (converting your existing column A and B data) and post it here?  I can then combine it with my spreadsheet and post the results back here for the community to use.
• @GoldingD:
  Your suggestions may seem trivial and obvious to you, but please understand how much I appreciate them.  At my age, my brain has trouble coming up with the correct question to ask in Google.  It is a generational thing.  Most people over 80 are just not wired for Google.