# Excel

Speckle currently supports the following versions of Excel:

  • Excel on iPad
  • Excel 2016 or later on Mac
  • Excel 2013 or later on Windows
  • Excel on the web

TIP

Check out our dedicated tutorial on how to get started with Excel (opens new window)!

# Getting Started

For a quick overview, check out this short video on how to get started sending and receiving in Excel!

# Installing

Our Excel Connector is not distributed via the Speckle Manager.

Instead, you can get it from the Microsoft Office Store.

To install it:

  • Open Excel (for Desktop or Web)
  • Click on Insert > Office Add-Ins
  • Search for speckle and click Add

Alternatively, just visit https://appsource.microsoft.com/en-us/product/office/WA200002934 (opens new window).

After installing the connector, it should appear in Excel under the Home ribbon like so:

# Logging In

You'll need to log in to use this connector as it is unable to access your accounts from Speckle Manager. To do so, simply type your server url click on the log in button and insert your credentials.

IMPORTANT 🙌

Currently, only accounts on servers managed by us are supported, this is because of limitations on the Microsoft Office Store. To use the Excel Connector with a server deployed by you, you'll have to publish it yourself.

# Adding Projects

Just click the top left menu > Add Project > click on a Project to add to the document. The Project will be saved in the document and available whenever you return to it.

By default, projects are added as receivers but you can easily switch them to sender mode.

# Receiving Data

Receiving data in Excel is quite different than in other connectors, and this is because we need to "flatten" it so to represent it in a table format. In general, a Project will either contain:

  • Simple values like numbers, text etc
  • Complex data structures (objects) like a Revit Wall or a Grasshopper Line. Objects are identified by a {} symbol.

The Excel Connector works best when receiving lists of either simple values or objects of the same type. Lists are identified by a [] symbol.

Since a version can contain a variety of data types, after clicking the Receive button, you'll have the possibility to expand and select which data inside it to actually pull and write to your Excel file. You don't have to receive an entire version each time!

# Simple Values

When receiving lists (or lists of lists AKA tables) of numbers or text, the data is received without transformations and the values are outputted by default in rows. Therefore, a single list will write data to a single row, a list of lists to multiple rows. If the incoming data has any further levels of nesting, it will be "string-ified".

# Objects

When receiving lists of objects they are flattened. This means that each object will become a new row and all its property values (and sub-property values) will become columns, their names will be the headers. Individual objects can be received too, and only one row will be created.

TIP 🙌

We recommend receiving lists of objects that have the same underlying data structure, i.e. only receiving objects of the same type.

Nested objects are flattened as well and their properties delimited by a period .. See the example below where 10 lines have been sent from Dynamo and received in Excel:

# Complex Objects

When receiving complex objects (with more than 25 properties or sub-objects), you'll be presented with an additional dialog. This will let you filter which columns are to be received.

# Sending Data

Similarly to receiving, data can be sent a list of simple values or of objects.

# Simple Values

Just select the range of data you want to send and click "Set range"

This is how it'll look in Speckle.

# Objects

To send objects, just replicate the structure of objects that you have previously received, then select "Set range with headers".

For instance, you could create 10 new lines with the data below:

# Parameter Updater (Sync Revit Schedules and other data)

The Speckle Revit Connector enables you to easily update Revit Schedules from Excel.

Step 1 is to send your schedule from Revit to Speckle using the Speckle Revit Connector. Select the desired schedule using the "Schedule" option in the selection menu on the connector as shown below.

The next step is to receive the version in Excel. There is some preprocessing magic that is done in the background to identify that you are trying to receive a schedule. The result of this preprocessing is that you won't be prompted to filter and receive data as you normally would.

You may notice that some of the table columns are shaded gray. That is an indication that those values are computed in Revit and are unable to be set directly in Revit.

From this point you are able to sort and edit your schedule any way that you would like. To send the schedule back to Revit, select the table (or just a portion of it if you only want to send certain data), and send it to Speckle (with or without headers) as described in the Sending Data section. It is important to note that your selection must not contain any cells outside of the table range or receiving your data back in Revit will fail to update the existing schedule.

LIMITATIONS

Currently the Parameter Updater cannot update parameter values that correspond to other elements. These values can often be identified in Revit by having a dropdown selection in the Revit Schedule. Adding support for updating this type of parameter is currently on our backlog.

# Advanced Workflows

IMPORTANT

🚧 This section is under construction, we will add more documentation and examples on this soon! 🚧

More advanced workflows are possible, similarly to how our Grasshopper Schema Builder works, you can create BIM elements directly from Excel and update Revit elements too.

# Support

For any feedback and support requests please visit our community forum (opens new window).