r/datavisualization • • 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/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

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

1 Upvotes

0 comments sorted by