Create an Excel Dashboard in Minutes Using Gemini AI 🤯 | Step-by-Step Tutorial, by Vedakarna on YouTube. 3 min 2 s.
- Video length
- 3 min 2 s
- Time to do it
- 25 minutes
- Difficulty
- Easy
- Steps
- 9
What you need
Steps
Clean your spreadsheet first. Keep one header row, remove merged cells and blank rows, and make sure every column has a short clear name. Save or export the sheet as a CSV file.
Open gemini.google.com, start a new chat and attach the CSV file, or paste in the first 20 rows plus the column names if the file is large.
Send a prompt like: Build a single-file HTML dashboard from this data using Chart.js. Include KPI cards, a bar chart, a line chart and a dropdown filter.
Tell Gemini which columns to total and average so the KPI numbers are correct, for example: sum the Sales column and average the Order value column.
Copy the code Gemini returns into Notepad or VS Code and save it as dashboard.html with UTF-8 encoding. Keep the.html extension exactly.
Double-click the file to open it in Chrome. The charts load from a CDN, so keep your internet connection on while viewing the page.
If a chart is blank, press F12 to open the browser console, copy the error line and paste it back into Gemini with the word fix in front.
Ask for design changes in the same chat: a dark mode toggle button, your brand colours, different icons and an export to CSV button.
Check a few totals against your spreadsheet, then save the final file and share it by email or upload it to any static web host.
Tips and common mistakes
Name your columns in the prompt exactly as they appear in the file, or Gemini will guess and the charts will be empty.
Ask for a single HTML file with no build steps so it opens by double-clicking, without a local server.
Always compare two or three dashboard figures with the original spreadsheet before you share it.
Do not paste customer names, salaries or other private data into a public AI chat.
Questions
Do I need to know how to code?
No. You describe the layout and charts in plain English and Gemini writes the HTML, CSS and JavaScript for you. You only copy, save and open the file.
Does this create a dashboard inside Excel?
No. It creates a separate HTML web page that you view in a browser. You can still keep your original spreadsheet for editing the raw data.
Can I use Google Sheets data instead of Excel?
Yes. In Google Sheets choose File, then Download, then Comma Separated Values, and upload that CSV to Gemini. The rest of the steps are the same.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
