Sync diagrams with Google Sheets or MS Excel #5224
bilcramo-prog
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi!
I’m trying to figure out if there’s a way to link Google Sheets (or MS Excel) to a draw.io diagram so they update each other automatically.
Here’s my scenario:
I have a network diagram with devices.
Each device has info like IP address, subnet, gateway, etc.
I want this data to live in a spreadsheet (Google Sheets or Excel).
If I change something in the sheet, the diagram updates automatically.
And ideally, if I update something in the diagram, it also updates the sheet.
The dream setup:
One draw.io document with two pages:
The topology diagram.
A table view (pulled from the sheet) with IP, gateway, etc.
The table page stays synced with the external spreadsheet (Google Sheets / Excel on OneDrive or SharePoint).
Basically, I’m looking for a “dynamic” diagram that’s tied to live spreadsheet data.
Has anyone done this or know if it’s possible? Feedback is much appreciated!
Beta Was this translation helpful? Give feedback.
All reactions