Skip to main content

How to extract metadata from images

I want to extract EXIF and other metadata from attachments stored in Airtable

Updated yesterday

The Extract Image Metadata automation can extract location coordinates, creation date/time, camera information, dimensions and aspect ratio from images. Depending on your requirements, you can create and configure the following fields:

  • Attachment Airtable Field:

    • The field that contains your images as attachments.

  • Longitude Airtable Field (Optional):

    • This can be a number or a text field. To correctly capture the data in a number field, enable 'Allow negative numbers' and select the maximum number of decimal places.

  • Latitude Airtable Field (Optional):

    • Configured similarly to the longitude field.

  • Created Date Airtable Field (Optional):

    • This must be a date field. If you wish to extract the creation time, be sure to enable ‘Include time’ in the field configuration.

  • Camera Make Airtable Field (Optional)

    • This must be a text field.

  • Camera Model Airtable Field (Optional)

    • Same as the Camera Make field.

  • Image Width Airtable Field (Optional)

    • This must be a number field.

  • Image Height Airtable Field (Optional)

    • Same as Image Width field.

  • Aspect Ratio Airtable Field (Optional)

    • Same as Image Width field.

The automation will only extract data already present in the image metadata. If you’re not getting the expected data from your images, it’s possible that the necessary metadata isn’t included. You can check the image settings in your operating system to confirm this.

For example, on MacOS, you can find the metadata under the More Info section after using the Get Info action, as shown in the image above.

Did this answer your question?