How to Make Product Images with QR Codes from an Excel List
Turn a product spreadsheet into ready-to-post images with ExForms: each row’s photo is pulled from its URL and a scannable QR points to its product page — one image per product.
A product spreadsheet already has everything a marketing image needs: the name, the price, a photo, and a link to the product page. ExForms turns that spreadsheet into the images themselves — one per product, each with the real photo and a scannable QR code that opens its page, ready to add to cart.
You design the layout once by placing fields on a blank canvas (or your own branded background). After that, every row of the sheet becomes a finished image. Ten products or ten thousand, it is the same click.
Placing a QR-code field in the ExForms visual field designer — it encodes each row’s product link.
The quick answer
In the ExForms Excel add-in, start a template from a blank white image and place three fields on it: an image-URL field (ExForms downloads each row’s product photo into the output), a QR-code field (encodes each row’s product-page link), and text fields for name and price. Map them to your product sheet and click Send Data — you get one finished image per product, delivered as a zip. It composes your data onto the canvas; it does not generate artwork.
What You Need
Two things: a product spreadsheet and a background to place the fields on.
No design software and no coding — the layout is drawn visually, once.
Make Product Images from Excel, Step by Step
- Create the template from your background. In the ExForms add-in, upload your background image (or a blank white PNG) as a new template. Image uploads open the visual field placement designer automatically.
- Place the product photo (image-URL field). Draw an image field where the photo should sit. At generation time, ExForms reads that row’s image URL, downloads the picture, and fits it into the field — so each output shows its own product.
- Place the QR code. Draw a QR-code field and point it at your product-page column. Each output gets a scannable QR that opens that exact product; use a discount or add-to-cart link instead if you prefer.
- Add text (name, price, anything). Drop text fields for the name and price, with the font, size, and color you want. Tip: name each field after its Excel column and AutoMap connects everything for you.
- Map and Send Data. Apply Fields, map to your columns (AutoMap or manual), fill or paste your product rows, and click Send Data. Every row becomes a finished image in the Images/ folder of a single zip.
The flat PDFs and images guide covers the designer in detail, and Generate Thousands of Images from Excel Data shows the wider image workflow.
Why a Form Filler Can’t Do This
Mail-merge tools fill Word documents. PDF fillers need a PDF that already has form fields. Neither can take a JPG background, drop in a photo downloaded from a URL, and stamp on a working QR code — that is an image-composition job, and it is exactly what ExForms does by overlaying fields on the picture.
Nothing is generated from scratch: you supply the background and the data, and ExForms lays one on top of the other. Because each QR encodes whatever is in the cell, every image can point somewhere different — a product page, a checkout link, a review form — without redrawing the template.
Where Teams Use This
Product Images with QR Codes: FAQ
Turn your product list into a folder of images
About the Author: Catalin
