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. Elements
   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. Filter elements within a section box
      4. Isolate Selection
      5. Export Project Standards
      6. Import Project Standards file
      7. Reset Values
      8. Preview/Edit
      9. Export
      10. Import

Elements

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

Steps:

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

The 'Whole Model' radio button will show the all existing model categories.
The 'Active View' radio button will show the existing categories in the current view.
The 'Current Selection' radio button will show the existing 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. Select a category in the Select Category table, and use the checkboxes in the table below to choose the specifics type elements.

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

Search Categories

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

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

Instance, Type and Read-only

Once you’ve chosen the elements, SheetLink has options to see only 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 shown it in the green.
If selected the type parameters, will be shown it in the yellow.
If selected the read-only parameters, will be shown in the red.

_{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

Parameter selection:

1. Select the parameters in the Available Parameters table.
2. Click on 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 sort the parameters to be exported.

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

Filter elements within a section box

You have the ability to use existing 3D view or duplicate it. Visualize only filtered elements or all elements within Section Box, with the possibility of defining the displacement of the marked elements.

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

Isolate Selection

The Isolate Selection button allows you filter the selected 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 you to export the main project data to Excel or Google Drive. The data to be exported 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 to 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 clear all the elements and available and selected parameters.

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

Preview/Edit

Click to preview and edit the sheet before exporting it.

_{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 be imported 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 any edits to the file, import it and update the current model in Revit. Before importing the file, you can preview the sheet to be sure, and then complete 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.

Let’s go to the next tab to manage the Schedules.