Create Live Excel Dashboards with AI (No Code) 📊

Launch the idea you’ve been sitting on TODAY with Hostinger Horizons, use my code 𝗦𝗩𝗘𝗡 to get 10% off your first month!
👉 https://pythonandvba.com/go/hostinger-horizons

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I’ll show you how I turned a plain Excel spreadsheet into a fully interactive sales dashboard with charts, filters, and an export to HTML button. It takes just a few minutes using AI, with no coding, no complicated setup, and definitely no VBA headaches.

We’re using Hostinger Horizons, a platform that turns a simple prompt into a working web app. I’ll walk you through the full process from writing the prompt and adding sample data to uploading your own Excel file and customizing the dashboard. I even compare it to a version I built years ago with Python, just to show how much time this approach can save.

By the end, you’ll have a clean, mobile-friendly dashboard that's easy to share or publish to a custom domain. Whether you're building an internal tool or kicking off your next big idea, this makes creating web apps from spreadsheets surprisingly easy.

🌍 𝗟𝗜𝗡𝗞𝗦:
▶ Live Website: https://salesdashboard-generator.io/
▶ ExcelToMarkdown Converter: https://pythonandvba.com/office-to-markdown-converter/

📜 𝗣𝗥𝗢𝗠𝗣𝗧:
"Build a sales dashboard for me using the data from the first sheet of my Excel file. At the top, show key performance indicators like total sales, average customer rating, and average sales per transaction. Below that, include charts for sales by hour and sales by product line. The dashboard should support dynamic filters for city, customer type, and gender, and automatically update when any filter is changed.
Also, I’d like to have an ‘Export to HTML’ button that creates a fully self-contained HTML file. It should include all charts and interactivity, so the file works on its own without needing the original Excel file. Also, the exported version should clearly show which filters were applied."

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Introduction
00:58 – Writing the initial prompt
02:16 – Reviewing the first result
04:30 – Adding a prompt to upload your own data
06:25 – Tips for writing better follow-up prompts
07:33 – How to get the source code
08:30 – Deploying the app
08:50 – Connecting a custom domain
09:53 –Undo, support, database and Stripe integration
10:39 – Final thoughts
11:21 – Outro


𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): https://pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): https://pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): https://pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): https://pythonandvba.com/emojify
📑 Excel Templates: https://pythonandvba.com/go/excel-templates
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources


𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: https://www.linkedin.com/in/sven-bosau/
📸 Instagram: https://instagram.com/codingisfun_official
💻 GitHub: https://github.com/Sven-Bo
💬 Discord: https://pythonandvba.com/discord
📬 Contact: https://pythonandvba.com/contact


☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ https://pythonandvba.com/coffee-donation