Using Variable Data Merge in Adobe Illustrator

[@GDHT]

Learn how to ETHICALLY get Adobe CC free (or cheap) here: kzbin.info/www/bejne/b5OVo5-JaMmGoLM

[@cms4Lena]

Hi! I cannot load my variables in csv- format, apparently of older version of Ai and it demands XML. How do I do XML that Ai would except? Could be possible to add csv-format in this load? Can you give me any advise?

[@KevBotWorkshop]

You're an MVP for this.. Is there a way to independently edit? When you resized it, it resized on all of them... what if you wanted it resized on just one of them

[@GDHT]

You're welcome - I'm so happy to hear that!! In that case, when you're setting up the action, do a Save As function like AI or EPS, then export. After you do that, you can open one of the files and make changes without affecting the others.

[@marcolucadano7410]

Anne, this is the the best tutorial on how to use variable data in Illustrator! Thank you, thank you! What a difference when a seasoned graphic designer brings her talents, this was so easy to follow and worked like a charm on the 1st try. I am soooo glad I found your channel. Thanks again!

[@GDHT]

Thank you so much!! I'm so glad it was helpful!

[@beaktama222]

thank you so much for the batch saving part. I was reading and watching so many tuts on batch saving and none of them actually explained it properly! lifesaver!

[@GDHT]

You're welcome..and thank you so much!!

[@temitopeaileru6028]

I've really suffered designing certificates before finally seeing this tutorial. Thank you.

[@GDHT]

You're welcome - and thank you so much!

[@hasankelepir]

Anne, this has been the most useful tip I've ever learnt about Illustrator. I used to produce the files in Illustrator, paste them in Word and then use the Mailing function to add variables. Thank you for your share!

[@GDHT]

You're welcome - I'm so happy it was helpful! Doing that with Word sounds tedious... :D

[@ketojake5864]

@@GDHT This is great. I have all my settings the same and even renamed my datasets, but when I choose "File Name + Dataset" it just keeps overriding as "filename_01". Any recommendations?

[@GRANITE-EDUCATION]

So glad someone did a video on variables, this is so cool!

[@GDHT]

Thank you! I'm glad you liked it!

[@sarajitsil]

Very helpful tutorial. Thanks for making it. I am your new subscriber now.

[@GDHT]

You're welcome! And thank you so much!!

[@Chris-lx4un]

you have no idea how much time you just saved me. thanks! ♥️♥️

[@GDHT]

I'm so glad - that's great!!

[@RedFalconInk]

This was a great help with one of our projects, thanks so much!

[@GDHT]

You're welcome - I'm so glad it helped!

[@glitzyprints5459]

Yours was the third tutorial I watched on this and the only one I could get to actually work- thank you so much!!

[@GDHT]

That's great to hear!! Thank you!

[@DiegoPatitucci]

Really useful, thanks!

[@GDHT]

You're welcome! I'm glad it was helpful!

[@freddybluejay]

You just saved me four hours of work!

[@GDHT]

Awesome - that is great to hear!!

[@augustszarins8636]

Thanks, you're a lifesaver

[@GDHT]

You're welcome!!

[@dklectronics4190]

Thank you so much!

[@GDHT]

You're welcome!

[@josetbay]

It worked great... Thanks.. 😇

[@GDHT]

You're welcome!

[@GhostBoy-dp3ck]

wow Anne. for years i have been doing this the hard way. thank you . new subie

[@GDHT]

You're welcome!! And thank you so much for the sub!

[@josephfconti]

What an incredibly useful feature. Thanks for sharing!

[@GDHT]

You're welcome!! :)

[@deploylearning]

Great video! Super easy to follow. Thanks!

[@GDHT]

You're welcome - I'm so glad it was helpful!!

[@jasminelarend]

THANK YOU SO MUCH!

[@GDHT]

You're welcome!

[@desanisful]

Love you, saved me about an hour of my life, AWESOMEEEE

[@GDHT]

That is great to hear - thank you!!

[@suryagraphic5289]

THANK YOU SOOO MUCH, I WAS HAVING HARD TIME SOLFING THE CSV FILE PROBLEM, OMG THAK YOU

[@GDHT]

You're welcome - I'm so happy it helped!!

Thanks for sharing

[@GDHT]

You're welcome!

[@calinflorea7172]

outstanding.

[@GDHT]

Thank you!!

[@colosuss3208]

Tqsm this is easier than i thought!

[@GDHT]

You're welcome!

[@carasembor6661]

THANK YOU SOOOO MUCHHH!!!

[@GDHT]

You're welcome!!

[@tonnatang]

It's the best tutorial i found about variable data. This video saved me tons of time. I have one question. Is there anyway we can change the name of the data set? Otherwise, all exported files are named data set 1, data set 2..... Can we define the name of all data set by the data in variable1?

[@GDHT]

Hmmm, I'm not sure about that. I don't think Illustrator has a way of doing it. You could try a renaming program.

[@diagmaphoto]

thank you. this is the best tutorial. easy to practice.

[@GDHT]

You're welcome!

[@renettahill2816]

Super Helpful... Thanks so much!

[@GDHT]

You'e welcome!! :) I'm so glad it was helpful!

[@touhamimohamed8648]

think you very mucheeeee!!!

[@GDHT]

You're welcome!

[@luaydesign]

You help me a lot, thank you so much.

[@GDHT]

You're welcome - I'm so glad to hear that!!

[@imperials5507]

SUPER HELPFUL! thank you so much!

[@GDHT]

You're welcome! And thank you!!

[@nmgferreira]

Thank you for sharing. It worked fine for me.

[@GDHT]

You're welcome - Great to hear!

[@febrybuw]

Thanks for the video. Subscribed!

[@GDHT]

Thank you so much!!

[@MTouseefKhaleel]

Instead of saving as separate pdf, Is it possible to import all variable as separate artboards in one file?.

[@GDHT]

I don't think so, but InDesign has a way of putting them on one page.

[@sp0013]

Amazing, thanks !!!!

[@GDHT]

You're welcome...and thank you!

[@ivanchairez336]

Thank you for sharing

[@GDHT]

You're welcome!

[@niallolaoghaire9493]

Hi Anne, thank you very much for this video. Do you have any info on how make this method work with graphs in Illustrator?

[@GDHT]

Unfortunately I don't, but I do think it can be done - I googled 'variable data graphs illustrator' and was able to see that it's possible - it's a bit more than I would want to tackle though, involving coding, etc!

[@Artistram3d1]

Great tutorial! Which would you say is better (and/or easier) to use for Data Merge, InDesign or Illustrator? Thank you!

[@GDHT]

If it's just text (like business cards where the name/title changes), I would definitely use InDesign. But if you're wanting different backgrounds and images, etc, maybe Illustrator. I haven't tried that with InDesign. Generally, AI is best used for 1-3 pages, and INDD is best for more (4-??).

[@EdgyButtermaker]

Great video! Question: If you wanted to put multiple fields together how do you do that? For example, if your spreadsheet had the following fields: Street, City, State, Zip is there a way to write the address dynamically? Because if you place the location of each in Illustrator it will stay in that position, it doesn't know to move one after the other based on how many characters each one is. Does what I'm asking make sense? Or if I wanted to dynamically pull from a spreadsheet a NAME, but add a comma after it. Such as the greeting in a letter: "Dear Name," because I don't want the comma in the spreadsheet, just the name, but I want a comma after the name... but again same issue. If place the comma it is in a fixed location and doesn't account for how many characters are in the name.

[@GDHT]

I don't think Illustrator has this capability, but InDesign does. InDesign is a better option all around for Data Merge, in my opinion.

[@viniciuscunha327]

Awesome job, really helpful! I was wondering if you know a way to load all the dataset results on one page instead of having to use an action to save as/export ...

[@GDHT]

I don't think it's possible to do this with Illustrator...but InDesign can do it: kzbin.info/www/bejne/gIPJlItjp8mLesU

[@viniciuscunha327]

@@GDHT thank you!

[@GDHT]

@@viniciuscunha327 You're welcome! :)

[@Lindemann]

@@GDHT Hi Anne, would you know of a possible script/plugin if there is one that could do this? (Doing a staff board which is done manually. Trying to automate it and really don't want to round trip into InDesign and Illustrator 😁) Superb video 🤗😎🤘

[@r0nnieM]

Excellent video! I'm just trying this now, using Excel, and i'm unable to put the @ in the column title for images. What do you need to do in Excel for images?

[@GDHT]

Not sure about Excel (I don't have it on my computer) - but I would just copy/paste the info in Excel into a Google sheet, which is free for everyone if you aren't able to figure it out.

[@jonyikbal]

very helpful, thanks.

[@GDHT]

You're welcome! I'm so glad it helped!

[@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.

[@GDHT]

I don't think you can, but you could extract them to separate files, add the files to your spreadsheet, and do the process that way. A few extra steps, but not too bad.

[@jaylenearnold1216]

If you want to run it again later with a new spreadsheet/new data but with the same variable names, do you have to re-bind all the variables? That's what I've been doing but I feel like I'm doing something wrong.

[@GDHT]

As long as everything is in the same place and has the same name, you should be able to just run the merge.

[@p_gawlita]

Hello Anne, and is it possible to add a column in the data file with different file names ? the name column is Final_image image_01 ->Final super image A image_02 ->Final super image B

[@GDHT]

Sure! You can have any name there as far as I know.

[@p_gawlita]

@@GDHT how to automate this when creating automation in operations -> function Action ?

[@GDHT]

I generally don't need to automate it with an action, since the merge automates pretty much everything, unless I'm misunderstanding what you want to do.

[@alno7199]

Nice tutorial! How would I print all of them at the same time? For example, I have a letter back with variables of names and addresses...

[@GDHT]

I would save them as a PDF and print from there.

[@originmediagroup]

Is it possible to have each data set show all at the same time? For instance, If I'm creating a menu for a restaurant, and input the name of the item, description and price of each item into a spreadsheet - each in their own columns, could I then update all items on the menu at one time?

[@GDHT]

I think you could. You'd need to create a text path for each cell, though. It would be time-consuming at first, but if there were changes to the menu, you could update them easily by updating the spreadsheet.

[@originmediagroup]

@@GDHT Any tips on how to styart creating a text path for each cell? I'm up for the challenge

[@fraces6001]

Hello i would like to check how to change all the file name with reference to clip timing 5.50? I heard you mention copy and paste? I don't think I can change them 1 by 1 as I have 50k qr codes to merge in and I have been searching high n low how to do it. Today I stumble upon your clip and I am excited to try.

[@GDHT]

If you're on a Mac and you have the files in one folder, you can copy all files in the folder, and paste into Illustrator. Then copy again, and paste into your Google doc. You'll only have the file names, so you'll need to concatenate the file name with the location - Google 'concatenate text strings' to learn how to do that.

[@aliakkaya6067]

I am adding jpg or svg files from the place tab then I can't click on the "make object dynamic" field in the variable field. The button in that field remains inactive and I cannot create a variable. I can do this with texts. What is the reason?

[@GDHT]

I just tried with a JPG and it worked for me. Make sure it's a linked file, and not embedded.

[@thughes44]

When trying to import the csv file, my Illustrator only looks for xml files? How can I request it looks for other file types?

[@GDHT]

What version are you on? You can try to export as XML from the spreadsheet, then use that doc. Let me know if it works!

[@TR3AD3R]

can we do anything for the font size thing , because i have mixed sentences where some are long and some are short so when i do the variable thing few ones protrudes outside the text area , what i do right now is decrease the font size so that the longest one also can be inside the text but that makes the shorter ones too small to read. any idea so that illustrator can adjust itself the font size according to the sentence length?

[@GDHT]

I don't think it has that ability, unfortunately. You'll probably need to manually fix it, or set the template with the longest text version.

[@TR3AD3R]

@@GDHT ok, thanks

[@sajjadurrahman8391]

Hi Anne, while I try to load variable library, at the download folder I cannot find the CSV file, only XML(*.xml) file type is showing. Any idea what to do?

[@GDHT]

I would save the file as CSV instead (it sounds like you accidentally saved as XML).

[@sajjadurrahman8391]

I saved in CSV but illustrator not allowing CSV not XML. Is this the reason I am using illustrator CS6? Any Idea ?

[@GDHT]

Oh ok, I understand I think! Yes, maybe Illustrator CS6 only allows XML files. That is a bit strange, though, honestly...and surprising!

[@josephfireborn]

Is it possible to make something like this work in illustrator except for a project like address labels on the same sheet?

[@GDHT]

No, unfortunately. You'll need to switch to InDesign for that: kzbin.info/www/bejne/qYmsi6WldrCcqqc

[@josephfireborn]

@@GDHT thanks. I guess I'll have to be pickup in design

[@GDHT]

@@josephfireborn it's not too bad - it's more similar to Illustrator than Photoshop.

[@vipulrathod2428]

Can we make single document (single page) with multiple images & text ( multiple records) using Illustrator?

[@GDHT]

Yes, but I would probably use InDesign for this - then new pages are auto-added. kzbin.info/www/bejne/gIPJlItjp8mLesU

[@KateGouws]

Hi! Thanks for the video! So helpful!! One question: is there a way to save all the datasets as one pdf file? Instead of the separate files?

[@GDHT]

Hmmm, I'm not sure if it will do it automatically, but you could combine them in Acrobat after they're done.

[@pipepaezadsandrock]

Hello, good morning, I am carrying out the process in a MacPro, with MacOs Monterrey, Illustrator 2023 version 26.7. I do the step by step and when you activate the upload of the file I get a window with Invalid File. Can you help me?

[@GDHT]

Hmm, I'm not sure why that's happening. This way is the only way I know to get it to work, and it's working for me on a MacPro. Are you using Google Sheets? I'm not sure about troubleshooting it - I'm so sorry!

[@caseymckay4919]

Is there a way to create and expand the variable text onto the same document Example: we are working with a vinyl cutter and a team roster. The only plug in option I have is to use Illustrator but want the plug in to create the cut sheet with the least space used Or use variable data spread over one artboard.....

[@GDHT]

InDesign has this capability, but I don't think Illustrator does unfortunately.

[@lyndsaymoye7861]

Hi! Is there anyway to merge fonts? For instance, is variable 1 has a different font that variable 2 and so forth. Would it be possible for the fonts to change as well?

[@GDHT]

Yes, you could just set up the font you want it to be, and when the words from the spreadsheet come in, they automatically take on that font (if I'm understanding you correctly).

[@Mysonichiban]

This is great! Any idea why when i import the variable library and go to view the data sets it has increased the font size by 2pt???

[@GDHT]

No, that is strange!! I can't think of why that would happen.

[@soneaf]

Hi there. Do you know if there is a limit on the number of data sets ?

[@GDHT]

Hi, no I don't. I would just give it a try and see if it fails.

[@soneaf]

@@GDHT mine stops at only 45 records, wanted to make sure there wasn’t an issue. That number seemed really low.

[@GDHT]

@@soneaf Yes, it does! Hopefully that's not the limit. Of course, you can always start a new set, but if you have thousands, that would take a while.

[@igobyandrew]

So I'm trying to simplify my workflow by editing one file that auto populates to other files. The only issue is, I am trying to have it populate the graphics onto another layout. So if I create for example one version that is in a portrait layout and another in a landscape, I just want to edit one and it auto populates the same graphics to a pre-determined position on another artboard or file. Hopefully that makes sense. Is this possible in Illustrator? I feel like it should be, but I dont know how to explain it properly... Thanks for your help and your well spoken video!

[@GDHT]

This should work - you can just go to your Links panel and choose Update links. Illustrator doesn't do great with custom positioning, so you'll want to make sure you don't add anything outside the edge of the design or it will shift in all layouts.

[@jlifeproductions6032]

hi there im a big fan of your videos , could i please ask you to do a video where i can do barcodes for tickets which will generate barcodes different to each tickets ,

[@GDHT]

I can try that - I would probably use something like InDesign, and use photos (of barcodes). I'll add it to the list!

[@joyscelondcosta462]

@@GDHT I will be waiting for this video. Thanks a lot. And looking forward to it.

[@GDHT]

It might be a while, honestly. But I will try to get it in!

[@lindsaymcneish1462]

Is there any way to have the data merge SKIP over a blank cell in the spreadsheet? I'm working on business cards and some folks only have one title, while others have two. The data merge auto fills in the second title even if that box is blank on the spreadsheet. Any suggestions?

[@GDHT]

I don't think so unless there's a script or something. What is it filling in with? I would sort the spreadsheet by that row, then set up a separate data merge for just those lines.

[@JesusPerez-mx9sq]

Hello, do you know if there is a way to export all the images as a single PDF with multiple pages?

[@GDHT]

You could make an action to save each document as PDF, then open all PDFs in Acrobat, and it'll ask if you want to combine into one. Another option would be to have all designs in one document (different artboards), but I think it could be hard for Illustrator to handle that.

[@darkohaidar8082]

can we name the each filr or image in variable name? like we do in image?

[@GDHT]

I don't understand what you mean.

[@georgiusradiyan]

when I paste the image location, instead of typed as slash (/) it showed up as arrow as exemple: ‎⁨MacOS SSD⁩ ▸ ⁨Users⁩ ▸ ⁨. is it allright or how can I change it to slash? thanks for the help before.

[@GDHT]

I think you'll need the slashes. You can probably find and replace with a slash, though.

[@georgiusradiyan]

@@GDHT finally I did this> Right click the image, and click copy image while hold alt to copy the image’s pathname and paste it to the sheets. anyway thanks for your video so I know how to use variable data 👍🏽🙏🏽💪🏽

[@GDHT]

@@georgiusradiyan ok great! I’m so glad you got it figured out!

[@Raphatheo813]

I have the error "the income variable library is invalid". I cant fix it.

[@GDHT]

I would probably try starting over - I haven't come across this error before. If you build the merge exactly like in the video, it should work for you.

[@prjktz]

same here

[@thewoods4851]

@@prjktz make sure it's "Variable1" no space. it happened to me too

[@woutercuypers572]

Still the same issue, tried everything... someone have any more advice?

[@NizamBagusPrabowo]

when i try to make variable on text box, this text "The filter cannot complete because of a bad parameter error" are showed up. How fix that? Thanks

[@GDHT]

It sounds like something in your Excel sheet is set up wrong...

[@NizamBagusPrabowo]

@@GDHT thanks for your answer, I know this mistake when I use print merge on coreldraw

[@GDHT]

@@NizamBagusPrabowo you’re welcome 😊

[@CynthiaRico-tg1io]

Hi, great video! By any chance, do you know how to add quotation marks in variable data? When quotation marks are added in the excel sheet, they disappear in the illustrator file. Maybe you have some tips to avoid this happening? Thank you :)

[@GDHT]

I haven't tested this, but I found this article: community.adobe.com/t5/illustrator-discussions/variables-does-not-import-quotation-mark-symbols-during-load-variable-library/td-p/12120621

[@joshnault4375]

Thank you for sharing. If you have 3 variables and one of the variables has blank entries, the previous filled in variable copies until there is a data entry for that variable. For example, variable 2 may have blank tiles in the .csv file and I need the text box in illustrator to be blank also but it copies the last variable 2 entry that was filled. Do you have a solution for this?

[@GDHT]

Hmm, I'm not 100% sure, it seems like data merge doesn't handle blank entries well - you might have to do it manually in that case. I'm thinking put a weird word, like 'lsdkfjal' in all the blank cells, then after Illustrator makes the documents, open them and then do a find/replace with lsdkfjal replaced to nothing. You could set up an action to run through lots of files at once to perform that, I would think. Here's an article about the blank entries: community.adobe.com/t5/illustrator/illustrator-variable-data-ignore-blank-cells-in-the-csv/m-p/10725263

[@joshnault4375]

@@GDHT Thank you! Leaving the text box blank did not solve the problem but find/replace is a great solution!

[@JonathonNeville]

Awesome! If only there was a way to: 1. Include new paragraph separators. Ctrl-Enter adds a new paragraph within Google Sheets, but then Illustrator says "The incoming variable library is invalid". 2a. Get the text to auto-adjust to the maximum size that fits within the text box. From what I've seen, Illustrator incomprehensibly can't do that. 2b. Failing that, if only there was a way to generate all the versions then let me adjust the font size of one without affecting all the others. (As stated in the video.) I'm presenting excerpts from book reviews. Some are short, some long.

[@GDHT]

InDesign has more capabilities with Data Merge, honestly. I'm not sure it can do #1, but it can definitely do #2b.

[@JonathonNeville]

@@GDHT - Thanks Anne, this is the first video of yours I've seen, but I / we-all love you!

[@GDHT]

Awww thank you so much!!

[@dimitardimitrov8964]

Hello, is it possible to have these 5 files on one artboard instead of 5 separate. I'm working on small labels with variable data that I would like to print on one sheet if possible.

[@GDHT]

In that case, I would use InDesign instead. Here'a a tutorial using multiple business cards on one sheet: kzbin.info/www/bejne/qYmUe4Rpbshmeqs

[@dimitardimitrov8964]

@@GDHT, thank you!

[@GDHT]

You're welcome!

[@mdrayhanmunshi5455]

I can't change text and color at a time with variable in illustrator, Example "John smith" a text, I change it with variable to "David Smith". now I want to change "David Smith" color red to green. How can I do this? Please help me, Please , Please , Please ...

[@GDHT]

I would do two documents, one with red, and one with green. And then just do two merges.

[@mdrayhanmunshi5455]

@@GDHT but i would do one document.....!!!!!

[@GDHT]

Can you put 2 color options in the one document?

[@fannycarlo9443]

can i use image vector, like svg or eps, instead png?

[@GDHT]

I would think so but I'm not sure...give it a try! :)

[@ivanywardhana7734]

Hi, it is a very fruitful tutorial. However, i would like to ask why i could not export it as png? Every time i exported it, it become a file which can't be opened. Do you have any suggesstions? Thankyou in advance and have a great day :)

[@GDHT]

That is really strange - what are your settings for export (other than png)?

[@ivanywardhana7734]

@@GDHT i have got the solution, so its happening because of the version of the apps. After i updated to the newest the problem had been resolved, thank you so much☺️☺️

[@GDHT]

@@ivanywardhana7734 oh ok! I’m so glad you got it figured out!

[@bastianrivero]

I like illustrator but i think this process is way easier in indesign

[@GDHT]

I would agree...but if you needed vector objects for screen printing or something (and wanted to use Data Merge), InDesign wouldn't work well.

[@TheWaqaspuri]

What about when I'm on the multiples screen e.g. more then 3 artboard with different size running on it.

[@GDHT]

Have you tried it already? I would think it would still work ok.

[@TheWaqaspuri]

@@GDHT Yes I didn't doesn't seems to work. Please assist

[@TheWaqaspuri]

it works if you set Variable 1, 2, 3... assigning to different, but a Text1 e. g. does not work where ever the Text1 is used.

[@TheWaqaspuri]

it works. I didn't make the object carefully

[@GDHT]

@@TheWaqaspuri ohhh ok. I'm glad you got it figured out! :)

[@HuzanForbes]

Thank you for this. However, I am unable to see the CSV option in the Load Variable Library dialogue box. Can you support please?

[@GDHT]

What program did you use to save the CSV?

[@HuzanForbes]

@@GDHT Microsoft excel. However, illustrator only shows xml as an option.

[@GDHT]

I would try from Google Sheets and see if that fixes the issue.

[@HuzanForbes]

@@GDHT I’ll try that. However I don’t understand how will it show CSV as an option in illustrator though?

[@GDHT]

I would give it a try. Using Excel has caused some problems for me in the past with this process.

[@BoY27300]

thanks for the video i have a problem when try to upload the variables illustrator show that i can only upload .xml files and no option for .csv files

[@GDHT]

What version of Illustrator are you using?

[@elwalsh311]

@@GDHT I'm having the same issue. I am on Illustrator CC 2017.

[@elwalsh311]

I also tried exporting as .xml and it told me the variable library was invalid. :-( Have you ever come across this before?

[@BoY27300]

@@GDHT 2017

[@BoY27300]

@@elwalsh311 hi the solution is in this video kzbin.info/www/bejne/gqXGq35-dqdqas0&t

[@Theakker3B]

What is the point of this?

[@GDHT]

If you have thousands of images and text all set up in a folder and spreadsheet, and you have to make graphics from them, it is a huge time saver!

[@ankit__kapoor]

How to name the files as the name of a variable dataset? ex, I am exporting certificates as jpeg but the names of the jpeg file are not the names of the Name of the Participant. How to do that?

[@GDHT]

You could save each artboard name as the name of the participant. It's still just as much work, though. I would research "rename files with excel" - there might be something valuable on KZbin for that.

[@ankit__kapoor]

Graphic Design How To That would be of great help. Right now, I am just renaming the files one by one, that is very cumbersome. Thanks for replying.

[@AdamMalesevic]

Search for "Illustrator Variable Data - The EASY way! " here on YT

[@TheWaqaspuri]

I have just XML instead of CSV ? What to do here ?

[@GDHT]

I would just open in Excel and save as CSV.

[@TheWaqaspuri]

@@GDHT No, In Adobe Illustrator CS6

[@GDHT]

@@TheWaqaspuri if you don’t have Excel, you can use Google sheets. You can’t make a CSV in Illustrator- you need a spreadsheet application.

[@TheWaqaspuri]

@@GDHT Hi again. I'm using data-set, it works good. I m using CS6. I'm having trouble aligning the text in the middle of the text boundary. see this example. so you may understand What I need actually to do in CS6 graphicdesign.stackexchange.com/questions/42030/how-can-i-align-text-in-a-text-area-vertically-in-illustrator (second box)

[@carlospedraza7750]

Hi! HQ content ! I’ve got a question, can Illustrator work with “ image variables “ that are vectors instead of png/jpg?

[@GDHT]

Thank you! I think that would probably work, though I've never tried it personally. Each vector would need to be saved as its own file.

[@shaped-by-design]

@@GDHT @Carlos Pedraza I've just tried it and you can. It only takes the first artboard of an Ai file, and as you mention, each vector has to be saved separately into the source folder you pull it from. 😎

[@GDHT]

@@shaped-by-design thank you 🙏

[@prabu2778]

@@shaped-by-design any video tutorial PNG works fine in variables But svg not able to do

[@raihandof]

My things doesnt work well like yours, the variable data is invalid. Can u help me with that?

[@GDHT]

Sure - can you let me know what part of the video you're getting stuck at (min, sec)?

[@raihandof]

@@GDHT its stuck when i import the csv

[@GDHT]

Is your CSV set up exactly like mine?

[@raihandof]

@@GDHT yup its exactly like yours, fyi i did it on Mac.

[@GDHT]

@@raihandof did you use excel or google sheets?

[@shaikhghalib4846]

what if i dont have internet access and can't use google data sheets feature for variable data

[@GDHT]

You can use Excel, or any spreadsheet that can be saved as .csv.

[@shaikhghalib4846]

​@@GDHT thank you very much

[@GDHT]

@@shaikhghalib4846 you're welcome!

[@shaikhghalib4846]

@@GDHT I converted data to csv file format from excel but when csv file imported in illustrator message appeared "incoming variable library is invalid" I checked the variable in excel and illustrator are same

[@shaikhghalib4846]

I REALLY NEED IT BADLY

[@TheWaqaspuri]

You're always great, how do I make the dataset same as variable first name, for e.g. invitation card john.jpg

[@GDHT]

You’ll need to isolate the “John” part into another cell on the spreadsheet. There are ways to get Google sheets and Excel to do that, I always have to Google things like that.

[@TheWaqaspuri]

@@GDHT could you recommend me a youtube tutorial that someone doing the same. OR you can let me know what should I write on first line e.g. data set or variable 0

[@GDHT]

I would put all file names in your first column, each in its own cell - john.jpg, alice.jpg etc. Then in the 2nd column, write a function that will remove '.jpg' from those. You can search 'Remove Last Character(s) From Right - Excel & Google Sheets' in Google. That will give you just the names. Then you can use those in your merge.

[@TheWaqaspuri]

I will try to do that trick,

[@9981240496]

Thanks, great tutorial! Anyway is it possible to save the file names with the Variable1 rows? So that it becomes “Networking.png”, “Brainstorming.png”, etc? Thanks again!

[@GDHT]

You're welcome! Hmm, not that I know of. I found this article about renaming them outside of Illustrator though (Mac only): discussions.apple.com/thread/252204380?sortBy=best