# 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
speckleand 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:
# Support
For any feedback and support requests please visit our community forum (opens new window).