How to Insert an Image in Google Sheets

Last Modified: January 13, 2024 - 2 min read

Julian Alvarado

TL;DR: Insert images in Google Sheets easily by choosing ‘Insert’ > ‘Image’ > ‘Image in cell’ for cell-bound images, or ‘Image over cells’ for more flexibility. Adjust size and position as needed, and ensure image relevance and quality for best results.

Step 1: Open Your Google Sheet

Begin by opening the Google Sheets document where you want to insert an image.

Step 2: Inserting an Image

Navigate to the cell where you want the image to appear. Click on ‘Insert’ in the menu bar, then select ‘Image’ and choose ‘Image in cell’.

Step 3: Choose Your Image

A dialogue box will appear. You can upload an image from your computer, search the web, use a URL, or select an image from your Google Drive. Choose the method that fits your needs and select your image.

Step 4: Adjusting the Image inside a cell

Once the image is inserted, it will automatically adjust to fit the cell. You can resize the cell to change the image size. If you need to move the image, you can cut and paste the cell to a new location.

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

Alternative Method: Inserting an Image Over Cells

If you want more flexibility in positioning the image, choose ‘Insert’ > ‘Image’ > ‘Image over cells.’ This allows you to place and resize the image anywhere on your sheet without being confined to a cell.

Step 5: Editing the Image

To edit the image (like cropping or adding borders), you’ll need to insert it ‘over cells.’ Once inserted, click on the image and use the toolbar options to edit.

Tips for Using Images in Google Sheets:

  1. Image Quality: Use high-resolution images to ensure they appear clear and not pixelated when resized.
  2. Relevance: Ensure the images are relevant to your data. Decorative images should not distract from the information.
  3. Consistency: If using multiple images, maintain consistency in style and size for a professional look.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies