{"id":52345,"date":"2025-02-27T20:57:30","date_gmt":"2025-02-27T19:57:30","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=52345"},"modified":"2025-06-03T22:08:18","modified_gmt":"2025-06-03T20:08:18","slug":"previsualisation-dimages-en-ligne-feuilles-de-calcul","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/inline-image-previews-spreadsheets\/","title":{"rendered":"Automatiser les aper\u00e7us d'images en ligne dans votre feuille de calcul"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ theme_builder_area=”post_content” _builder_version=”4.27.2″ _module_preset=”default”][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_column _builder_version=”4.27.2″ _module_preset=”default” type=”4_4″ theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

Managing visual data alongside text records can be tricky\u2014especially when working with images stored in Google Drive. If your spreadsheet lists <\/span>image file names in Column A<\/b> and their <\/span>Google Drive URLs in Column B<\/b>, you can automate inline previews directly in your sheet. Here\u2019s how.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

The setup<\/b><\/h2>\n

Let\u2019s say you have a structured spreadsheet:<\/span><\/p>\n

    \n
  • Column A<\/b> \u2013 The exact file name of each image (matching its Google Drive name).<\/span><\/li>\n
  • Column B<\/b> \u2013 The full Google Drive URL of each image.<\/span><\/li>\n<\/ul>\n

    Instead of manually clicking each URL, you can automate image previews using a simple <\/span>Google Sheets formula<\/b> that combines the <\/span>IMAGE<\/span> function and <\/span>REGEXEXTRACT<\/span>.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

    How to enable inline image previews<\/b><\/h2>\n

    1. Set up your spreadsheet<\/b><\/h3>\n

    Make sure your spreadsheet follows this structure:<\/span><\/p>\n

    <\/span><\/p>\n\n\n\n\n
    \n

    File Name\u00a0<\/span><\/p>\n<\/td>\n

    		\n

    Google Drive URL\u00a0<\/span><\/p>\n<\/td>\n

    		\n

    Image Preview\u00a0<\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    image1.jpg<\/span><\/p>\n<\/td>\n

    		\n

    https:\/\/drive.google.com\/file\/d\/xyz123\/view<\/span><\/p>\n<\/td>\n

    		\n

    (will display image preview)<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

    2. Extract the image id from Google Drive URLs<\/b><\/h3>\n

    Google Drive URLs contain a <\/span>unique image ID<\/b>, which you need to extract for embedding. The standard format for displaying an image looks like this:<\/span><\/p>\n

    \n<\/h2>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″ module_class=”spreadsheet-function”]

    =IMAGE(“https:\/\/drive.google.com\/uc?id=image-id”)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

    3. Automate image extraction with REGEX<\/b><\/h3>\n

    Since Column B contains the full URL, you can use the <\/span>REGEXEXTRACT<\/span> function to isolate the image ID automatically. In Column C, enter this formula:<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″ module_class=”spreadsheet-function”]

    =IMAGE(“https:\/\/drive.google.com\/uc?id=”&REGEXEXTRACT($B$2,”d\/([a-zA-Z0-9_-]+)”))<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

    How this works:<\/b><\/h4>\n
      \n
    • IMAGE<\/b> \u2013 Displays an image from a URL directly in a cell.<\/span><\/li>\n
    • REGEXEXTRACT(B2, “d\/([a-zA-Z0-9_-]+)”)<\/b> \u2013 Extracts the unique image ID from the URL in Column B.<\/span><\/li>\n
    • &<\/b> (concatenation)<\/b> \u2013 Joins the extracted ID with the <\/span>IMAGE<\/span> function\u2019s required URL format.<\/span><\/li>\n<\/ul>\n

      Here\u2019s the final result :\u00a0<\/span>
      <\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2025\/02\/automate_inline_images_in_spreadsheets_1.webp” _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” alt=”automate inline images in spreadsheets 1″ title_text=”automate_inline_images_in_spreadsheets_1″ hover_enabled=”0″ sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

      Why this matters<\/b><\/h2>\n

      By automating image previews, you <\/span>save time<\/b>, <\/span>reduce errors<\/b>, and create a more streamlined workflow. This method is perfect for managing <\/span>large datasets<\/b> efficiently\u2014helping you focus on insights instead of manual tasks.<\/span><\/p>\n

      Start automating today for a smoother, smarter spreadsheet experience!<\/b><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

      Managing visual data alongside text records can be tricky\u2014especially when working with images stored in Google Drive. If your spreadsheet lists image file names in Column A and their Google Drive URLs in Column B, you can automate inline previews directly in your sheet. Here\u2019s how.The setup Let\u2019s say you have a structured spreadsheet: Column […]<\/p>\n","protected":false},"author":48,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-52345","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=52345"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52345\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=52345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=52345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=52345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}