---
title: "How to Insert Images in Google Sheets"
url: https://daily.dev/posts/how-to-insert-images-in-google-sheets-lzwd7li9n
source_url: https://www.freecodecamp.org/news/how-to-insert-images-in-google-sheets
type: article
source: "freeCodeCamp"
published: 2026-06-25T00:25:19.161Z
updated: 2026-06-25T00:26:11.611Z
tags: ["google-drive"]
reading_time: 9
upvotes: 1
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Insert Images in Google Sheets

**[freeCodeCamp](https://daily.dev/sources/freecodecamp)** · 9 min read · 1 upvotes · 0 comments

## Summary

Google Sheets offers multiple ways to insert images depending on your use case. Images can be placed inside cells (moves and sorts with data) or over cells (floats freely, good for logos/dashboards). The IMAGE() function displays images from external URLs directly in cells, supporting four display modes and working with ARRAYFORMULA for bulk rows. For large Google Drive image libraries, converting sharing links to direct URLs using a formula or a tool like Drive Explorer Pro is recommended. Key considerations include image permissions, URL format for Drive files, performance with large image sets, and choosing the right method based on scale.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.freecodecamp.org/news/how-to-insert-images-in-google-sheets>

## Similar posts on daily.dev

- [Why Excel Charts and Images Break in Web Spreadsheets and How to Fix Them](https://daily.dev/posts/why-excel-charts-and-images-break-in-web-spreadsheets-and-how-to-fix-them-evohiwpeh) · Syncfusion · 0 upvotes · 0 comments
- [Unlock the power of images with AI Sheets](https://daily.dev/posts/unlock-the-power-of-images-with-ai-sheets-wkbi3kyhn) · Hugging Face · 0 upvotes · 0 comments

---

Tags: [#google-drive](https://daily.dev/tags/google-drive)

[View this post on daily.dev](https://daily.dev/posts/how-to-insert-images-in-google-sheets-lzwd7li9n)