🤖 Google Gemini AI in Excel VBA

Use Google's Gemini AI directly in Excel! Analyze data, generate formulas, summarize text, and more - all without leaving your spreadsheet.

🚀 Quick Start

Step 1: Get Your API Key

1. Go to Google AI Studio
2. Sign in with your Google account
3. Click "Create API Key"
4. Copy your API key

Step 2: Add the VBA Modules to Excel

1. Open your Excel workbook
2. Press Alt + F11 to open the VBA Editor
3. Right-click on VBAProject → Import File...
4. Import these files from the src folder (in this order):
   • Dictionary.cls
   • JsonConverter.bas
   • mGemini.bas
   • mGeminiDemo.bas (optional - creates demo examples)

Step 3: Add Your API Key

1. In the VBA Editor, open the mGemini module
2. Find this line near the top:

   Const GEMINI_API_KEY As String = "YOUR_API_KEY"

3. Replace YOUR_API_KEY with your actual API key

Step 4: Run Gemini!

• Method 1 - Macro: Press Alt + F8 → Select Gemini → Click Run
• Method 2 - Formula: Use =AskGemini("Your question here") in any cell

📖 Usage Examples

Select Data	Run Gemini	Type Instruction
Sales table	Alt+F8 → Gemini	"Analyze trends"
Customer feedback	Alt+F8 → Gemini	"Summarize sentiment"
Email list	Alt+F8 → Gemini	"Extract first names"
(no selection)	Alt+F8 → Gemini	"Write a VLOOKUP example"

⚙️ Configuration Options

Edit these constants in mGemini.bas to customize behavior:

Setting	Options	Description
GEMINI_MODEL	gemini-2.5-flash, gemini-2.5-flash-lite, gemini-3-pro-preview	AI model to use
GEMINI_INPUT_MODE	both, selection, inputbox, auto	How prompts are collected
GEMINI_OUTPUT_MODE	lines, single	How responses are displayed

Video Tutorial

🤓 Check Out My Excel Add-ins

I've developed some handy Excel add-ins that you might find useful:

• 📊 Dashboard Add-in: Easily create interactive and visually appealing dashboards.
• 🎨 Cartoon Charts Add-In: Create engaging and fun cartoon-style charts.
• 🤪 Emoji Add-in: Add a touch of fun to your spreadsheets with emojis.
• 🛠️ MyToolBelt Add-in: A versatile toolbelt for Excel, featuring:
  • Creation of Pandas DataFrames and Jupyter Notebooks from Excel ranges
  • ChatGPT integration for advanced data analysis
  • And much more!

🤝 Connect with Me

• 📺 YouTube: CodingIsFun
• 🌐 Website: PythonAndVBA
• 💬 Discord: Join our Community
• 💼 LinkedIn: Sven Bosau
• 📸 Instagram: Follow me

☕️ Support My Work

Love my content and want to show appreciation? Why not buy me a coffee to fuel my creative engine? Your support means the world to me! 😊

💌 Feedback

Got some thoughts or suggestions? Don't hesitate to reach out to me at contact@pythonandvba.com. I'd love to hear from you! 💡