Generate Thousands of Images from Excel Data

If you can photograph it, you can fill it. Generate images from Excel data with ExForms: place fields once on a photo or scan, get one finished image per row.

If you can photograph it, you can fill it. That is how ExForms turns Excel data into finished images. It does not invent a new picture. Instead, it lays your data onto a template you already have. Take a photo, a scan, or even a blank white canvas. Place fields on it once, and every row comes back as a finished image. You get the same format and the same pixel size, ready to send.

So you are overlaying data, not generating art. Drop in text, a checkbox, a QR code, or a Code 128 barcode. You can also add a product photo, pulled live from a URL in your spreadsheet. One row or thousands, the work on your side stays the same.

Placing a QR code field on an image in the ExForms visual field designer

Placing a QR-code field in the ExForms visual field designer.

The quick answer

ExForms turns a photo, scan, or blank canvas into a fill-from-Excel template. First, upload a PNG, JPG, or TIFF, or start from a white image. Then draw fields on it once in the visual designer. Map them to your workbook, and click Send Data. In return, you get one finished image per Excel row, in the same format and pixel size as the template. In other words, it places your data onto the image. It does not generate new imagery.

Why Images Are the Format Nobody Fills

Most mail-merge tools fill Word documents. Plenty of tools fill PDF forms, too, as long as the PDF has form fields. But a picture? A scan of a 1997 intake form, a phone photo of a certificate, a JPG of a badge design? The usual answer is “you can’t fill that, recreate it first.”

Recreating, though, is the step most people never get around to. First, the original file is lost. Besides, the person who designed it left years ago. Or the layout is too fiddly to rebuild in Word.

So ExForms skips the rebuild. It treats your image as the template itself, and nothing is invented. Instead, it lays your spreadsheet values onto the page you gave it. Next, you upload the picture, or a blank canvas, and draw fields on top of it. Then you connect those fields to your live Excel workbook. From then on, Send Data turns each row into a completed image of that exact document. There is no digital original required, and a phone photo is enough. You don’t even need a scanner.

What You Can Fill: A Use-Case Gallery

How It Works, Step by Step

Step 1: Upload the picture (or a blank canvas)

In the ExForms add-in, upload a PNG, JPG, or TIFF. Multi-page TIFF works too. Or start from a plain white image. Image uploads become flat templates automatically. Then the visual field placement designer opens right after a single-file upload. You can reopen it any time from the pushpin icon in Edit Set.

Step 2: Place fields once, by hand

Draw fields where they belong on the page. You get text fields, checkboxes with custom ON values, radio groups, QR codes, and Code 128 barcodes. You can also place per-row images from a URL cell, plus repeating regions for child-table rows. There is no OCR or auto-detection. Placement is manual, but you only do it once. Autosuggest reads nearby labels, and Shift+drag selects several fields at once.

Step 3: Apply Fields and map to Excel

Apply Fields injects the form fields and extends your mapped workbook. Then AutoMap creates a new sheet and table, with one column per field. So if you named your fields after your column headers, mapping is instant. For anything unusual, manual mapping is there too.

Step 4: Fill the table and Send Data

Type or paste your rows, then click Send Data. Every row becomes a finished image, collected in the Images/ folder of a single zip. PNG and JPG templates return one image per row, at the original format and pixel size. A multi-page TIFF template returns one multi-frame TIFF file per row instead.

Re-editing is safe. The designer always restarts from your original picture, so you can adjust positions without degrading the template. For the full reference, see the flat PDFs and images guide and the broader PDF guide.

Case Study: Product Images with Scannable QR Codes

Here is a workflow a form filler cannot do. Say you keep a spreadsheet of products. Each row has a name, a price, an image URL, and a link to that product’s page.

First, start from a blank white canvas, or your own branded background. Then place three kinds of field:

  • an image-URL field for the photo. At generation time, ExForms downloads the picture at that row’s URL and drops it into the output;
  • a QR-code field that encodes the product-page link. So anyone who scans it lands on that product, ready to add to cart;
  • text fields for the name and the price.

Then click Send Data. In return, you get one finished image per product: the real photo, the price, and a working QR to its page. As a result, a hundred products become a hundred ready-to-post images, in one run. For instance, use them for catalog cards, shelf-talkers, social posts, or print sheets.

Because each QR encodes whatever is in the cell, the same set can point every image somewhere different. For example, a product page, a discount landing page, or a review form, without touching the design again. There is a step-by-step in How to Make Product Images with QR Codes from an Excel List.

From One Row to Thousands

The steps above are the same whether your table has one row or thousands. Send Data generates one filled document per Excel row, for every template in the set, in one action. Outputs are named with your naming pattern, sorted into subfolders, and delivered as one zip. Image outputs, in particular, land in an Images/ folder.

A few scale details are worth knowing:

  • Image outputs are the default for image-sourced templates. Still, each file has an Output option, so you can get PDFs for that template instead.
  • Paid plans hold multiple templates per set. So one Send Data run can fill a badge, a certificate, and a product card for every row at once. Free and anonymous accounts are limited to one form per set.
  • Every generated document counts within your plan’s monthly form allowance. See ExForms pricing and add-on packs if you need more capacity.
  • The same generation is available over the REST API. So you can trigger runs from your own systems: ExForms API documentation.

Filling Images from Excel: FAQ

Yes. A phone photo is enough, and you don’t need a scanner. First, upload the photo and place fields on it in the designer. Then ExForms returns filled copies of that photo, one per Excel row, at the same pixel size as the original.

No. There is no OCR or auto-detection. Instead, you draw each field yourself. It is a one-time job per template. Autosuggest and Shift+drag make it quick, and once fields are applied, every future run reuses them.

Text, checkboxes, radio groups, QR codes, and Code 128 barcodes. You can also add image-URL fields, which download a picture per row, plus repeating regions for child-table rows. In other words, most of what a product card or certificate needs.

PNG, JPG, and TIFF go in, including multi-page TIFF. PNG and JPG templates come back as one image per row, in the original format and pixel size. A multi-page TIFF template comes back as one multi-frame TIFF file per row. Everything lands in the zip’s Images/ folder, and a per-file option switches any template to PDF.

No. It is simply what happens when your template started life as an image. Upload the picture, map it, and click Send Data. The output format then follows the input automatically.

Install ExForms from AppSource

One field-placement session from finished images

Have a picture, or a blank canvas, and a spreadsheet of data? Then you are one field-placement session away from finished images. Install ExForms, upload your first photo or scan, and place your fields once.
Install ExForms from AppSource

About the Author: Catalin

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.