Highlighted

CSV File import in Illustrator (Var data)

New Here ,
Apr 13, 2020

Copy link to clipboard

Copied

I tried a lot, but I simply cannot import a simple CSV file (from Excel)0
Every time the error pops up : "The incoming variable library is invalid"

Is there anyone, who works on PC (win 10 build 1903) with Illustrator CC version 24.something
who can succesfully import a CSV file with just two columns (Name and Number for example) 
and make multiple datasets from these?

Thanks in advance!


Most Valuable Participant
Correct answer by Test Screen Name | Most Valuable Participant

Please explain the exact steps by which you make the CSV file from Excel.  I notice it does not have commas but semi-colons, try fixing that.

TOPICS
Creative Cloud

Views

543

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

CSV File import in Illustrator (Var data)

New Here ,
Apr 13, 2020

Copy link to clipboard

Copied

I tried a lot, but I simply cannot import a simple CSV file (from Excel)0
Every time the error pops up : "The incoming variable library is invalid"

Is there anyone, who works on PC (win 10 build 1903) with Illustrator CC version 24.something
who can succesfully import a CSV file with just two columns (Name and Number for example) 
and make multiple datasets from these?

Thanks in advance!


Most Valuable Participant
Correct answer by Test Screen Name | Most Valuable Participant

Please explain the exact steps by which you make the CSV file from Excel.  I notice it does not have commas but semi-colons, try fixing that.

TOPICS
Creative Cloud

Views

544

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Apr 13, 2020 0
Most Valuable Participant ,
Apr 13, 2020

Copy link to clipboard

Copied

How exactly, step by step, and with what exact settings in detail, do you make the CSV? Perhaps you could share a sample (with no personal data).

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 13, 2020 0
New Here ,
Apr 13, 2020

Copy link to clipboard

Copied

No probs, here is the example :

 

My illustrator file, with the variables defined (open the variables palette via window-variables)
https://drive.google.com/open?id=1C5jgHsDoOoX8wzcj2GNEuUKUNZAWeF61 

And then in the palette, choose load variable library, and select the csv file

https://drive.google.com/open?id=1LXjZqrlsveHq1PyYNbg1f1roMD-WFBtV 

(the csv file was made via this excel file : https://drive.google.com/open?id=14CsNESvxsHjXmafCUb9q7m7DgEigYwKS )

I also tried the Vardata script importer, and it is nice tool, but has some hickups. I simply cannot
believe that a simple var data workflow (via csv) works perfect in both photoshop and indesign, but would
be such a hassle in illustrator. And for the moment I really need the illustrator workflow)
I must be overlooking something very simple I suppose ...

Thank you for the quick answer!

 

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 13, 2020 0
Most Valuable Participant ,
Apr 13, 2020

Copy link to clipboard

Copied

Please explain the exact steps by which you make the CSV file from Excel.  I notice it does not have commas but semi-colons, try fixing that.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 13, 2020 0
Silly-V LATEST
Adobe Community Professional ,
Jun 22, 2020

Copy link to clipboard

Copied

Hey what sort of hiccups did you encounter with the VariableImporter script?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 22, 2020 0
New Here ,
Apr 13, 2020

Copy link to clipboard

Copied

Thank you very much Test_Screen_Name 🙂

You solved my issue. My seperator is set wrong in my regional settings.
I did this for a bug with another software, and now that you mentioned
the semi-colons, it came back to mind.

Thank you very much for helping me out on this one!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 13, 2020 0
Resources