Skip to main content
A
Anonymous
August 10, 2015
Question

Use Excel Data to name layers in Illustrator

  • August 10, 2015
  • 2 replies
  • 669 views

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!

This topic has been closed for replies.

2 replies

Qwertyfly___
Qwertyfly___
Legend
August 10, 2015

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

    Silly-V
    Silly-V
    Legend
    August 10, 2015

    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!

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices