3 effective ways to insert images into Excel cells

Have you ever wanted to enrich your Excel spreadsheets with visual elements inserted directly into cells? Until recently, inserting images into Excel cells seemed an impossible task. Traditionally, Excel only allowed text, numbers, dates, boolean values, and errors to be managed within cells. Images could be positioned above cells, but not inserted as actual cell content. Fortunately, Microsoft has introduced new features that finally allow images to be embedded directly into cells, transforming them into a data type in their own right. In this article, we will explore three effective methods for inserting images into Excel cells, offering solutions suitable for different needs and skill levels.

Method 1: Use geospatial data types

The first approach to inserting images into Excel cells utilizes geospatial data types, a feature that allows simple text to be transformed into data rich with information from the web.

What are geospatial data types

Geospatial data types represent a special category of data in Excel that allows names of places (like countries, states, or provinces) to be linked to additional information available online. When you convert text into a geospatial data type, Excel automatically connects to online databases to retrieve related information such as population, capital, flag, and other relevant data.

These data types are particularly useful when you work with lists of geographical locations and wish to enrich your spreadsheet with visual information like national flags. The distinctive feature of data types is their ability to contain multiple pieces of information within a single cell, including images.

How to convert text to a geospatial data type

To transform a simple list of geographical names into data types that include images, follow these steps:

1. Enter the names of countries, states, or provinces in a column of your spreadsheet
2. Select all cells containing the geographical names
3. Go to theDatatab in the Excel ribbon
4. Find theData Typesgroup and click theGeography

button
Once this is done, you will notice a small map-like icon appear next to each geographical name. This icon indicates that the cell no longer contains simple text, but a complete geospatial data type. When you click on this icon, an information card will open showing all the data associated with that location, including a flag image at the top of the card.

How to extract the flag image into the cell

After converting the names to geospatial data types, you can extract the flag image directly into an adjacent cell:

1. Select all cells containing the geospatial data types
2. Click theExtractbutton that appears in the upper right corner of the selection
3. Select theImageoption from the dropdown menu

Excel will automatically insert the flag images into the adjacent cells. If you look at the formula bar, you will notice that it is actually a formula using dot notation, for example, `[CellWithGeoDataType].Image`. This formula refers to the cell containing the geospatial data type and specifically extracts its image attribute.

A useful tip: you can copy these cells containing the images and paste them as values elsewhere. This way, the images will no longer be linked to the original data types, and you can manipulate them independently.
=B2.Immagine

Method 2: Create organizational data types with Power BI

If you need to insert custom images into Excel cells, geospatial data types might not be sufficient. In this case, you can create custom organizational data types using Power BI.

Requirements for Organizational Data Types

Before you begin, it’s important to know that this feature requires:

• A Power BI Pro license
• A data table containing image URLs
• Access to Power BI Desktop and the Power BI online service

This method is particularly useful for organizations that want to create product catalogs, employee lists with photos, or any other dataset that would benefit from the inclusion of custom images.

Creating an Organizational Data Type in Power BI

To create an organizational data type with images, follow these steps:

1. Open Power BI Desktop
2. Import the data table that contains the image URLs (it can come from Excel or other sources)
3. Switch to theModel
4. view. Select the imported table.
5. In theProperties pane, set theIs featured table option toYes.
6. Add aDescriptionfor the table.
7. Select a column as theRow label (this will be the text displayed in the Excel cell).
8. Select a column as theKey column (it must be a unique identifier).

Next, you need to configure the column that contains the image URLs:

1. Switch to theData
2. Select the column containing the image URLs
3. Go to the Column tools
4. Set the Data category to Image URL

Finally, you need to publish the dataset to Power BI online:

1. Go to the Home
2. tab. Click the Publish
3. button. Select a workspace (important: do not use My workspace)
4. . Click Select

Using organizational data type in Excel

Once the dataset is published, you can use the new organizational data type in Excel:

1. Make sure Excel is connected to the same Microsoft account used for Power BI
2. Enter some values corresponding to the Row label column of your dataset
3. Select these cells
4. Go to the Data
5. tab. Expand the Data type
6. menu. Search for your custom data type in the From your organization

After converting the values to the custom data type, you can extract the images in the same way described for geographic data types. The resulting formula will be similar to =B2.Immagine, where “Image” corresponds to the name of the column configured as an image URL.

Method 3: Use the IMAGE function

If the previous methods seem too complex or not suitable for your needs, Excel offers a more direct alternative: the IMAGE function. This function allows you to insert an image directly into a cell by specifying the image URL.

IMAGE function syntax

The IMAGE function has the following syntax:

=IMAGE(url, testo_alt, dimensionamento, altezza, larghezza)

Where:

• urlis the web address of the image (required argument)
• testo_altis alternative text for accessibility (optional argument)
• dimensionamentodetermines how the image fits the cell (optional argument)
  • 0fits the image to the cell while maintaining its aspect ratio (default)
  • 1fills the cell, ignoring the image’s aspect ratio
  • 2maintains the original size of the image
  • 3allows you to specify custom dimensions
• altezzaspecifies the height of the image (required when fit = 3)
• larghezzaspecifies the width of the image (required when fit = 3)

Examples of using the IMAGE function

Here are some practical examples of how to use the IMAGE function:

1. Insert an image maintaining the aspect ratio:

=IMAGE("https://esempio.com/immagine.jpg")

1. Insert an image with alternative text:

=IMAGE("https://esempio.com/logo.png", "Logo aziendale")

1. Insert an image with custom dimensions:

=IMAGE("https://esempio.com/foto.jpg", "Foto prodotto", 3, 100, 150)

The image URL can be entered directly as a text string or can refer to a cell containing the web address.

Tips for using IMAGE

To get the best results with the IMAGE function, consider these tips:

• You can use cloud storage services like OneDrive or SharePoint to host your images and obtain accessible URLs
• When sharing a OneDrive file, make sure to set the access to “Anyone with the link” to ensure the image is visible
• To resize the cell containing the image, you can adjust the row height or column width
• If the image appears too large or too small, try using the dimensionamento argument to control how it is displayed

The IMAGE function is the most direct and flexible method for inserting images into Excel cells, without requiring complex configurations or additional licenses.

Comparison of the three methods

To help you choose the method that best suits your needs, here is a comparison table

Conclusions

Inserting images into Excel cells represents a significant step forward in data visualization and the creation of more communicative spreadsheets. The three methods presented offer solutions for different needs:

1. The geographic data types are perfect for those working with data related to countries, states, or provinces and wanting to quickly display the corresponding flags.
2. The organizational data types offer an advanced solution for companies that need product catalogs or directories with custom images.
3. The IMAGE function represents the most direct and versatile approach, ideal for most users who simply want to insert images into their cells.

Regardless of the chosen method, adding images to Excel cells can significantly transform your spreadsheets, making them more informative, engaging, and visually appealing. Experiment with these methods and discover how visual elements can enhance the communication of your data!