Oil painting of one master poster fanning out into a dozen colour variants in plum, raspberry and blush, linked by threads to a small data table card

Quick answer

To make many versions of one document from a spreadsheet, design a single master template with placeholders, put one row per version and one column per field in a spreadsheet saved as CSV, then use a data merge tool to fill the template once for every row. InDesign Data Merge, Word Mail Merge and Canva’s Bulk Create all do this today, and the new AI assistants shown at Adobe MAX can set it up from a plain-English request. Always run a three-row test before you generate the lot.

Key takeaways

  • One template, one spreadsheet, many outputs. Certificates, name badges, local flyers, product cards and personalised letters all work this way.
  • Your spreadsheet does most of the work. Clear headers and clean data matter more than the tool.
  • Design for the longest entry, not the average one.
  • Test with three rows first, then proof a sample of the final set.

This guide follows on from our news roundup Adobe MAX AI Agents, Gemini 4 Carbon and a Shock Exit at Nvidia: This Week’s AI News. One of the Adobe MAX demos showed someone asking InDesign’s new assistant to create 50 versions of a document using an attached CSV file. You do not need to wait for that feature to reach you, as the same idea works with tools you may already have.

📘 Main article: See the Adobe MAX AI agents, Gemini 4 Carbon and the rest of this week’s AI news in Adobe MAX AI Agents, Gemini 4 Carbon and a Shock Exit at Nvidia: This Week’s AI News.

What does making versions from a spreadsheet mean?

It means the layout stays the same while the words, numbers or images change for each version. Each row in your spreadsheet becomes one finished document. A row might hold a customer’s name, a town, a price and an image file, and the tool drops those into the matching spots in your design.

Typical small-business uses include event certificates, local flyers with different addresses, product sheets, staff badges, personalised offer cards and social graphics for several locations.

Which tool should you use?

ToolGood forNotes
Microsoft Word Mail MergeLetters, labels, simple documentsFound under the Mailings tab; works with Excel or CSV
Adobe InDesign Data MergeDesigned print pieces, catalogues, badgesWindow › Utilities › Data Merge; can pull in images
Canva Bulk CreateSocial graphics, certificates, flyersA paid-plan feature at the time of writing; check your plan
Google Docs or SlidesLight jobs inside Google WorkspaceNeeds an add-on or a short script; an AI assistant can help write one
AI assistants (new)Describing the job in plain EnglishAdobe showed this at MAX; check results carefully

If you already pay for one of these, start there. Pick the tool based on where the finished file needs to end up, such as print, email or social.

Step 1: Build one master template

Design one version properly, then replace the changing parts with placeholders. Give each placeholder the same name as the spreadsheet column it will come from, such as FirstName, Town or Price.

  • Keep fixed text, logos and layout in the template
  • Use text boxes with room to grow
  • Give images a fixed frame size so every picture fits the same space

Step 2: Set up a clean spreadsheet

Put one version per row and one field per column, with short, clear headers in the first row. Then:

  • Remove empty rows and stray spaces
  • Keep the same format in each column, such as all prices as £12.00
  • For images, add a column with the file name or path, and keep the images in one folder
  • Add a FileName column if you want each output named neatly
  • Save as CSV UTF-8 so £ signs, accents and apostrophes survive

💡 Tip: Ask an AI assistant to tidy the sheet for you: “Clean this list for a mail merge. One row per person, trim spaces, format prices as £0.00 and flag any rows with missing fields.” Then check the result with our guide on how to check an AI-made spreadsheet.

Step 3: Plan for the longest entry

Find the longest name, address or headline in your data and test the template with it. A layout that looks perfect with “Sam” can break with “Alexandra Montgomery-Smith”. Either allow more space, reduce the font size for that box, or set a character limit and shorten long entries in the sheet.

Step 4: Run a three-row test

Before you make hundreds of files, merge just three rows: a short one, a long one and one with an unusual character. Check spelling, line breaks, image fit and that the right data landed in the right place. Fixing one template is quick; fixing 200 finished files is not.

Step 5: Generate every version

Once the test looks right, run the merge for every row. Most tools let you create one document with many pages or many separate files. For print, one file is often easier; for emailing or uploading, separate files are usually better.

Step 6: Proof and name the files

Open a random sample, about one in ten, plus the first and last versions, and check them properly. Then name the files using your FileName column, such as certificate-alex-smith.pdf, so they are easy to find and send.

⚠️ Warning: If the spreadsheet holds personal data, such as names and addresses, store it securely, share it only with tools and people who need it, and delete working copies when the job is done.

How can AI help?

AI is most useful at the edges: preparing the data, writing the copy and setting up the merge. For example, you can ask an AI assistant to:

  • Clean and standardise your spreadsheet
  • Write a short, different headline for each location or product
  • Write a small script to merge a Google Slides template with a sheet
  • Suggest a character limit that fits your design

Assistants built into design apps, like the ones Adobe showed at MAX, may soon handle the whole process from one request. Even then, run the same three-row test and proof a sample, because the AI does not know your brand or customers as well as you do. For keeping designs consistent, our guide on locking a design system before your AI agent writes code covers the same principle from a different angle.

What mistakes should you avoid?

  • Headers in the spreadsheet that do not match the placeholder names
  • Merged cells, notes or totals rows left in the data
  • Images with very different shapes squashed into one frame
  • Skipping the test and finding a typo on 300 printed copies
  • Forgetting to check the last few rows, where stray data often hides

Frequently asked questions

What is data merge?

A feature that fills a template with information from a spreadsheet, creating one version for each row. Word calls it Mail Merge, InDesign calls it Data Merge and Canva calls it Bulk Create.

Do I need Adobe InDesign to do this?

No. Word, Canva and Google Workspace can all do it, with varying levels of design control. InDesign suits detailed print layouts.

Can I include a different image in each version?

Yes, in InDesign and Canva. Add a column with each image’s file name and keep all the images in one folder or uploaded to the tool.

Why do my £ signs turn into strange characters?

The CSV was saved in the wrong text format. Save it as CSV UTF-8 and merge again.

author avatar
Garry Knight
I'm Garry Knight, the person behind Prodify Digital. I write about email list building, email marketing, SEO, AI search and the tools that connect them. My aim is to make online marketing easier to understand, so creators and small business owners can make informed decisions about building an audience and keeping people engaged. Here you'll find straightforward guides and product reviews that explain what something does, where it fits and which limitations matter. The focus is on clear explanations and useful next steps—not hype, shortcuts or promises of easy earnings.

Leave a Reply