Microsoft Excel To Adobe Illustrator | Part 02 | Binding CSV Data string with Adobe illustrator

This Step by Step Tutorial I shows  you guys how to use the Variable data from a CSV file and import and use Dynamic external Data in Adobe Illustrator. Also I show you how to create simple actions and automate the process. Also You will be learning How to Design a Simple Business Cards & Office ID in Adobe illustrator as well

What You will be Learning :
Importing Dynamic Data From Microsoft Excel in to Adobe Illustrator
Creating Office Name Cards with Dynamic Data
How to Create a CSV file with Excel & connect it with Adobe Illustrator Variables
Using Automated Actions in Adobe Illustrator
Controlling visibility inside illustrator with CSV files
Importing Image links in to illustrator with CSV files
Creating Dynamic Graphs in illustrator with CSV Data

[digitalartist]

Thanks, nobody else makes these types of tutorials.

[gkssbqh]

Hello, it doesn't work on my Illustrator

[silehv]

Hi there! Great tutorial!!! Really useful stuff. I am now wondering if it is possible to take it to the next level, which would be really helpful to me. In my case, I have to populate around 200 textboxes in the same document with data from Excel sheet and repeat this in several documents. So, let's say in Excel I have one column with the name (100 names) and one column with their nationality (100 nationalities). I would like then to fill in 200 textboxes with the name and nationality of the 100 people. Is this possible in any way? Thank you so much for your content!

[gustisna]

phew! you are a lifesaver sir! thanks a lot for the tutorial

[Nick_NickH]

Hello,

This is a brilliant video; really helpful. I have a quick question about variables which hopefully you may know the answer to!

Do you know if you can use variables with multipage PDFs on Illustrator?

At the moment I can only get variables to import single-page PDFs, it will not work with multipage ones? It just comes back with errors and does not import the file.

Thanks.

[rakitipakiti]

do you do personal sessions? im interested in hiring you to fix a problem.

[silhy]

Do you know if there's a way to export the data base that allows to use accents in spanish, i.e. "ó" "é", etc.?

[kazishahin]

Bangla Font Not should i do?....please explain

[abeerworld-abby]

hi just came across your video thanks for sharing, can you please make a video on how to copy-paste data entry work from adobe illustrator to excel? or convert adobe illustrator to excel (but data entry work is in adobe illustrator) and I want to move it to excel. thank you

[madebymarco]

How do I save using the Layer or Text name?

[sajjadurrahman]

Hi, I use illustrator CS6, do you think it works with csv file ? or xml only ? any idea ?