The Excel to Graphviz Relationship Visualizer spreadsheet transforms your Excel data into professional Graphviz diagrams. Enter simple "A is related to B" rows to instantly generate polished relationship graphs using the Graphviz DOT language. Ideal for data analysis, network visualization, 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.
- Supports SQL queries for advanced data extraction (Windows only).
- Illustrated guides at https://exceltographviz.com enhance learning.
- 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.
- Post-processes SVG files to add interactive JavaScript animations.
- Supports multiple Graphviz layouts like dot, neato, and circo.
- Adjusts graph settings UI dynamically for each Graphviz layout.
- 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*.