Use Excel Data to name layers in Illustrator

[Guest]

I'm doing a bunch of medical drawings (first batch is about 100). There might be more after that. It's a huge job.

I was given this excel sheet. (Here is a quick screenshot)

I need to make a little drawing for each item on the list. Is there a way I can import the excel data into illustrator as the names of layers? (See mockup below)

Thanks!

[Silly-V]

Oh yes, youcould just save it as a .csv or other-delimited text file and make a javascript to parse the text and rename the layers. Or, you can use Applescript or VBS to directly work from Excel to rename the layers in Illustrator.

There you go!

[Qwertyfly___]

take a look at this thread.

it will give you all you need to read the file and rename the layers.

should not be much to tweak it to your needs

Re: Script Help: Layer names based on Excel Data