Display images in Google Spreadsheets application

Insert images into Google Spreadsheets

Today we are going to explore Google Sheets. As some of you may not know Google Sheets, same as Google Slides are a word processor, a spreadsheet and a presentation program respectively, all part of a free, web-based software office suite offered by Google within its Google Drive service. Many people just know and like to call Google Sheets similar as Excel, but respectively laying on the internet and for free. Normally in order to setup a project and start working with Google Sheets all the users are required to have a google account. We are not going to start it from the basics, but rather focus on tricks and tips that can significantly increase the efficiency or simply save time.

Insert images into Google Spreadsheets:
This is going to be our subject in this post and we will try to explain how this feature works on google spreadsheets application.

Normally, when people try to insert image from the “menu options” or just trying to drag it from their desktop, application fails to display the image visual part. Here we are meeting very common issue, that many people struggle to solve. We will show some basic Google spreadsheets rules, that will give you a full understanding of how it works, same as you will also later have a great opportunity to try it yourself.

 

Google image function
Function for image display

 

Basic function “=IMAGE” together with valid image URL (image you would like to display) allows you to insert image inside a cell and display it visually. You can also control aspect ratio, what allows you to change size of the image in accordance to the height of the cell.

 

Basic Examples:
=IMAGE(“URL”) – Original image ratio fitted in the height of the cell
=IMAGE(“URL”,2) – Image is stretched to fit all edges of the cell
=IMAGE(“URL”,3) – Image retains its original ratio
=IMAGE(“URL”,4,50,50) – Including image options for manually changing ratio. You simply need to try changing 50,50 for the next preferred result.

 

Display of Google Spreadsheet images
Displayed images in Google Spreadsheets

 

For more advanced users we would like to share experience of how to also display images that are uploaded on google drive. Normally, it can be quite a headache to figure it out, but we know the way of how to help you. As far as we could experience google drive functionality together with Google spreadsheets, this function sample below is the only way to directly display images in the Google Spreadsheet cell. This URL structure is 100% reliable and fully dependable of id which is missing in the sample. ID is always unique and must be taken from the uploaded image URL on your google drive application. Once you have done it and combined it with the function example we provided you with, you must be able to see your result immidialtely in the selected cell area.

=image(http://drive.google.com/uc?export=view&id=*********************)

 

In case you are very advanced and familiar of how to setup Google Spreadsheets and Google Scripts, we also consider it mutual to have a script which can do a automated Google drive results directly in the preferred Google Spreadsheet just by simply pressing “run this script” function. See full function overview below:

 

Script editor example
Google Script editor example


function listFilesInFolder(folderName) {

var sheet = SpreadsheetApp.getActiveSheet();
sheet.appendRow([“Name”, “Date”, “Size”, “URL”, “Download”, “Description”, “Image”]);

var folder = DriveApp.getFolderById(“************”);
var contents = folder.getFiles();

var cnt = 0;
var file;

while (contents.hasNext()) {
var file = contents.next();
cnt++;

data = [
file.getName(),
file.getDateCreated(),
file.getSize(),
file.getUrl(),
“http://drive.google.com/uc?export=view&id=” + file.getId(),
file.getDescription(),
“=image(\”https://docs.google.com/uc?export=download&id=” + file.getId() +”\”)”,
];

sheet.appendRow(data);
};
};

This script will generate you all uploaded images on selected Google drive folder including its Name, Date, Size, URL, Download URL, Description and Image visual.

 

Google Script editor results
Google Script editor results in Google Spreadsheets

 

As normally we recommend to try it yourself for full understanding. Best way to learn is to try and see how it works.

We hope you liked our post and feel free to get in contact or write comments if you have any questions.

Kind regards,
KB Media Solutions team


Google banner thumb

Search images on the internet

Having some issues to find images that you have recently liked?

Do not worry. Its a very common problem that many people is facing each and every day.
Here we have few tips-options that might be helpful in the future.

 

Option one: www.google.com/images

We definitely first suggest to use the most famous image library of images. Google images offer a huge range of many different kind of images that are uploaded on various websites across the internet. On the other hand users only need to type one keyword or few keywords in order to describe their wished search item.

Google images is made in user search intelligent-friendly way that also tries to help and suggest similar or related search results. In case of wrong described or not accurate keyword choice, this great Google images library feature allows users to dive deeper and find the results they have been looking for.

 

Never less, google has even more great features that users love. One of the features we must talk about is Google image library tools, which can be found under “More tools”. This amazing features allows users to sort their results based on “Size”, “Color”, “Type”, “Time” and “Usage rights”.

 

Overall Google images is a wonderful service that simplifies and serves users with great advantage versus other search engines on the internet.

 

Option two: www.tineye.com

Next extremely useful internet search tool that we would like to talk is tineye.com. Often users have issues finding images that are abstract, or simply not perfectly themed that it could be described in keywords. There tineye.com offers an optional way of searching for images on the internet. Here users are not asked to type any keywords or describe their wished search criteria. The only requirement is fragment or draft of the image you are looking for. For example, you found a nice image on the magazine or printed poster and only thing you have to do is to take your smart phone and shoot a picture that can be later uploaded on tineye.com. This internet tool really works and runs search of selected / uploaded item through the whole internet universe. Technology is based on uploaded visual material details recognition and match found on the internet websites that ever hosted similar images. Tineye.com is also very accurate and 95% of time will only show and display image suggestions that are exact copy of the image you tried to upload and search for.

Option three: www.reverse.photos

This is optional internet image search engine tool that works 99% similar to tineye.com. Same technology, same procedure and accuracy of image results.
So, in case you did not like to use option 2, this might be the one you would prefer using in the future.

 

Thank you for using your time and reading our news. We hope it was helpful.

P.S In case you have any questions, do not hesitate to get in contact and we will try to give you more assistance.

Best regards,
KB Media Solutions team


instagram product page thumb

Our Instagram Page

Fresh content on Instagram page.

Some time ago we have introduced with our Instagram page .
Ever since we were trying to enrich and update the page with the most inspiring logo works each and every week.

It allowed us to see clear improvement while trying to be better engaged with our potential customers.
Therefore, we have decided to increase the variety of our content subjects and types of posts that we share.

Interested? Feel free to visit our page same as you are very welcome to use it at all the time when its needed for you to get some fresh news, updates or inspiration.
All your comments, ideas, suggestions and likes or just follows are very much appreciated!

Visit our Instagram page here.

Instagram KB Media Solutions profile image


facebook product page thumb

Our Facebook Page

Upgraded Facebook page.

Few years ago we have introduced with our Facebook page .
Today we are very happy to be much more advanced and serve our end-consumers with many new options and advanced features.

Feel free to visit our page same as you are very welcome to use it at all the time when its needed for you to get some fresh news, updates or inspiration.
All your comments, ideas, suggestions or just likes and follows are very much appreciated!

Visit our Facebook page here.