From Excel to Insight Maker: Visualizing System Dynamics with AI
Spreadsheets revolutionized how we work with data - they made computation accessible and practical for everyone. But tables full of numbers often hide the bigger picture: the systemic relationships between variables.
What if you could see your spreadsheet not just as numbers, but as an interactive diagram that reveals how everything connects?
That’s exactly what this project demonstrates. Using ChatGPT 5.2, I transformed a traditional Excel model into a stock and flow diagram ready for simulation in Insight Maker.
Here’s how it worked. I prompted ChatGPT to:
"Convert the attached spreadsheet into a stock and flow diagram to be imported as a JSON file into Insight Maker. Parameters (M11, M12, etc.) should be adjustable via sliders, time unit is MONTHS, and use Euler integration."
After a few refinements in the chat, I imported the generated JSON directly - no manual tweaks. The resulting diagram is shown here exactly as created by AI. It’s admittedly a bit rough, but intentionally so: it shows the raw potential of AI-assisted modeling.
The best part? The simulation output matched the original spreadsheet values exactly - validated in the "Table from Insight Maker" and "Validation" tabs.
This isn’t just a technical experiment. It’s a step toward making System Dynamics more intuitive and spreadsheets more insightful. By visualizing data flows and feedback loops, we can communicate complex models more clearly and make better decisions.
I hope this inspires you to explore similar integrations between spreadsheets, AI, and simulation tools. Have you tried something like this? I’d love to hear about your experiments!
Let’s push how we model, visualize, and communicate systems. If you find this useful, feel free to share and connect in LinkedIn.
📝 Full ChatGPT Conversation – See the prompt and AI workflow
📊 Original Google Spreadsheet – View the source data and validation
📈 Interactive Stock-Flow Model – Explore the diagram in Insight Maker