🚨 New connector alert: Excel!

Hi @Community ,

It’s that time again when we announce a new connector - you’ve asked and we’ve listened. We’re thrilled to announce a Speckle connector for Excel, probably one of the most used software in our industry!

The connector is still in early alpha and we’re waiting for Microsoft to approve it before it can be published on the Office Store and be available for general use.

In the meantime, please do check the docs and code.

We’re keen to hear any early stage feedback you might have :ear: :hugs:

8 Likes

That’s great @teocomi!
Spreadsheets are still a very powerful way to exchange data. They are very effective to get an overview, sort and filter your data in a quick way.
Here my primary comments:

  1. Would be very nice to be able to filter the properties you want to “bake” to excel.
    The same export could be performed many times therefore the user may way want to create a template and set up conditional formatting etc.
  2. A table viewer in the web app would also be very effective.
    There you should be able to filter, sort and ideally both share the table URL to someone inside your stream and download the table as csv file. This way we don’t leave out those that like to work with google spreadsheets or opensource alternatives.

Nice work and looking forward to test it soon!

4 Likes

Thanks for the ideas!

  1. Yes, this is already being worked out! As you can imagine, flattening complex objects with children objects would lead to a LOT of columns/headers (I tried baking a revit wall and it was about to create 2000). So I’ll add a simple UI that lets you filter them if you have more than ~20.
  2. Interesting idea! @izzylys and @clrkng are currently working on a UI to input data directly from the web app, eventually we could add such features you mention as well :slight_smile:
1 Like

Another sneak peek: updating (or borking) Revit elements form Excel

3 Likes

Hi folks, the Excel Connector is now on the Microsoft Store, go and grab it!

We will be producing more documentation and tutorials soon, in the meantime, please drop all your feedback here below :slight_smile:

3 Likes

Hi @teocomi, together with some colleagues we tried to test the connector between Excel and Revit but changing data in Excel (eg height of a wall) does not update the elements in Revit. Is it necessary in Excel to keep the ID parameter to have the element recognized or something else? Thanks for your reply and congratulations for this platform!

Ciao Marco!

Thanks for trying the connector and for reporting back here :slight_smile:
The process of updating Revit elements has not been streamlined yet, but I’ve just added some guidance in the docs on how to do so:

https://speckle.guide/user/excel.html#updating-revit-parameters

We’re hoping to make it simpler going forward, but in the meantime, the example in the link above should do.

Any other issues or ideas feel free to shoot!

1 Like

Thanks a lot @teocomi

1 Like

@teocomi

Fully agree with both points you mention!

  1. For some of our work we also use Excel template files with some conditional formatting. It would be great if you can simply send and receive in the same format and range over and over again, without the need to specify e.g. the range each time. Also setting this kind of standard sending/receiving format as default in an Excel file could be a nice addition.

I had a try with the Excel connector and it’s really easy and clear to work with, a very good addition! One issue I noticed while sending some very basic data is that the order of columns in objects can change:

First I send the basic data of 2 points (A2:E4) using “range with headers” to send actual objects. Receiving them back works properly (G2:K4), but the columns are in different order. This is definitely an issue, especially if you want to work with template files as mentioned. Is this expected behaviour or am I missing something?

  1. I was thinking of maybe building an app on Speckle that allows to visualize, manipulate and filter tabulated data. However, this is probably functionality that many people can use, so some kind of integrated table viewer would be useful, especially if there is some room to customise it to your needs, either through a UI or by some additonal coding.

Thanks in advance!

Thanks @Rob, super good feedback!

  1. remember range/seelction: yes, I’m aware of this and have been saving it for later (it requires a bit of brain power to come up with a solution and it’s really hot in London now). It’s being tracked here
  2. column order: quickest solution would be to always enforce alphabetical order, hope it works
  3. tabular viewer: this is very interesting, we discussed something similar internally. I think it could either be:
  • added directly to the frontend and if the data sent is in tabular form it could replace the 3d viewer altogether
  • a speckle app to interact with tabular data
    Anyways, feel free to start cracking on it, and do ping us if you’d like to coordinate around it!
2 Likes

Hi @Rob ,

1&2 have been implemented, together with a few minor fixes and improvements. Have a go and let me know what you think!