SheetLink

Export your Revit model data (by categories, elements, schedules) to Excel and Google Sheets. Edit the data and import it back to update the model.

Table of contents

1. Annotation Categories
   1. Search Categories
   2. Instance, Type and Read-only
      1. Search Available Parameters
   3. Selected Parameters
      1. Search Selected Parameters
      2. Order the Selected Parameters
      3. Isolate Selection
      4. Export Project Standards
      5. Import Project Standards file
      6. Reset Values
      7. Preview/Edit
      8. Export
      9. Import

Annotation Categories

The first step is to select the SheetLink in the DiRootsOne menu and to choose the Annotation Categories tab.

Steps:

1. Click radio buttons to switch between Whole Model, Active View or Current Selection to choose the categories.

# Note:
The 'Whole Model' radio button will show the existing all annotation categories.
The 'Active View' radio button will show the existing annotation categories in the current view.
The 'Current Selection' radio button will show the existing annotation categories in the current selection.

1. Use the checkboxes above the table to select to Include Linked Files and to Export by Type ID

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

1. Use the checkboxes to select specific annotation categories, or use the checkbox in the table header to select all annotation categories.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Search Categories

The search box will search for annotation categories contained in the Select Categories column.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Instance, Type and Read-only

After to choose the categories, the SheetLink has options to see just instance, type and read-only parameters.

Click on the table headers to select the instance parameters, for example.

# Note:  
If selected, the instance parameters, will show it in the green color.
If selected the type parameters, will show it in the yellow color.
If selected the read-only parameters, will show it in the red color.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Search Available Parameters

The search box will search for parameters contained in the Available Parameters column.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Selected Parameters

Choosing parameters:

1. Select the parameters in the Available Parameters table.
2. Click in the arrows to add or remove from the Selected Parameters table.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Search Selected Parameters

The search box will search for parameters contained in the Selected Parameters column.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Order the Selected Parameters

Use the arrows above the Selected Parameters table, to order the parameters to export.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Isolate Selection

The Isolate Selection button allows filtering the selected annotation categories in a Temporary View (Hide/Isolate).

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Export Project Standards

The Export Project Standards button allows exporting the main data about the project to Excel or Google Drive. The data to be able to export is the Project Information, Object Styles, Line Styles and Families.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Import Project Standards file

You can also edit some Project Information and import to update the current model.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Reset Values

Select the Reset Values button to clean all the parameters available and selected.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Preview/Edit

Click to preview and to edit the sheet before exporting.
_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

Export

Click to export the sheet to Google Drive or Excel.
_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

The Excel file is editable and after the editing of it you can import through SheetLink. Caution, open the Instruction tab in your Excel file to get the colors legend.

# Note:  
Yellow: Type Value
Red: Read-only Value. This fields can not be edited.
Grey: Parameter does not exist for this element.

# Note:  
If you are altering the value of 'Type Parameters', ensure that you have the same value for all elements with the same 'Type ID'

Import

If you have made some file edition, import it and update the current model on Revit. Before importing the file, you can preview the sheet to make sure, and after conclude the import.

_{Note: the version on the image may not reflect the latest version of SheetLink/DiRootsOne.}

# Note:  
- Import file from Google Drive or from Excel.
- Track the file import progress bar.