Revit Keynoting – Edit Using Excel

Revit Keynoting – Edit Using Excel

Keynotes should be set up carefully, as there is no set format according to which they must comply. Instead the person who sets up the file has complete control over its composition. Revit also has no native Editor to facilitate a workflow, instead the keynote file has to be composed in notepad or a 3rd party app. Most people have access to Microsoft Office and so it may be easier to work with keynoting in Excel as opposed to working in the original text file. This blog shows how to move between notepad and Excel and how to import the file into Revit.

Open a new worksheet and then:

<Data><Get External Data><From Text>

1

Browse and select the appropriate file.

2

The text file is in tab delimited format, so it must be imported into Excel as such.

3

4

Make sure to change the column data format to “Text”, otherwise the formats will be changed

5

6

This results in the following:

7

The entries may now be edited in Excel. After which it may once be written out to a tab delimited text file.

<File><Save As><My Computer><Browse>

Save the file as type: Text (Tab delimited)(*.txt)

8

Choose yes upon the warning if you want to keep the file in its current tab delimited format. Doing this allows on to make changes, save and then reload the file into Revit.

9

Load the keynotes file in Revit.

<Annotation><Tag><Keynote><Keynote Settings>

10

Browse to the correct file:

11

Revit validates the file and warns of orphaned entries

12

View the keynotes:

13

They display as follows, and this is the format in which they are selectable in Revit.

14

By | 2017-05-24T12:12:35+00:00 March 14th, 2016|

About the Author:

After concurrently manufacturing for the Radar EW industry and reading incompletely toward Mechanical Engineering at Stellenbosch University, I realigned toward the Architectural. Today I support the AEC professions in Cape Town as an Application Engineer for a Gold Autodesk Reseller in South Africa called Micrographics. I support and facilitate training on the following software platforms: Revit (Architectural, Structural and MEP); Civil3D; AutoCAD; SANSCalc and Lumion.