• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Importing CSV file into Illustrator create Pie chart not working properly.

Explorer ,
Jan 01, 2023 Jan 01, 2023

Copy link to clipboard

Copied

For speed I want to create some pie charts from simple spreadhseets, this is something I'm sure older versions of AI could handle. However this is not working. When the CSV is exported from Excel it imports randon characters "Ôªø" and the header text and value are all in the same  column. When the CSV is exported from Numbers all the values end up in one column but 2 rows e.g. a header row and a data row but all the data comma separated in the single column.

 

If I copy and paste the spreadhseet content into the graph spreasheet in Illustrator the results are fine. I created a simple spreasheet with 5 values so column titles a,b,c,d and e and then number values 12,18,20,40 and 10.  Plus a second version with row titles a-e etc.

 

So tried the follwoing options

 

1. Row 1 titles, row 2 values First row and First column unticked in the pie chart options

2. As above with first row ticked

3. As above with second row ticked

4. As above with both ticked

5, All the above but having row titles and data with adjacent values in the next column

 

I have also tried highlighting all 10 cells required and then importing the data. All that happens

is the import now appears from coloumn F not A.

 

What am I doing wrong as I'm sure this used to work. I can copy and paste but importing data from a  file should be possible?

 

Mac OSX12.6 All apps updated to latest versions.

Screenshot 2023-01-01 at 22.10.29.pngScreenshot 2023-01-01 at 22.01.14.pngScreenshot 2023-01-01 at 22.00.03.pngScreenshot 2023-01-01 at 21.37.03.png 

 

TOPICS
Import and export , Tools

Views

81

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
community guidelines
Community Expert ,
Jan 01, 2023 Jan 01, 2023

Copy link to clipboard

Copied

You might want to check out the Variable Importer Javascript. Especially with Excel Mac there are some issues with CSV files. https://github.com/Silly-V/Adobe-Illustrator/tree/master/Variable%20Importer 

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
community guidelines
Adobe Employee ,
Jan 17, 2023 Jan 17, 2023

Copy link to clipboard

Copied

LATEST

Hello @Simon_Atterbury,

 

Thanks for reaching out. I hope the suggestions shared by Monika helped resolve the trouble you were having. If not, kindly update this thread so we can assist you further.

 

Looking forward to your response.

 

Thanks,

Anubhav

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
community guidelines