Data-Driven Graphics Using Illustrator’s Variables Panel

March 9th, 2014|0 Comments

Kemie, Thank you for your great tutorial at:

STEP 1. convert excel file to csv

I used a pipe “|” as my csv separator .
using this tutorial is how you can convert an excel (xsl) file into a csv.

STEP 2. create Illustrator XML from csv (use tutorial: )

for: pipe “|” separated values, in the JET_VariablesFTROU.js, change it so it says
var tabChar=”|”;

this is an example of my csv

Dane Smiths|Dane Smiths|429 Charles St #14, Bridgeport, CT 06606
Gail John|Gail John|1768 Monroe St #9b, Evanston, IL 60202
Amanda Gavin|Amanda Gavin|5313 N Taft Ave, Bridgeport, CT 06604

download JET_VariablesFTROU.js :

STEP 3. setup data driven graphics in illustrator and save
The video tutorial of how to setup data driven graphics in illustrator can be found here.

Leave a Comment