141 reputation
4
bio website thisisourjam.com
location New Orleans, LA
age 31
visits member for 8 months
seen May 13 at 1:00
stats profile views 5

Jan
29
awarded  Teacher
Jan
29
comment Importing spreadsheet data as layers into Adobe Illustrator
Just did that. Thanks for your help.
Jan
29
answered Importing spreadsheet data as layers into Adobe Illustrator
Jan
29
comment Importing spreadsheet data as layers into Adobe Illustrator
Thanks for the input. I managed to find a better way to save as separate EPS files by creating variables and dynamic content. But this requires creating an XML file to import the data. In order to do that I'd have to create change a spreadsheet into an XML first. Anyway, I was looking for a simple way to do this, turns out there is no simple way! Thanks anyway for the input.
Jan
25
awarded  Editor
Jan
25
revised Importing spreadsheet data as layers into Adobe Illustrator
More detail about my problem.
Jan
25
comment Importing spreadsheet data as layers into Adobe Illustrator
But even then, I was only able to create a data set from an XML file, which would require first creating the XML file from a spreadsheet, which is another process altogether. So at this point, I'll leave the question unanswered. Thanks for all your help though. I definitely appreciate it.
Jan
25
comment Importing spreadsheet data as layers into Adobe Illustrator
Well, it worked, but it didn't work as I needed it to. I was able to find a way to create an action that saves multiple EPS files, but not one that creates a layer with each new set of data. Part of the problem is the way AI handles actions. When you create an action, it does not recognize the selection of layers. So I can create a layer, but it just pastes the info from each data set all on the same layer. So I got aboutt 75% of the way there.
Jan
24
comment Importing spreadsheet data as layers into Adobe Illustrator
I did find a way to create data sets and variables within Ai, but this required first creating an XML file, that would probably take longer than just copying and pasting everything into the original AI file. The problem on top of that was that it only allowed me to save separate EPS files, not create individual layers based on the data set.
Jan
24
awarded  Supporter
Jan
24
comment Importing spreadsheet data as layers into Adobe Illustrator
Thanks for the tip. I have MAMP running on my machine, but this seems like a ton of work (for me at least) that might take longer than just copying pasting... Mostly because I have no idea how to do any of this you're talking about!
Jan
24
comment Importing spreadsheet data as layers into Adobe Illustrator
Well, I'm not actually making business cards. I used that as an example, because I figured it would be one of the most generic examples that others might have had a use for. What I'm doing is creating slides for a video reel. I have a TON of these with about 4 or 5 variables. for each slide. The guys making the video need it in AI with one layer for each set of data. Sorry for being misleading. I was trying to simplify my question, but it seems it caused more confusion.
Jan
24
awarded  Student
Jan
24
asked Importing spreadsheet data as layers into Adobe Illustrator