How to create many images from a spreadsheet?

Published March 22, 20222 min read

How to create many images from a spreadsheet?

In this blog post I will present you how to quickly generate many images for an online session, video course or a conference. I will use Bannerly to create a template, load data from a spreadsheet and generate images.

Create a template

I used a predefined template from 'Templates' tab and adjusted it to my needs. Bannerly offers a great number of templates in many categories. You can also create your own templates from scratch with an easy-to-use template editor.

In this blog post I will modify texts in two places and change the image (you can see component names on the left side panel).

  • author_photo - author image on the right side,
  • author_name - author name under the image,
  • title - session title.

template in canvas editor for marketing automation

Create a spreadsheet

I created a spreadsheet in Numbers, which is a default spreadsheet app for macOS, but you can use Excel or any other spreadsheet program.

In the first row, I put component names with properties I wanted to change, and separated them with a dot.

Property is a variable of component that you want to modify, for example, text, source url, background color or opacity. Check our docs for more details about components and their properties. Here is my sample spreadsheet:

  • author_photo.src - change image source of author_photo component,
  • author_name.text - change text of author_name component,
  • title.text - change text of title component.

data in spreadsheet

Generate images

Now, head to the 'Extensions' tab in Bannerly and open 'Spreadsheet' extension. Import created spreadsheet using 'Import from file' button, and select the template you want to use on left side.

bannerly extensions

If all properties are loaded properly in your file (they must correspond to your selected template), you are ready to start a generation. To start generating images click 'Generate' button on top of the list, and do not close the window until the generation process is completed.

list with generated images in spreadsheet extension

Once the generation is done, you will be able to download the images using 'Download' button.

generated images from template for marketing automation

With 'Spreadsheet' extension you are able to quickly generate multiple images with one template and customized content. With image generation and simple image editor, you can create images, post covers or marketing brochures, that match your company, website or app unique style!


Share article

Relevant posts

Send Personalized Emails with Mailchimp in 3 minutes

Send Personalized Emails with Mailchimp in 3 minutes

Kinga WojciechowskabyKingaDecember 10, 2021

Personalized images are a powerful way to connect with your customers on a personal level. Check how you can create outstanding personalized images and how to use them in your Mailchimp email campaigns.

Read more
Image Generation with Integromat

Image Generation with Integromat

Jakub PomykałabyJakubDecember 08, 2021

Automate image generation using Make.com. Create images using your templates, or take website screenshot with Make.com.

Read more
Image Generation with Zapier

Image Generation with Zapier

Jakub PomykałabyJakubDecember 07, 2021

Automate image generation using Zapier. Create images using your templates, or take website screenshot with Zapier.

Read more
iMessage Link Preview Tool

iMessage Link Preview Tool

Kinga WojciechowskabyKingaDecember 06, 2021

Try out how your product links look like when shared on iMessage. Check our free online link preview tool and see the results of your link sharing details.

Read more
What is Image Generation?

What is Image Generation?

Jakub PomykałabyJakubNovember 29, 2021

Generate images using REST API, Zapier, Integromat, Google Sheets, and more!

Read more
What is Bannerly?

What is Bannerly?

Jakub PomykałabyJakubNovember 29, 2021

Learn more about Bannerly, its features and how you can scale your designs with external tools like Zapier and Integromat.

Read more

Design. Automate. Scale.

Free plan • No credit card required • Get started in minutes