Best AI tools for< Excel Vba Developer >
Infographic
20 - AI tool Sites
ExcelBot
ExcelBot is an AI-powered tool that helps users create, edit, and copy Excel formulas and VBA code using plain natural language text requests. It is designed to make it easy for users of all skill levels to automate complex Excel tasks and improve their productivity.
ExcelMaster
ExcelMaster is an AI-powered Excel formula and VBA assistant that provides human-level expertise. It can generate formulas, fix or explain existing formulas, learn formula skills, and draft and refine VBA scripts. ExcelMaster is the first of its kind product that handles real-world Excel structure and solves complicated formula/VBA assignments. It is far better than other “toy” formula bots, Copilot, and ChatGPT.
Formula Dog
Formula Dog is an AI-powered tool that helps users generate Excel formulas and solve spreadsheet problems quickly and easily. With Formula Dog, users can simply enter their problem or question into the AI assistant, and the tool will generate a step-by-step solution with the appropriate formula. Formula Dog also offers a variety of other features, such as a formula library, a help center, and a community forum, to help users learn more about Excel and solve their spreadsheet problems.
VBA Code Generator
VBA Code Generator is an AI-powered tool that allows users to generate VBA code quickly and efficiently. By inputting requirements, users can instantly generate complex VBA code using simple text instructions with the help of AI. The tool is designed for both beginners and experienced users, offering a versatile application that can handle various VBA tasks, from Excel automation to Access database management. With a focus on saving time and streamlining workflows, VBA Code Generator simplifies the coding process and provides accurate formulas for users' specific needs.
Excel Formula Bot
Excel Formula Bot is an AI-powered tool that helps users generate Excel and Google Sheet formulas using simple text instructions. It provides a user-friendly interface that allows users to write formulas in natural language, eliminating the need for complex syntax and manual calculations. With Excel Formula Bot, users can save time and effort while ensuring accuracy and consistency in their spreadsheet tasks.
Formulas HQ
Formulas HQ is an AI-powered formula and script generator for Excel and Sheets. It provides users with a variety of tools to simplify complex calculations, automate tasks, and gain insights from data. The platform includes features such as formula generation, regular expression simplification, VBA and Apps Script automation, and chat-based assistance. Formulas HQ is designed to help users improve their productivity and efficiency when working with spreadsheets.
Formularizer
Formularizer is an AI-powered assistant designed to help users with formula-related tasks in spreadsheets like Excel, Google Sheets, and Notion. It provides step-by-step guidance, formula generation, and explanations to simplify complex formula creation and problem-solving. With support for regular expressions, Excel VBA, and Google Apps Script, Formularizer aims to enhance productivity and make data manipulation more accessible.
GPT Excel
GPT Excel is an AI-powered tool that helps users generate spreadsheet formulas, SQL queries, Apps Script and VBA scripts easily. It supports over 50 languages and offers a free tier with limited requests per day. The pro plan includes additional features such as unlimited requests, priority customer support, and access to additional AI tools like a regex generator and an Excel template generator.
FormulaGenerator
FormulaGenerator is a free AI-powered toolkit that helps users generate Excel formulas, VBA automations, and SQL queries. It also offers features like error spotting, formula explanations, code generation, and an AnswerBot powered by ChatGPT. The tool is available as a web app and a Google Sheets extension.
Formulas HQ
Formulas HQ is an AI-powered formula and script generator for Excel and Sheets. It provides users with a range of tools to simplify complex calculations, automate tasks, and enhance their spreadsheet mastery. With Formulas HQ, users can generate formulas, regular expressions, VBA code, and Apps Script, even without prior programming experience. The platform also offers a chat feature with system prompts to assist users with idea generation and troubleshooting. Formulas HQ is designed to empower users to work smarter and make better business decisions.
Excelly-AI
Excelly-AI is a powerful tool that transforms plain text into Excel formulas, supporting both Excel and Google Sheets. Users can generate any formula they like and receive explanations for each. It allows uploading .xlsx files for personalized prompts and offers VBA formula generation. Excelly-AI integrates with Slack for team collaboration and provides column schema support for meaningful prompts, enhancing Excel and Google Sheets operations.
Ajelix BI
Ajelix BI is a powerful yet easy-to-use data visualization platform that helps small business owners and non-technical teams create professional-looking reports with a dash of AI data analytics. With Ajelix BI, you can upload your spreadsheet files and create dashboards to share with colleagues, without the need for complex setups or database integrations. Ajelix BI also offers a suite of AI-powered tools for Excel, including an Excel formula generator, VBA & Google Apps code creator, Excel template builder, file translator, and Excel & Google Sheets add-on. These tools can help you automate tasks, improve productivity, and gain insights from your data.
Excel Bot
Excel Bot is an AI assistant designed to help users work more efficiently with Excel and Google Sheets. It offers features such as converting formulas to text, saving time, and providing personalized assistance. Trusted by over 5000 happy customers, Excel Bot is a reliable tool for automating tasks and improving productivity in various business sectors. With Zigment AI technology at its core, Excel Bot ensures accuracy and effectiveness in handling data-related tasks.
Sheeter.ai
Sheeter.ai is an advanced Excel formula generator tool designed to help users quickly and easily create complex Excel formulas with just a few clicks. It automates the process of formula creation, saving time and increasing productivity. The tool is efficient, transparent, and controllable, offering users the ability to generate formulas for both Excel and Google Sheets. Sheeter.ai is reliable, focused, and highly customizable, making it a valuable resource for individuals and businesses looking to streamline their Excel productivity.
Formula Bot
The website offers a free AI Excel Formula Generator tool that converts text instructions into formulas or explains input formulas. It also provides other AI-powered data analysis tools like sentiment analysis, PDF to Excel converter, SQL query generator, and more. The AI-driven tools aim to simplify Excel tasks, automate formula creation, and help beginners utilize Excel's functionalities efficiently and accurately.
ExcelDashboard Ai
ExcelDashboard Ai is an AI tool that allows users to instantly convert Excel data into interactive dashboards. The tool simplifies the process of creating visually appealing and insightful dashboards without the need for complex coding or design skills. Users can easily upload their Excel files, customize the dashboard layout, and visualize data in a user-friendly format. ExcelDashboard Ai streamlines the dashboard creation process, saving time and effort for individuals and businesses looking to present data in a more engaging way.
Microsure
Microsure is a company that develops microsurgical robots to help surgeons perform complex procedures with greater precision and dexterity. Their flagship product, MUSA, is a robot-assisted microsurgery platform that enables surgeons to operate on the smallest anatomical structures with high precision and enhanced dexterity. Microsure's mission is to leave no patient in need of microsurgery untreated.
Synthesis
Synthesis is an innovative educational platform designed for kids who seek to think independently and excel in math and problem-solving. Developed in collaboration with DARPA researchers, it offers a superhuman math tutor and collaborative games to enhance children's problem-solving and communication skills. Founded as part of the SpaceX school initiative, Synthesis aims to cultivate student voice, strategic thinking, and collaborative problem-solving abilities. The platform provides unique learning experiences to a global community, empowering students to develop essential skills for the future.
Datarails
Datarails is a financial planning and analysis platform for Excel users. It automates data consolidation, reporting, and planning while enabling finance teams to continue using their spreadsheets and financial models. With Datarails, finance teams can save time on repetitive tasks and focus on strategic insights that drive business growth.
PromptLoop
PromptLoop is an AI-powered tool that integrates with Excel and Google Sheets to enhance market research and data analysis. It offers custom AI models tailored to specific needs, enabling users to extract insights from complex information. With PromptLoop, users can leverage advanced AI capabilities for tasks such as web research, content analysis, and data labeling, streamlining workflows and improving efficiency.
20 - Open Source Tools
BotServer
General Bot is a chat bot server that accelerates bot development by providing code base, resources, deployment to the cloud, and templates for creating new bots. It allows modification of bot packages without code through a database and service backend. Users can develop bot packages using custom code in editors like Visual Studio Code, Atom, or Brackets. The tool supports creating bots by copying and pasting files and using favorite tools from Office or Photoshop. It also enables building custom dialogs with BASIC for extending bots.
SheetCopilot
SheetCopilot is an assistant agent that manipulates spreadsheets by following user commands. It leverages Large Language Models (LLMs) to interact with spreadsheets like a human expert, enabling non-expert users to complete tasks on complex software such as Google Sheets and Excel via a language interface. The tool observes spreadsheet states, polishes generated solutions based on external action documents and error feedback, and aims to improve success rate and efficiency. SheetCopilot offers a dataset with diverse task categories and operations, supporting operations like entry & manipulation, management, formatting, charts, and pivot tables. Users can interact with SheetCopilot in Excel or Google Sheets, executing tasks like calculating revenue, creating pivot tables, and plotting charts. The tool's evaluation includes performance comparisons with leading LLMs and VBA-based methods on specific datasets, showcasing its capabilities in controlling various aspects of a spreadsheet.
excel-spring-boot-starter
The excel-spring-boot-starter project is based on Easyexcel to implement reading and writing Excel files. EasyExcel is an open-source project for simple and memory-efficient reading and writing of Excel files in Java. It supports reading and writing Excel files up to 75M (46W rows 25 columns) in 1 minute with 64M memory, and there is a fast mode for even quicker performance but with slightly more memory consumption.
ai-by-hand-excel
The 'ai-by-hand-excel' repository is a collection of AI exercises that can be implemented manually using Excel. It includes both basic and advanced topics such as Softmax, LeakyReLU, Backpropagation, Transformer, RNN, and Mamba. The repository aims to provide hands-on experience and understanding of AI concepts through practical Excel exercises.
rpaframework
RPA Framework is an open-source collection of libraries and tools for Robotic Process Automation (RPA), designed to be used with Robot Framework and Python. It offers well-documented core libraries for Software Robot Developers, optimized for Robocorp Control Room and Developer Tools, and accepts external contributions. The project includes various libraries for tasks like archiving, browser automation, date/time manipulations, cloud services integration, encryption operations, database interactions, desktop automation, document processing, email operations, Excel manipulation, file system operations, FTP interactions, web API interactions, image manipulation, AI services, and more. The development of the repository is Python-based and requires Python version 3.8+, with tooling based on poetry and invoke for compiling, building, and running the package. The project is licensed under the Apache License 2.0.
Twitter-Insight-LLM
This project enables you to fetch liked tweets from Twitter (using Selenium), save it to JSON and Excel files, and perform initial data analysis and image captions. This is part of the initial steps for a larger personal project involving Large Language Models (LLMs).
Cradle
The Cradle project is a framework designed for General Computer Control (GCC), empowering foundation agents to excel in various computer tasks through strong reasoning abilities, self-improvement, and skill curation. It provides a standardized environment with minimal requirements, constantly evolving to support more games and software. The repository includes released versions, publications, and relevant assets.
AI-Bootcamp
The AI Bootcamp is a comprehensive training program focusing on real-world applications to equip individuals with the skills and knowledge needed to excel as AI engineers. The bootcamp covers topics such as Real-World PyTorch, Machine Learning Projects, Fine-tuning Tiny LLM, Deployment of LLM to Production, AI Agents with GPT-4 Turbo, CrewAI, Llama 3, and more. Participants will learn foundational skills in Python for AI, ML Pipelines, Large Language Models (LLMs), AI Agents, and work on projects like RagBase for private document chat.
h2ogpt
h2oGPT is an Apache V2 open-source project that allows users to query and summarize documents or chat with local private GPT LLMs. It features a private offline database of any documents (PDFs, Excel, Word, Images, Video Frames, Youtube, Audio, Code, Text, MarkDown, etc.), a persistent database (Chroma, Weaviate, or in-memory FAISS) using accurate embeddings (instructor-large, all-MiniLM-L6-v2, etc.), and efficient use of context using instruct-tuned LLMs (no need for LangChain's few-shot approach). h2oGPT also offers parallel summarization and extraction, reaching an output of 80 tokens per second with the 13B LLaMa2 model, HYDE (Hypothetical Document Embeddings) for enhanced retrieval based upon LLM responses, a variety of models supported (LLaMa2, Mistral, Falcon, Vicuna, WizardLM. With AutoGPTQ, 4-bit/8-bit, LORA, etc.), GPU support from HF and LLaMa.cpp GGML models, and CPU support using HF, LLaMa.cpp, and GPT4ALL models. Additionally, h2oGPT provides Attention Sinks for arbitrarily long generation (LLaMa-2, Mistral, MPT, Pythia, Falcon, etc.), a UI or CLI with streaming of all models, the ability to upload and view documents through the UI (control multiple collaborative or personal collections), Vision Models LLaVa, Claude-3, Gemini-Pro-Vision, GPT-4-Vision, Image Generation Stable Diffusion (sdxl-turbo, sdxl) and PlaygroundAI (playv2), Voice STT using Whisper with streaming audio conversion, Voice TTS using MIT-Licensed Microsoft Speech T5 with multiple voices and Streaming audio conversion, Voice TTS using MPL2-Licensed TTS including Voice Cloning and Streaming audio conversion, AI Assistant Voice Control Mode for hands-free control of h2oGPT chat, Bake-off UI mode against many models at the same time, Easy Download of model artifacts and control over models like LLaMa.cpp through the UI, Authentication in the UI by user/password via Native or Google OAuth, State Preservation in the UI by user/password, Linux, Docker, macOS, and Windows support, Easy Windows Installer for Windows 10 64-bit (CPU/CUDA), Easy macOS Installer for macOS (CPU/M1/M2), Inference Servers support (oLLaMa, HF TGI server, vLLM, Gradio, ExLLaMa, Replicate, OpenAI, Azure OpenAI, Anthropic), OpenAI-compliant, Server Proxy API (h2oGPT acts as drop-in-replacement to OpenAI server), Python client API (to talk to Gradio server), JSON Mode with any model via code block extraction. Also supports MistralAI JSON mode, Claude-3 via function calling with strict Schema, OpenAI via JSON mode, and vLLM via guided_json with strict Schema, Web-Search integration with Chat and Document Q/A, Agents for Search, Document Q/A, Python Code, CSV frames (Experimental, best with OpenAI currently), Evaluate performance using reward models, and Quality maintained with over 1000 unit and integration tests taking over 4 GPU-hours.
allchat
ALLCHAT is a Node.js backend and React MUI frontend for an application that interacts with the Gemini Pro 1.5 (and others), with history, image generating/recognition, PDF/Word/Excel upload, code run, model function calls and markdown support. It is a comprehensive tool that allows users to connect models to the world with Web Tools, run locally, deploy using Docker, configure Nginx, and monitor the application using a dockerized monitoring solution (Loki+Grafana).
God-Level-AI
A drill of scientific methods, processes, algorithms, and systems to build stories & models. An in-depth learning resource for humans. This repository is designed for individuals aiming to excel in the field of Data and AI, providing video sessions and text content for learning. It caters to those in leadership positions, professionals, and students, emphasizing the need for dedicated effort to achieve excellence in the tech field. The content covers various topics with a focus on practical application.
toolmate
ToolMate AI is an advanced AI companion that integrates agents, tools, and plugins to excel in conversations, generative work, and task execution. It supports multi-step actions, allowing users to customize workflows for tackling complex projects with ease. The tool offers a wide range of AI backends and models, including Ollama, Llama.cpp, Groq Cloud API, OpenAI API, and Google Gemini via Vertex AI. Users can easily switch between backends and leverage AI models like wizardlm2 and mixtral. ToolMate AI stands out for its distinctive features such as tool calling for any LLMs, running multiple tools in one go, highly customizable plugins, and integration with popular AI tools. It also supports quick tool calling using '@' notation and enables the execution of computing tasks on demand. With features like multiple tools in one go, customizable plugins, system command and fabric integration, GPU offloading support, real-time data access, and device information retrieval, ToolMate AI offers a comprehensive solution for various tasks and content creation.
ezwork-ai-doc-translation
EZ-Work AI Document Translation is an AI document translation assistant accessible to everyone. It enables quick and cost-effective utilization of major language model APIs like OpenAI to translate documents in formats such as txt, word, csv, excel, pdf, and ppt. The tool supports AI translation for various document types, including pdf scanning, compatibility with OpenAI format endpoints via intermediary API, batch operations, multi-threading, and Docker deployment.
ragflow
RAGFlow is an open-source Retrieval-Augmented Generation (RAG) engine that combines deep document understanding with Large Language Models (LLMs) to provide accurate question-answering capabilities. It offers a streamlined RAG workflow for businesses of all sizes, enabling them to extract knowledge from unstructured data in various formats, including Word documents, slides, Excel files, images, and more. RAGFlow's key features include deep document understanding, template-based chunking, grounded citations with reduced hallucinations, compatibility with heterogeneous data sources, and an automated and effortless RAG workflow. It supports multiple recall paired with fused re-ranking, configurable LLMs and embedding models, and intuitive APIs for seamless integration with business applications.
databerry
Chaindesk is a no-code platform that allows users to easily set up a semantic search system for personal data without technical knowledge. It supports loading data from various sources such as raw text, web pages, files (Word, Excel, PowerPoint, PDF, Markdown, Plain Text), and upcoming support for web sites, Notion, and Airtable. The platform offers a user-friendly interface for managing datastores, querying data via a secure API endpoint, and auto-generating ChatGPT Plugins for each datastore. Chaindesk utilizes a Vector Database (Qdrant), Openai's text-embedding-ada-002 for embeddings, and has a chunk size of 1024 tokens. The technology stack includes Next.js, Joy UI, LangchainJS, PostgreSQL, Prisma, and Qdrant, inspired by the ChatGPT Retrieval Plugin.
start-machine-learning
Start Machine Learning in 2024 is a comprehensive guide for beginners to advance in machine learning and artificial intelligence without any prior background. The guide covers various resources such as free online courses, articles, books, and practical tips to become an expert in the field. It emphasizes self-paced learning and provides recommendations for learning paths, including videos, podcasts, and online communities. The guide also includes information on building language models and applications, practicing through Kaggle competitions, and staying updated with the latest news and developments in AI. The goal is to empower individuals with the knowledge and resources to excel in machine learning and AI.
quadratic
Quadratic is a modern multiplayer spreadsheet application that integrates Python, AI, and SQL functionalities. It aims to streamline team collaboration and data analysis by enabling users to pull data from various sources and utilize popular data science tools. The application supports building dashboards, creating internal tools, mixing data from different sources, exploring data for insights, visualizing Python workflows, and facilitating collaboration between technical and non-technical team members. Quadratic is built with Rust + WASM + WebGL to ensure seamless performance in the browser, and it offers features like WebGL Grid, local file management, Python and Pandas support, Excel formula support, multiplayer capabilities, charts and graphs, and team support. The tool is currently in Beta with ongoing development for additional features like JS support, SQL database support, and AI auto-complete.
bee
Bee is an easy and high efficiency ORM framework that simplifies database operations by providing a simple interface and eliminating the need to write separate DAO code. It supports various features such as automatic filtering of properties, partial field queries, native statement pagination, JSON format results, sharding, multiple database support, and more. Bee also offers powerful functionalities like dynamic query conditions, transactions, complex queries, MongoDB ORM, cache management, and additional tools for generating distributed primary keys, reading Excel files, and more. The newest versions introduce enhancements like placeholder precompilation, default date sharding, ElasticSearch ORM support, and improved query capabilities.
AI-Engineering.academy
AI Engineering Academy aims to provide a structured learning path for individuals looking to learn Applied AI effectively. The platform offers multiple roadmaps covering topics like Retrieval Augmented Generation, Fine-tuning, and Deployment. Each roadmap equips learners with the knowledge and skills needed to excel in applied GenAI. Additionally, the platform will feature Hands-on End-to-End AI projects in the future.
TagUI
TagUI is an open-source RPA tool that allows users to automate repetitive tasks on their computer, including tasks on websites, desktop apps, and the command line. It supports multiple languages and offers features like interacting with identifiers, automating data collection, moving data between TagUI and Excel, and sending Telegram notifications. Users can create RPA robots using MS Office Plug-ins or text editors, run TagUI on the cloud, and integrate with other RPA tools. TagUI prioritizes enterprise security by running on users' computers and not storing data. It offers detailed logs, enterprise installation guides, and support for centralised reporting.
20 - OpenAI Gpts
VbaMaster!
Excel vba Assistant,Press ALT + F11 to paste the code onto the active sheet, and press the triangle play button.
POWERBI_AI
“Data Deep Dive”: This is an expert AI tool for Excel and Power BI. Get expert help with DAX, Power Query, VBA, data models, and visualizations. Ideal for all levels: from basic functions to advanced analytics.
Excelのショートカットキー答えられるかな?クイズジェネレーター
私はExcelのショートカットキーのクイズを出題するボットです。私の出した問題に正しく回答してください。採点します。
Excel Sheet
Generates text-based Excel sheets with 10 rows and 12 columns (A to L), executes formulas, and provides results without explanations.