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.
In this guide
- What does making versions from a spreadsheet mean?
- Which tool should you use?
- Step 1: Build one master template
- Step 2: Set up a clean spreadsheet
- Step 3: Plan for the longest entry
- Step 4: Run a three-row test
- Step 5: Generate every version
- Step 6: Proof and name the files
- How can AI help?
- What mistakes should you avoid?
- Frequently asked questions
- Related posts
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?
| Tool | Good for | Notes |
|---|---|---|
| Microsoft Word Mail Merge | Letters, labels, simple documents | Found under the Mailings tab; works with Excel or CSV |
| Adobe InDesign Data Merge | Designed print pieces, catalogues, badges | Window › Utilities › Data Merge; can pull in images |
| Canva Bulk Create | Social graphics, certificates, flyers | A paid-plan feature at the time of writing; check your plan |
| Google Docs or Slides | Light jobs inside Google Workspace | Needs an add-on or a short script; an AI assistant can help write one |
| AI assistants (new) | Describing the job in plain English | Adobe 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
Next step: pick one document you make again and again, turn it into a template with three placeholders, and run a three-row test this week. Then read Adobe MAX AI Agents, Gemini 4 Carbon and a Shock Exit at Nvidia: This Week’s AI News to see where Adobe’s AI agents are heading.
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.
Related posts
- Adobe MAX AI Agents, Gemini 4 Carbon and a Shock Exit at Nvidia: This Week’s AI News
- How to Build an Ad Swipe File Your AI Agent Can Actually Use
- How to Make an Animated GIF With AI for Emails and Social Posts
