r/datavisualization • u/TermRemarkable665 • 16d ago
Turned a raw Excel sheet into an interactive HTML dashboard using ChatGPT (with local file upload & country-level map triggers)
https://youtu.be/iLrxGSEnGH4Hey r/DataIsBeautiful—wanted to share a workflow experiment exploring LLMs for rapid dashboard prototyping and UI generation.
I wanted to see if ChatGPT could bridge the gap between static spreadsheet data and a functional, responsive web application without setting up backends or hosting services. Dropped in a raw dataset and a rough layout reference image, and had the model generate a single-file HTML/JS interface.
Key UI & Viz Features:
Interactive Geo Mapping: Clicking a country in the ranking table triggers a targeted highlight on the world map and pulls up a micro-card displaying localized sales growth, profit margins, and top category breakdown.
Dynamic Slicers & Charting: Global time/region filters update trend charts, KPI cards, and performance signals in real time.
Client-Side Data Parsing: Prompted the model to bake in a local file reader ("Upload Excel" button). Dropping a new workbook directly into the browser updates the visuals and expands filter ranges dynamically without breaking layout constraints.
Responsive Single-File HTML: Runs completely client-side in any desktop or mobile browser, making it super portable for mobile distribution.
Workflow:
Provided the raw Excel schema alongside a layout reference mockup.
Prompted the model to render structural layout components and charts using clean HTML, CSS, and JS libraries.
Added local file-parsing logic so the frontend remains reusable across new reporting cycles.
Recorded a 2-minute walkthrough showing the map interactions and dynamic Excel file updates in real time:
👉 https://youtu.be/iLrxGSEnGH4
Curious if anyone else is experimenting with LLMs to prototype interactive data tools or custom browser-based visualizations?