Sven-Bo/automate-excel-with-vba-and-chatgpt
Learn how to automate tedious Excel tasks using VBA and ChatGPT. Consolidate data, send mass emails with personalized text and attachments, and automate pivot table creation. Step-by-step guide on using ChatGPT to generate VBA code and implement it in your own workbooks.
This project helps anyone who uses Excel regularly to automate repetitive tasks. It shows you how to use ChatGPT to generate the VBA code needed to consolidate data from multiple sheets, send personalized mass emails with attachments, or create pivot tables automatically. The end user is an office worker, manager, or analyst who spends a lot of time on manual data tasks in Excel.
Use this if you want to learn how to use AI to generate scripts for automating common, time-consuming Excel operations without needing to be an expert programmer.
Not ideal if you're looking for a fully-built, ready-to-use software solution that doesn't require any manual setup or interaction with VBA.
Stars
20
Forks
7
Language
—
License
—
Category
Last pushed
Jan 27, 2026
Commits (30d)
0
Get this data via API
curl "https://pt-edge.onrender.com/api/v1/quality/llm-tools/Sven-Bo/automate-excel-with-vba-and-chatgpt"
Open to everyone — 100 requests/day, no key needed. Get a free key for 1,000/day.
Higher-rated alternatives
Kuingsmile/word-GPT-Plus
Word GPT Plus is a word add-in which integrates the AI&Agent into Microsoft Word.
nicejade/gpt-wordbook
智析单词书（GPT-Wordbook）是由 AI 赋能的智能英语词汇学习平台，通过 GPT...
filippofinke/WordGPT
🤖 Bring the power of ChatGPT to Microsoft Word
Sven-Bo/Integrate-GPT4-in-Excel-using-VBA
This repository contains VBA modules that enable integration of the GPT-3.5-turbo and GPT-4...
lencx/app
🏖️ No Free Work Life