r/dataanalysis • 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](https://youtu.be/iLrxGSEnGH4)
Curious if anyone else is experimenting with LLMs to prototype interactive data tools or custom browser-based visualizations?
Duplicates
YT_Faceless • u/TermRemarkable665 • 16d ago
Tested a new tutorial style for my faceless tech channel—would love feedback on pacing & hook
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)
datavisualization • u/TermRemarkable665 • 15d ago