The Relationship Visualizer spreadsheet transforms your Excel data into professional Graphviz diagrams and Knowledge Graphs. Enter simple "A is related to B" rows to instantly generate polished relationship graphs using the Graphviz DOT language. Ideal for org charts, dependency graphs, and IT architecture. Free, open-source, MIT-licensed.
Customize the look of nodes, edges, and clusters with the Style Designer. Build a CSS-like gallery of reusable styles that lets you apply consistent visual themes. Run SQL queries for advanced data import. Export graphs as BMP, GIF, JPG, PDF, PNG, or SVG files (with animation support). View Graphviz DOT code and command-line messages.
Works on Windows and macOS with a ribbon interface and UTF-8 support for global text. Explore illustrated guides at https://exceltographviz.com
With over 10,000 downloads and a SourceForge Community Choice award, this open-source VBA tool clarifies complex data. Download now and turn data into insight.
Features
- Free, open-source tool under the MIT License.
- Converts Excel data into Graphviz relationship graphs.
- No coding required.
- Auto-generates diagrams from simple "A is related to B" inputs.
- Style Designer customizes nodes, edges, and clusters visually.
- Styles Worksheet offers a CSS-like gallery of reusable styles for nodes, edges, and clusters.
- Illustrated guides at https://exceltographviz.com enhance learning.
- Supports SQL queries for advanced data extraction (Windows only).
- Recursive SQL queries auto-build multi-level org charts and dependency trees from parent-child data.
- Generates timeline and roadmap diagrams from event and milestone data.
- Save graphs as images, or SVG files.
- UTF-8 support for non-Western languages like Greek and Cyrillic.
- Works on Windows and macOS with a user-friendly ribbon interface.
- Provides multilingual UI with English, French, German, Italian, and Polish translations
- Displays graphs within Excel with auto-refresh functionality.
- Save Graphviz DOT source code for use in other tools.
- Captures DOT command-line messages in a console worksheet.
- Interactive SVG viewer adds pan, zoom, hover labels, and click-to-highlight filtering for large diagrams.
- Supports multiple Graphviz layouts like dot, neato, and circo.
- Adjusts graph settings UI dynamically for each Graphviz layout.
- Exports an AI-ready Knowledge Graph (JSON) that tools like Claude and Grok can read and answer questions from.
- Exports workbook data as JSON for exchange or source control.
License
MIT LicenseUser Reviews
-
Brilliant piece of work. I needed something to bridge the gap between a report generator and Graphviz. Before I started to write something I did a quick search and found this. I gave it a try and was pleasantly surprised to find that it worked and even more importantly, it had commercial quality documentation. It abstracts the interface to Graphviz in such a way as to make it much easier to use than "raw" dot syntax. I was really surprised to see the low number of downloads. Highly recommended if you need to create Graphviz diagrams.
-
Indeed when you need to visualize the business data to headquarters, can't find something better than this tool.
-
Tested the product on so may different combinations, work flawlessly in every instance. Very impressive, now works with Excel 2007, 2010 and 2013 - Make sure you download the latest version (20/5/2017). Must be one of the best excel macro driven spreadsheets I've come across.
-
This is without a doubt one of the best Excel tools ever created, in my opinion. The documentation, the forethought, the ease of use - not only is it incredibly easy to create Graphviz files with this tool, but it's a great segway into the DOT language and Graphviz in general. So powerful because it's so easy to use. If you have a need for Graphviz, but are unsure how to develop with it, this tool will make your life *easy*.