New Feature: Default Image Mode

Now, in version 1.4.7+ of the Add to Sheets Chrome extension, you can override the default image import function mode used when adding images into sheets. When Add to Sheets saves an image to your spreadsheet, it uses the following formula:

=IMAGE("https://example.com/image.jpg", 3)

This function displays the image at its original size in your spreadsheet.

Now, The settings override allows you to choose from only inserting the plain URL (i.e. the hyperlink) or =IMAGE() with a mode that specifies how to handle the cropping of the image within the spreadsheet cell.

The selected setting will be used for all column configurations.

To enable this feature for use:

1. Open the extension settings by clicking on the profile dropdown in the extension and selecting Settings.

2. Select which import mode or plain format that you’d like to use
3. Right-click and add images - now the image mode will be used

Image modes

The different options are available:

• None - The plain URL will be added to the cell without an import function.
• =IMAGE(url, 1) resizes the image to fit inside the cell, maintaining aspect ratio.
• =IMAGE(url, 2) stretches or compresses the image to fit inside the cell, ignoring aspect ratio.
• =IMAGE(url, 3) leaves the image at original size, which may cause cropping.

Feedback

If you have any feedback, suggestions or questions about this feature, please reach out to me at [email protected]. I’d love to hear from you!