How to Import Keynotes into Archicad Using Excel

1. Prepare Your Excel File

Make sure your Excel file is structured correctly. The columns must follow this order:

• Type: The keynote type (for example, Folder, Keynote).
• Key: A unique identifier for each keynote.
• Title: The keynote's title.
• Description: A detailed description of the keynote.
• Reference: Any reference information.
• Path: The hierarchical path for nesting the keynotes.

Example:

Type	Key	Title	Description	Reference	Path
<Folder>	001	General	General notes
<Keynote>	002	Wall finish	Paint finish details		General

Understanding the Path Column

The Path column specifies the hierarchical relationship between keynotes and folders. It helps Archicad understand how to nest the keynotes under the correct folders. Here's how to set it up:

1. Top level: For top-level folders, the Path column must be empty. These folders are the main categories under which other folders and keynotes will be nested.
2. Subfolders and keynotes: For subfolders and keynotes, the Path column must contain the path to their parent folder. This path is usually a string representing the hierarchy, and it's important to place the folder's key and title in each cell.

Example structure:

2. Import Keynotes into Archicad

1. Open Archicad and go to File > Import > Keynotes.
2. Select your prepared Excel file and click Open.
3. Archicad will import the keynotes and display them in the Keynotes palette.

3. Check and Adjust the Keynotes

After importing, check that the keynotes are correctly nested and displayed:

1. Open the Keynotes palette in Archicad.
2. Review the hierarchy and make sure all keynotes are correctly placed under their respective folders.
3. Make any necessary adjustments directly in the Keynotes palette.

Troubleshooting

• Incorrect nesting: If keynotes aren't nesting correctly, check the Path column in your Excel file for typos or inconsistencies.
• Missing keynotes: Make sure all required fields are filled in and there are no duplicate keys.