Support Forum

Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
How do you import an Excel file?
January 11, 2010
3:59 pm
Avatar
Admin
Administrators
Forum Posts: 383
Member Since:
February 2, 2009
sp_UserOfflineSmall Offline

One of our ArchiCAD clients (not an AMT user) asked a question that might be of interest to others, so I'm posting his question and my reply here.

Wayne Chevalier asks:

Eric,

I'm not sure if you are the one I should be asking or if I should be directed to someone in your office....

I'm trying to find out what is the best way to import an Excel file?...merge? copy & paste?....

Thanks for the help!
Wayne

You’ll need to create a PDF from the Excel file (using Print or Save commands, depending on your setup). Then in ArchiCAD you’ll use the Drawing tool (or File menu > External Content > Place External Drawing) and choose the PDF. You’ll then see the contents of the PDF in the current working view (floor plan, detail window, Layout sheet, etc.) which will be linked to the PDF file (it will be updatable if the PDF is changed).

Note that the drawing is not linked to the Excel file directly – it is linked to the PDF that is created from the Excel file.

Eric Bobrow, Principal, Bobrow Consulting Group – Creator of MasterTemplate – The Office Standard for ArchiCAD – http://www.bobrow.com http://www.actemplate.com

January 28, 2020
8:20 am
Avatar
New Member
Users
Forum Posts: 2
Member Since:
December 13, 2019
sp_UserOfflineSmall Offline

Any updates to this process for Archicad 23? Also, is there a way to build tables directly in Archicad? Is building a schedule with entirely custom content the only way aside from lining up text blocks?

January 28, 2020
11:10 am
Avatar
Admin
Administrators
Forum Posts: 383
Member Since:
February 2, 2009
sp_UserOfflineSmall Offline

Albert -

ARCHICAD still cannot import and place an Excel file directly.

We now have the ability to export an interactive schedule from ARCHICAD, open it in Excel, fill in info or update field values, then reimport into the schedule. This is primarily used for getting information into the project from consultants. For example, you can export a schedule with equipment or fixtures and have the costs filled in by a consultant, then reimport to be able to tally up costs within ARCHICAD.

What type of table are you trying to create? What information do you need to display?

Eric

Eric Bobrow, Principal, Bobrow Consulting Group – Creator of MasterTemplate – The Office Standard for ArchiCAD – http://www.bobrow.com http://www.actemplate.com

January 31, 2020
3:22 pm
Avatar
New Member
Users
Forum Posts: 2
Member Since:
December 13, 2019
sp_UserOfflineSmall Offline

It is mostly construction note. I've opted to use Excel as a master file and just save to PDF's that are linked to worksheet in my template. This seems to give me the greatest flexibility for formatting.

Forum Timezone: America/Los_Angeles

Most Users Ever Online: 108

Currently Online:
10 Guest(s)

Currently Browsing this Page:
2 Guest(s)

Member Stats:

Guest Posters: 1

Members: 1841

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 11

Topics: 291

Posts: 844

Moderators: Eric Bobrow: 383