Looking for a better way to insert images into Google Sheets? Kori Ashton will help you put images into a cell easily. No Addons Needed. Simple formula – See below
Full Written Transcript
Hey, everybody, welcome to the WordPress Wednesday. I wanna teach you today how to insert a picture into a Google Sheet. Forget Excel Spreadsheets, it’s so difficult to put a picture into a spreadsheet. Not anymore inside of Google Sheets. I’m gonna show you, there’s an obvious way how to do it but I’m gonna show you a better way how to do it. So, if you’re living inside the world of WordPress and you’re trying to create your content calendar, I use Google Sheets. This is a great way for you to do it and insert that featured image for your WordPress website or whatever you’re trying to do, add a picture in there so you can use it in your social media feeds, this is a great solution for you.
For those of you who are inside the WordPress world, I have to give a shout out to Pressable. If you’re looking for a way to speed up your WordPress website and make sure it loads quickly and is super secure, if you’re looking for a team that can answer all of your support questions, that’s Pressable, check them out, I’ll put the link in the description box below.
All right, y’all, do you wanna learn how to do this? ‘Cause it’s pretty darn super cool. There’s the obvious way of inserting an image into a cell, right, so we’re gonna come over here and do Insert, and we’re gonna come here to Image, and we’re gonna select it from our desktop if we want to. We’ve got a couple other things you can do, by URL, by Snapshot, so take a snapshot of your screen, you can go into your Google Drive, all sorts of different ways.
For the sake of now, I’m just gonna show you. It’s a really bad way to insert images into a sheet ’cause watch this, I’m gonna upload this picture, see what happens and you probably already experienced this and that’s why you’re doing a google search right now for how to insert images into a Google Sheet. Look how weird that went. It doesn’t even fit into the cell. So, you can grab it and kinda resize it or something but it just kinda floats a little bit and it’s just weird. So, how the heck are you supposed to actually put an image into the cell in a better format?
So, here we go. I’m gonna show you here how to insert images in a Google Sheet. Let’s go here. I want this column, this particular cell, to be a preview so I want the actual thumbnail to live here and now I’m gonna go ahead and keep the URL of the image as well. So, what that means is I’ve taken a picture and I’ve just gone over to my WordPress website, I’ve gone into the Media Library, and I’ve uploaded it. And once you do that you can click on Edit and you can go into the picture itself and you will find the path of where that file now lives. So, you’re gonna copy that little path, this one right over here, right up above me, grab that URL, copy that onto your clipboard, and you’re gonna come back over to your spreadsheet.
This is the tricky part, get ready for this. Are you ready, ’cause I’m ready. Here we go, in the cell where you want the picture to actually preview, I want you to type equals, we’re gonna go into formula mode here, don’t get intimidated here ’cause it’s super easy, image is what you’re gonna type, okay? And then it’s gonna open up and put an open parenthesis, I want you to put quote marks, so an open quote, past in your URL and do a close quote and a close parenthesis. Do you see this up here at the top? That’s what it looks like. Click enter and check that out.
There’s my little picture, perfectly nested inside of that cell, beautifully there available for anybody on the team can take a quick look and be sure that we’re using the right picture. And then if they need to have that URL so that they can download it for the post, you can obviously paste the URL, ’cause it’s still on your clipboard, in another column that you can easily reference where to go grab that image and use it in all your social media, your featured image, on your WordPress website, wherever you need to. Pretty cool option, right? It sits in there and it’s never gonna interrupt the other cells around it.
Formula
=IMAGE(“https://imagepathhere.com/photoname.jpg”)
I’m gonna show you a little bit more advanced stuff. I don’t know if you knew about this but once you do that, you’ve got a couple options on how to size it in this space. If you wanted to, you can add a comma after your, op, let me back up for a second, see, even we make little mistakes, I’m gonna come up here on the top and open this up. You’re gonna add a comma and then what you’re gonna do is you’re gonna put a number two in there and click enter, see how it stretches it to fit my cell, so if I wanted to have a larger space to kind of preview it a little bit bigger, I could open that up and have it a nice big open and it still fits that cell and stays with me if I need to move this whole entire row, I could slide it around and move it around and it’s gonna stay with me. So, that’s a really cool super feature.
Fit the cell
=IMAGE(“https://imagepathhere.com/photoname.jpg”, 2)
You can do an option three and that’s actually gonna put it in that tiny cell at full size, so that’s an interesting feature. It’s up to you if you wanna do it that way.
Full size of the image in the cell
=IMAGE(“https://imagepathhere.com/photoname.jpg”, 3)
And then there’s also a final fourth option, type in the number four and do another comma and you can actually put in the exact size of the image so if you saw over on your website, on your WordPress website, it’s gonna give you dimensions of the actual original size of the file, you can come here and just type those in, 922, comma, 1604 or was it 40, what was it y’all, 1640, okay, gotta remember those things. There you go, click enter, and again it’s gonna always, no matter what, keep that original file size living in there. So, pretty cool options, you guys, huh? How to put a picture inside of your Google Sheet.
Setting the Image Size in the cell
=IMAGE(“https://imagepathhere.com/photoname.jpg”, 4, 50,100)
You would replace the last two numbers with your images size
I hope this helps you. If you have questions, put ’em in the thread below. I’d love to answer them as best as I can and be sure to subscribe to my channel because every Wednesday I’m creating a video just like this to help you improve all things WordPress. Bye, bye, y’all.
