Learn to manage BIM workflows and create professional Archicad templates with the BIM Manager Program.

cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

Archicad and Excel

Anonymous
Not applicable
Hello.
I have the following issue: I did a table in Excel and I would like to transpose it to Archicad, so that the construction of the table becomes simple lines and the text can be modified.
I tried to import the table as both Rich text and Jpeg, but none of these meet what I want, as written before.
Is there a solution to this?
Thank you.
8 REPLIES 8
Dontknow
Enthusiast
Maybe you'll find the following topic usefull:

http://archicad-talk.graphisoft.com/viewtopic.php?t=32377&sid=85034c3343bbae80a45f70b498a61d69
Architectural construction designer, draftsman, modeller
ArchiCAD 25.
Eduardo Rolon
Moderator
If you are using AC18:

• Export Table from Excel as PDF
• Place PDF in AC
• Right Click on PDF and select "Explode". Check that Text is converted to text and not lines.
---
and now I see that you are not using it.

If you have Adobe Illustrator then you can open the PDF and export to DWG and then import it to AC.
Eduardo Rolón AIA NCARB
AC27 US/INT -> AC08

Macbook Pro M1 Max 64GB ram, OS X 10.XX latest
another Moderator

Anonymous
Not applicable
Thank you both for the answers.
No, I do not have Archicad 18, nor do I have Adobe Illustrator.
But I am going to try and install the trial versions of them and try both methods.
Thank you.
Anonymous
Not applicable
P.S. I have Autocad 2010. Does it help in any way? Is there a way through Autocad as well?
Eduardo Rolon
Moderator
igreere wrote:
P.S. I have Autocad 2010. Does it help in any way? Is there a way through Autocad as well?
Not that I know of.
Eduardo Rolón AIA NCARB
AC27 US/INT -> AC08

Macbook Pro M1 Max 64GB ram, OS X 10.XX latest
another Moderator

Anonymous
Not applicable
OK. I made the table in Excel a pdf. Then I imported it into Illustrator, where everything was fine. I exported from Illustrator to .dwg and placed the .dwg as an external drawing into Archicad and then exploded it.
The file is quite a mess, as it is shown in the picture. The construction lines of the table are orange and black, while they should be plain black lines. The numbers are split into individual digits. And sometimes one row is one big text box, with a mess of numbers and text inside.
What is wrong of what I do?
Thank you.
Eduardo Rolon
Moderator
Now you need to clean it up by editing the line and text settings. The problem might be on how excel exported the PDF or how Illustrator converted it into DWG.
----
Main question here is why do you need to convert the excel file to lines and letters since the normal workflow is to just export to PDF from Excel and Place the PDF in AC and if you need to edit the file you just make the changes in Excel and re-save the PDF overwriting the original one.
Eduardo Rolón AIA NCARB
AC27 US/INT -> AC08

Macbook Pro M1 Max 64GB ram, OS X 10.XX latest
another Moderator

Anonymous
Not applicable
I could explode the pdf from Excel in Archicad 18, with the help of a friend that has this AC version. It worked. So thank you very much.
As far as why I am doing this, I can only say that my boss asked me to do it.
Thank you again.