{"id":719,"date":"2017-02-21T10:01:14","date_gmt":"2017-02-21T15:01:14","guid":{"rendered":"http:\/\/teachersfirst.com\/blog\/?p=719"},"modified":"2019-04-05T18:01:45","modified_gmt":"2019-04-05T22:01:45","slug":"teachbytes-inserting-images-into-google-spreadsheet-cells","status":"publish","type":"post","link":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/","title":{"rendered":"TechBytes: Inserting Images Into Google Spreadsheet Cells"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Power up your Google Sheets productivity. Watch this episode of TechBytes to learn how to insert images into individual cells in your spreadsheet<\/span><span style=\"font-weight: 400;\">. Use the =IMAGE function and gain control of images. It is easy and effective. While users have always been able to add images to Google Spreadsheets using the Insert Image menu option, those images lie on top of the spreadsheet cells. Consequently, if you sort the data within your spreadsheet, the image stays where you originally placed it and doesn\u2019t move along with the corresponding data. This video will teach you how to solve that problem.<\/span><br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/rwt4bWJ_SV8?rel=0\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><br \/>\nThere are a number of reasons why you might want to do this as an educator, here are a few:<\/p>\n<ul>\n<li>As you prepare a folder of documents for a\u00a0substitute teacher, you might want to include a file with student photos matched with names to help them know who is who.<\/li>\n<li>If you are collecting images to use with a unit, you might want to catalog images you plan to use for examples in class vs. those you plan to use for tests and quizzes.<\/li>\n<li>When gathering images\u00a0to share with other teachers, keeping them categorized in a\u00a0spreadsheet will help everyone be able to sort through them more efficiently.<\/li>\n<\/ul>\n<p>TechBytes are video tutorials created for the TeachersFirst blog. Come learn with us!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power up your Google Sheets productivity. Watch this episode of TechBytes to learn how to insert images into individual cells in your spreadsheet. Use the =IMAGE function and gain control of images. It is easy and effective. While users have always been able to add images to Google Spreadsheets using the Insert Image menu option, &hellip; <a href=\"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/\" class=\"more-link\">read more &raquo;<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_nextfly_llmd_date_locked":false,"footnotes":""},"categories":[36],"tags":[71,73,72,42],"class_list":["post-719","post","type-post","status-publish","format-standard","hentry","category-techbytes","tag-google-sheets","tag-images","tag-spreadsheets","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>TechBytes: Inserting Images Into Google Spreadsheet Cells - TeachersFirst Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TechBytes: Inserting Images Into Google Spreadsheet Cells - TeachersFirst Blog\" \/>\n<meta property=\"og:description\" content=\"Power up your Google Sheets productivity. Watch this episode of TechBytes to learn how to insert images into individual cells in your spreadsheet. Use the =IMAGE function and gain control of images. It is easy and effective. While users have always been able to add images to Google Spreadsheets using the Insert Image menu option, &hellip; read more &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/\" \/>\n<meta property=\"og:site_name\" content=\"TeachersFirst Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/teachersfirst\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-21T15:01:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-05T22:01:45+00:00\" \/>\n<meta name=\"author\" content=\"Karen Streeter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@teachersfirst\" \/>\n<meta name=\"twitter:site\" content=\"@teachersfirst\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Karen Streeter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/\"},\"author\":{\"name\":\"Karen Streeter\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#\\\/schema\\\/person\\\/f97d31c250407f73797f89517064ef5b\"},\"headline\":\"TechBytes: Inserting Images Into Google Spreadsheet Cells\",\"datePublished\":\"2017-02-21T15:01:14+00:00\",\"dateModified\":\"2019-04-05T22:01:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/\"},\"wordCount\":230,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#organization\"},\"keywords\":[\"Google Sheets\",\"Images\",\"Spreadsheets\",\"Tutorial\"],\"articleSection\":[\"TechBytes\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/\",\"url\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/\",\"name\":\"TechBytes: Inserting Images Into Google Spreadsheet Cells - TeachersFirst Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#website\"},\"datePublished\":\"2017-02-21T15:01:14+00:00\",\"dateModified\":\"2019-04-05T22:01:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/2017\\\/02\\\/teachbytes-inserting-images-into-google-spreadsheet-cells\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TechBytes: Inserting Images Into Google Spreadsheet Cells\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/\",\"name\":\"TeachersFirst Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#organization\",\"name\":\"TeachersFirst\",\"url\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/TF_event_listing.gif\",\"contentUrl\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/TF_event_listing.gif\",\"width\":200,\"height\":171,\"caption\":\"TeachersFirst\"},\"image\":{\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/teachersfirst\",\"https:\\\/\\\/x.com\\\/teachersfirst\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/#\\\/schema\\\/person\\\/f97d31c250407f73797f89517064ef5b\",\"name\":\"Karen Streeter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9202d4fea9fd52c7b5981b750893007e4bb6ef1c15dfa12e7777b6658ca7ab06?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9202d4fea9fd52c7b5981b750893007e4bb6ef1c15dfa12e7777b6658ca7ab06?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9202d4fea9fd52c7b5981b750893007e4bb6ef1c15dfa12e7777b6658ca7ab06?s=96&d=mm&r=g\",\"caption\":\"Karen Streeter\"},\"description\":\"Karen Streeter is a former Instructional Technology Supervisor. Karen brings us the Ed Tech Temperature Check - explaining edtech buzzwords, sharing tech tips and tricks, and summarizing books that should be on your edtech shelf.\",\"url\":\"https:\\\/\\\/teachersfirst.org\\\/blog\\\/author\\\/karen\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TechBytes: Inserting Images Into Google Spreadsheet Cells - TeachersFirst Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/","og_locale":"en_US","og_type":"article","og_title":"TechBytes: Inserting Images Into Google Spreadsheet Cells - TeachersFirst Blog","og_description":"Power up your Google Sheets productivity. Watch this episode of TechBytes to learn how to insert images into individual cells in your spreadsheet. Use the =IMAGE function and gain control of images. It is easy and effective. While users have always been able to add images to Google Spreadsheets using the Insert Image menu option, &hellip; read more &raquo;","og_url":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/","og_site_name":"TeachersFirst Blog","article_publisher":"https:\/\/www.facebook.com\/teachersfirst","article_published_time":"2017-02-21T15:01:14+00:00","article_modified_time":"2019-04-05T22:01:45+00:00","author":"Karen Streeter","twitter_card":"summary_large_image","twitter_creator":"@teachersfirst","twitter_site":"@teachersfirst","twitter_misc":{"Written by":"Karen Streeter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/#article","isPartOf":{"@id":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/"},"author":{"name":"Karen Streeter","@id":"https:\/\/teachersfirst.org\/blog\/#\/schema\/person\/f97d31c250407f73797f89517064ef5b"},"headline":"TechBytes: Inserting Images Into Google Spreadsheet Cells","datePublished":"2017-02-21T15:01:14+00:00","dateModified":"2019-04-05T22:01:45+00:00","mainEntityOfPage":{"@id":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/"},"wordCount":230,"commentCount":0,"publisher":{"@id":"https:\/\/teachersfirst.org\/blog\/#organization"},"keywords":["Google Sheets","Images","Spreadsheets","Tutorial"],"articleSection":["TechBytes"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/","url":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/","name":"TechBytes: Inserting Images Into Google Spreadsheet Cells - TeachersFirst Blog","isPartOf":{"@id":"https:\/\/teachersfirst.org\/blog\/#website"},"datePublished":"2017-02-21T15:01:14+00:00","dateModified":"2019-04-05T22:01:45+00:00","breadcrumb":{"@id":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/teachersfirst.org\/blog\/2017\/02\/teachbytes-inserting-images-into-google-spreadsheet-cells\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/teachersfirst.org\/blog\/"},{"@type":"ListItem","position":2,"name":"TechBytes: Inserting Images Into Google Spreadsheet Cells"}]},{"@type":"WebSite","@id":"https:\/\/teachersfirst.org\/blog\/#website","url":"https:\/\/teachersfirst.org\/blog\/","name":"TeachersFirst Blog","description":"","publisher":{"@id":"https:\/\/teachersfirst.org\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teachersfirst.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/teachersfirst.org\/blog\/#organization","name":"TeachersFirst","url":"https:\/\/teachersfirst.org\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/teachersfirst.org\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teachersfirst.org\/blog\/wp-content\/uploads\/2026\/08\/TF_event_listing.gif","contentUrl":"https:\/\/teachersfirst.org\/blog\/wp-content\/uploads\/2026\/08\/TF_event_listing.gif","width":200,"height":171,"caption":"TeachersFirst"},"image":{"@id":"https:\/\/teachersfirst.org\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/teachersfirst","https:\/\/x.com\/teachersfirst"]},{"@type":"Person","@id":"https:\/\/teachersfirst.org\/blog\/#\/schema\/person\/f97d31c250407f73797f89517064ef5b","name":"Karen Streeter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9202d4fea9fd52c7b5981b750893007e4bb6ef1c15dfa12e7777b6658ca7ab06?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9202d4fea9fd52c7b5981b750893007e4bb6ef1c15dfa12e7777b6658ca7ab06?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9202d4fea9fd52c7b5981b750893007e4bb6ef1c15dfa12e7777b6658ca7ab06?s=96&d=mm&r=g","caption":"Karen Streeter"},"description":"Karen Streeter is a former Instructional Technology Supervisor. Karen brings us the Ed Tech Temperature Check - explaining edtech buzzwords, sharing tech tips and tricks, and summarizing books that should be on your edtech shelf.","url":"https:\/\/teachersfirst.org\/blog\/author\/karen\/"}]}},"_links":{"self":[{"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/posts\/719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/comments?post=719"}],"version-history":[{"count":7,"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/posts\/719\/revisions"}],"predecessor-version":[{"id":733,"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/posts\/719\/revisions\/733"}],"wp:attachment":[{"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/media?parent=719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/categories?post=719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teachersfirst.org\/blog\/wp-json\/wp\/v2\/tags?post=719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}