Images in PPTX Template

Learn how to dynamically replace images in your PowerPoint templates using placeholders.

Replacing Images

You can replace images in your PowerPoint template by using placeholders that reference image URLs or file paths in your data source.

How It Works

  1. Insert an image placeholder in your PowerPoint template
  2. Set the image's alternative text (Alt-text) to the placeholder expression
  3. Provide image URLs or paths in your data source
  4. During merging, images will be downloaded and inserted into the presentation

Syntax

You can use two syntaxes for image placeholders:

Simple syntax:

  • Set Alt-text to: {{profile_picture}}

Explicit syntax:

  • Set Alt-text to: {{type=image data=profile_picture}}

Both syntaxes work the same way. The explicit syntax allows for future extensions.

Example

Template:

  • Insert any image as a placeholder
  • Right-click the image → Format Picture → Alt Text
  • Set the Description field to: {{profile_picture}} or {{type=image data=profile_picture}}

Sample PowerPoint template with image placeholder

Data:

{
  "profile_picture": "https://example.com/photos/john-doe.jpg",
  "logo_url": "https://example.com/logo.png"
}

Result:

  • The placeholder image will be replaced with the image from the URL

Excel Embedded Images

There are two ways to replaced images based on data in the Excel file:

  1. The first method requires a publicly facing internet storage of the image(s) - just list those addresses as values in one of the columns (like "profile_photo") and reference it in your PowerPoint template in the alt-text of a placeholder image. This method is recommended for large number of images.

Sample Excel data:

firstName lastName profile_photo
Jane Austin https://example.com/jane.jpg
John Goodman https://example.com/john.jpg
Steven Wozniak https://example.com/steven.jpg

Then, in your PowerPoint template you reference the column containing the image URLS as follows (you put this value into the alt-text of the placeholder image):

  • {{profile_photo}} - this will be useful when you repeat slides for each record in the Excel data file
  • {{type=image data=profile_photo}} - this one's a more verbose version of the first one - it's more explicit and allows for future extensions
  • {{xlsx.Sheet1!A1}} - this last one is a special syntax for Excel addressing - it references the cell containing the image URL
  1. The second method is available for Excel data files which can contain images.

Here are the steps to use Excel embedded images in PowerPoint:

2.1. Inside the Excel file, define a column for the images (e.g., "profile_photo").

2.2. Insert the images somewhere in the Excel file (use the "Insert" → "Picture" function from the Excel ribbon).

2.3. Open the menu for the image (right-click or press "Shift+F10") and select "View alt-text".

2.4. Type a unique name into the alt-text for each embedded image (e.g., "jane").

2.5. Update the "profile_photo" column for Jane's record to contain the value "jane".

2.6. Reference the column containing the images in the PowerPoint template as you would in method 1 (insert {{profile_photo}} in the alt-text of the placeholder image you added to the template).

Take a look at the following video for more details (enable captions for best experience):

See also a blog post with example on how to use this feature in project status reports: Generate project status PowerPoint from Excel with images (Fast & Easy)

Supported Image Formats

  • JPEG (.jpg, .jpeg)
  • PNG (.png)
  • GIF (.gif)
  • BMP (.bmp)

Image Properties Preserved

The following properties of the placeholder image are preserved:

  • Position and size
  • Rotation
  • Border and effects
  • Alignment

Best Practices

1. Use Consistent Image Sizes

If possible, use images with similar dimensions to ensure consistent appearance across slides.

2. Optimize Image URLs

  • Use HTTPS URLs for security
  • Ensure images are publicly accessible (e.g. you can use publicly available data storage platforms like Google Drive, MS ONe Drive, Dropbox, etc. or place them in four CMS like Wordpress or directly available on your website). If you use a storage platform like the ones mentioned make sure you obtain a proper link to the image and NOT an page displaying the image (if you link the page our service will not download the image as it will see the content as HTML page).

3. Handle Missing Images

If an image URL is invalid or inaccessible:

  • The placeholder image will not be replaced

Why an image cannot be accessed? Possible reasons:

  • Access requires authentication (e.g. you need to be logged in to the service which hosts the image)
  • The service which hosts the image does not allow access / download by other means than the browser
  • The service which hosts the image requires additional data (e.g. cookies) to be sent in the request to the image URL.
  • The image URL is incorrect or invalid
  • If you use the Excel embedded images method, make sure you have set the Alt text of the image(s) in the Excel file in proper column.

4. Image Naming

Use descriptive placeholder names:

  • {{employee_photo}} or {{type=image data=employee_photo}}
  • {{product_image}} or {{type=image data=product_image}}
  • {{company_logo}} or {{type=image data=company_logo}}

Common Use Cases

Employee Photos

{
  "name": "John Doe",
  "photo": "https://example.com/employees/john-doe.jpg"
}

Product Images

{
  "product_name": "Widget A",
  "image_url": "https://example.com/products/widget-a.jpg"
}

Company Logos

{
  "company": "Acme Corp",
  "logo": "https://example.com/logos/acme.png"
}

Troubleshooting

Image Not Loading

  • Check URL: Verify the image URL is correct and accessible
  • Check Format: Ensure the image format is supported
  • Check Permissions: Make sure the image is publicly accessible (not behind authentication). TIP: check in incognito / private mode of your browser to verify that the image is publicly available and does not require authentication.
  • Check Excel embedded images: If you use the Excel embedded images method, make sure you have set the Alt text of the image(s) in the Excel file in proper column and the values in the column match those in the alt-text of the embedded image(s).

Image Size Issues

  • Too Large: Images may be scaled down to fit the placeholder
  • Too Small: Images may be stretched to fill the placeholder

Performance

  • Large images may slow down the merge process
  • Consider optimizing images before uploading
  • Use appropriate image dimensions for presentations