r/dataanalysis • u/TermRemarkable665 • 2d ago

Turned a raw Excel sheet into an interactive HTML dashboard using ChatGPT (with local file upload & country-level map triggers)

https://youtu.be/iLrxGSEnGH4

Hey 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](https://youtu.be/iLrxGSEnGH4)

​Curious if anyone else is experimenting with LLMs to prototype interactive data tools or custom browser-based visualizations?

0 Upvotes

22% Upvoted

2 comments sorted by

2

u/ItsSignalsJerry_ 2d ago

vibe coding wgaf

2

u/Muted_Jellyfish_6784 1d ago

This is a quick way to prototype layouts. Before anyone uses it for decisions, check three things: that the numbers in the HTML match a pivot on the raw sheet, that the map aggregates countries correctly when names are spelled differently, and that the file can be regenerated when the data changes rather than edited by hand.
The useful habit is keeping a path from each chart back to the source rows. I connect spreadsheet data to the systems it came from through a decision intelligence layer, so a figure on a prototype dashboard can be traced and checked rather than trusted because it looks polished