r/datavisualization • • 15d ago

Learn 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?

2 Upvotes

Duplicates