How to Auto-Generate Images with Illustrator's Variable Data Feature (CSV Support)

Hi, this is Hoda.

This time I want to introduce one of Illustrator’s handiest features: Variable Data.

It’s a feature that doesn’t get talked about much, even though it’s genuinely useful.

Let me show you quickly what it does. First, you set up a template for your design. Then, when you import text or image data from a CSV, Illustrator generates a design variation for every row in that spreadsheet.

And once you export, it batch-outputs every single variation at once — it’s honestly one of the best hidden features in the app.

In this article, I’ll walk through the basics of Illustrator’s Variable Data feature and how to actually put it to work with a CSV file, in a way that should make sense even if you’re new to it.

I also go through the full walkthrough in this video, so check that out too:

What Variable Data lets you do

At its core, Variable Data lets you take tabular data — like a CSV — and export it straight into images.

The big idea: you build one design, and then swap out just the text and image content across it to generate a whole batch of variations at once.

Example of Variable Data

Another example of Variable Data

This is especially handy any time you need a large batch of designs that all follow the same pattern. A few examples where it’s a great fit:

  • Name badges for a seminar or event (swapping name, company, title)
  • Product images for an e-commerce store (swapping product name, price, image)
  • YouTube thumbnails (swapping title, background image)
  • Templated social media graphics (swapping text, date, category)
  • Study/flashcards (swapping word, meaning, example sentence)

Basically, if the layout stays the same and only the content changes, you can automate almost all of it.

It works with images too

Here’s the more important part: Variable Data isn’t limited to text — it can swap out image files too.

By pointing a CSV column at an image path, Illustrator will automatically swap in the right image, which means you can batch-generate things like product photos or portraits along with everything else.

That cuts down a lot of what used to be manual work:

  • Copy-pasting text
  • Swapping images
  • Nudging the layout to fit

The actual steps

Now let’s go through how to actually use Variable Data.

First, prepare your CSV data. Google Sheets or Excel both work fine.

Windows or Mac both work fine too.

For this article, I’ll be using a Windows PC.

Set up your Illustrator design

First, build out the design in Illustrator.

Just start with a normal default-pattern design, same as you always would.

(I cover this part in more detail in the video.)

Setting up an Illustrator design

Something like this, with parts like:

  • Image
  • Title
  • English name
  • Price
  • Description
  • Ease of care ⭐️⭐️

These are the pieces that will get swapped out by the CSV data. Nothing special going on yet — it’s just a normal base layout built with regular text and images.

Prepare the CSV

Next, build the data table. I’m using Google Sheets here, but Excel works just as well.

Preparing the CSV

Start by defining your columns with a header row, something like:

  • name
  • image
  • price
  • description
  • english
  • level

For images, write the file path on your computer as a relative path.

plaintext
e.g.
G:\variable-test-2026\flags\141-singapore.png

A few things worth keeping in mind here:

  • Keep header names in plain half-width alphanumeric characters (lowercase is recommended)
  • Don’t use spaces in header names (e.g. company_name)
  • Header names must match your Illustrator variable names exactly
  • Save the CSV as UTF-8 (to avoid character-encoding issues)
  • It’s safer to avoid Japanese-language headers
  • Keep image aspect ratios consistent (to avoid layout breakage)
  • If a value in Excel starts with @, prefix it with ' (e.g. '@image)

Once your data is ready, export it as a CSV.

Import the CSV and map your data

Back in Illustrator, click Window > Variables.

That’ll bring up the panel below — click Import and select the CSV you just exported.

Variables

From there, map each piece of data to the right spot. I walk through this part in detail in the video.

Batch-export the images

Finally, you need to actually export all this data. If you tried exporting the normal way, you’d have to do it one variation at a time.

Instead, you can batch-export everything at once using the Actions panel.

Start by opening Window > Actions.

Actions

Create a new action, and Illustrator will start automatically recording whatever you do from that point on. Go ahead and record your export/save settings.

Finally, choose Batch from the panel menu and set up your export options — this will save every variation into the folder you specify.

Batch settings

Batch settings

  • Action: the action you just created
  • Source: Data Sets
  • Destination: check both boxes, and choose your output folder
  • File name: choose “Data set name”

Click OK, and everything will be saved to the folder you selected.