Table in Adobe Illustrator using Excel

[@michaelnabong747]

You are a life saver, thank you so much!!!!!!!

[@TravisKelleher]

New sub here, thanks for making this! I had no idea that you could paste tables in to Illustrator.

[@doralavogue2020]

Thank you very much. This worked perfectly for me.

[@AdobeIllustratorforScientists]

Awesome!

[@yourmathvai]

why should we use clipping mask > release ? i tried with ungroup and it works. can u please explain me that step of using clipping mask ?

[@AdobeIllustratorforScientists]

Ungrouping and releasing the clipping masks allow you to edit the contents of the table after you have pasted it into Adobe Illustrator. If you have no need to edit, you don't need to ungroup or release the clipping masks.

[@yourmathvai]

@@AdobeIllustratorforScientiststhanks for your kind reply. but my question was, i can edit by doing ungrouping only. so why should we use clipping mask release?

[@AdobeIllustratorforScientists]

You can edit each part of the table after pasting, even without ungrouping or releasing the clipping masks. It just takes a ridiculous amount of double-clicking. So, I guess when I said "allow" I misspoke. If you ungroup and then release all the clipping masks, from that point forward you just need to click on the text. It makes editing much easier.

[@jamesalexander4411]

Can you vectorize imported tables so that you can export and resize without quality loss?

[@AdobeIllustratorforScientists]

Yes, any table made in excel or word will be vectorized when pasted in Illustrator

[@jamesalexander4411]

@@AdobeIllustratorforScientists Thank you. Is this done by selecting ALL with the mouse then Ctrl+Shift+O to 'Create Object Lines'?

[@malaisamysivakumar6016]

Thanks a lot for your video.I copied the table in XL and paste in illustratror, but value in the cell shows error message. how to solve this?

[@AdobeIllustratorforScientists]

Interesting. Thanks for letting me know. What values did you have? I bet Excel functions dont copy over. I recommend copy and pasting on another area of the spreadsheet to copy the formatting. Then copy again and past only the values into the table by clicking on the icon at the bottom right. Then copy that table into illustrator. Let me know if this works.

[@malaisamysivakumar6016]

@@AdobeIllustratorforScientists Thanks a lot for your reply. The value in the table is an numerical value such as 0.893 and 0.4892. When I copied in the illustrator, the whole table appears, but the value appears in the cell like “A and $ . Do you have any video for this ? Could you please explain more about this clearly?

[@malaisamysivakumar6016]

@@AdobeIllustratorforScientists I tried bro, doesn't works

[@AdobeIllustratorforScientists]

@@malaisamysivakumar6016 I tried generating an error and I couldn't. I could even copy over cells with functions, it just copies the values. Are you using Ariel font? Maybe another language? I wish I could help.

[@AdobeIllustratorforScientists]

@@malaisamysivakumar6016 okay someone told me how to solve it. I bet you are using a mac computer. It appears that the only way is to change the font to Avenir Next in Excel before copy

[@stephanieharper1161]

When copying from google sheets, it comes through as text without any formatting like a table

[@AdobeIllustratorforScientists]

I have the same issue. Here is a workaround. Download the spreadsheet as an .xlsx and copy from there.

[@northeastglazing]

@@AdobeIllustratorforScientists I used openOffice Calc and works

[@TawniPerry]

When I copy and paste my excel chart to AI the borders don't appear. Please help me!

[@AdobeIllustratorforScientists]

Sorry for the late reply. Are you using a Mac computer?

[@TawniPerry]

@@AdobeIllustratorforScientists Yes, I am. The M1 Chip Macbook Pro.

[@RobertMacInnis-r3t]

When I do this, all of the text turns into symbols and i have to manually input the content. Why is this happening?

[@AdobeIllustratorforScientists]

Are you using a Mac or PC?

[@untiground]

dear scientist. never…. never ever use pseudo 3D effect. ----- why cell borders heavier than numbers? Why horizontal amount of space around numbers is 10 times more than vertical space? why you making everything so ugly?

[@AdobeIllustratorforScientists]

This video is merely a tutorial on how to do it. It’s up to you to make it the way you like. Illustrator really can’t do 3D. It does 3D effects, which make things only appear 3D. You would need to use blender for that. I never really thought about cell border vs text thickness. Good idea.

[@mgrafik]

You are a life saver, thank you so much!!!!!!!