Best AI tools for< excel user >
20 - AI tool Sites
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.
Formula Bot
Formula Bot is an AI-powered tool that helps users convert text into Excel formulas, SQL queries, VBA, Google Apps Scripts, regex, and more. It also offers data analysis features such as sentiment analysis, text classification, and freeform generation. The tool is designed to help users work faster and smarter with data and spreadsheets.
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.
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.
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.
Pgrammer
Pgrammer is an AI-powered platform designed to help users practice coding interview questions effectively. It offers a personalized learning experience with hints and analysis credits to enhance coding skills and boost confidence. Unlike traditional methods like LeetCode, Pgrammer provides a diverse set of questions for over 20 programming languages, ensuring users are well-prepared for coding interviews. The platform utilizes GPT-4 technology to simulate a FAANG level software engineer conducting an interview, providing real-time hints, feedback, and solution analysis. Pgrammer aims to streamline the preparation process and offer a supportive environment for users to excel in coding interviews.
Formula Bot Tools
Formula Bot Tools is a website that provides AI-powered tools for working with data and spreadsheets. The website offers a variety of generators, including an Excel formula generator, a SQL query generator, and a spreadsheet generator. It also offers a data analyzer that can help users analyze their data through a simple conversation. Additionally, the website offers AI in spreadsheets, which can help users automate boring tasks. The website is trusted by Fortune 500, government, and small and medium-sized businesses.
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.
Excel Bot
Excel Bot is an AI assistant for Excel and Google Sheets that helps users work faster and smarter. It offers a range of features including the ability to convert text to formulas, generate VBA instructions, and get explanations of formulas. Excel Bot is trusted by over 5000+ happy customers and is available as an add-on for Excel and Google Sheets.
AutoQuery GPT
AutoQuery GPT is a tool that allows users to ask questions to ChatGPT and get answers automatically. It provides users with time-saving and performance benefits. Users can use this site by using their own API key to ask questions to ChatGPT and save the answers as a file, using the Query Block and Query Excel features.
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.
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.
BlogNLP
BlogNLP is an AI-powered writing assistant that helps users create high-quality content faster and more efficiently. It offers a range of features to help users with tasks such as generating blog posts, marketing copy, essays, and website content. BlogNLP also provides SEO optimization suggestions to help users improve the visibility of their content in search engine results.
Interflexion
Interflexion is an AI-powered role-play application designed to help professionals enhance their leadership and interpersonal skills through guided practice and personalized feedback. The platform offers personalized coaching with AI superpowers, microlearning scenarios, professional curriculum, and simple content creation. Users can interact naturally through voice, video, and text, receive actionable feedback for deliberate practice, and track their progress over time. Interflexion aims to provide professionals with a convenient and effective way to develop their skills and become the best versions of themselves.
Syllabus Generator
Syllabus Generator is an AI-powered tool designed to streamline the process of creating course syllabi for educators. It offers a user-friendly interface to input course details, customize syllabus outlines, and export them in various formats. The tool leverages AI technology to generate structured syllabus templates, making educational planning efficient and personalized.
Formularizer
Formularizer is an AI-powered assistant that helps users create formulas in Excel, Google Sheets, and Notion. It supports a variety of formula types, including Excel, Google Apps Script, and regular expressions. Formularizer can generate formulas from natural language instructions, explain how formulas work, and even help users debug their formulas. It is designed to be user-friendly and accessible to everyone, regardless of their level of expertise.
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.
Vizly
Vizly is an AI-powered data analysis tool that empowers users to make the most of their data. It allows users to chat with their data, visualize insights, and perform complex analysis. Vizly supports various file formats like CSV, Excel, and JSON, making it versatile for different data sources. The tool is free to use for up to 10 messages per month and offers a student discount of 50%. Vizly is suitable for individuals, students, academics, and organizations looking to gain actionable insights from their data.
ChartPixel
ChartPixel is an AI-powered data analysis tool that helps users visualize and understand their data in seconds. With ChartPixel, you can upload your data file or questionnaire and let the AI auto-generate a gallery of charts with insightfully written AI-assisted annotations and statistics. This makes it easy to explore the quirks and patterns in your data, even if you're a data novice. ChartPixel also offers a variety of features to help you save time and effort, such as data cleaning, formatting charts, extracting trends and insights, and presenting and collaborating. With ChartPixel, you can get data-driven insights in seconds, without the need for steep learning curve.
LedgerBox
LedgerBox is an intelligent document processing tool that leverages artificial intelligence and machine learning to automate the extraction of valuable data from various documents such as bank statements, invoices, and receipts. It helps streamline tasks like data entry, financial auditing, expense management, tax preparation, and more, by efficiently processing structured, semi-structured, and unstructured documents. With LedgerBox, users can improve accuracy, reduce manual errors, and enhance operational efficiency in tasks related to financial management and compliance monitoring.
20 - Open Source Tools
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.
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.
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.
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).
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.
ComfyUI-BlenderAI-node
ComfyUI-BlenderAI-node is an addon for Blender that allows users to convert ComfyUI nodes into Blender nodes seamlessly. It offers features such as converting nodes, editing launch arguments, drawing masks with Grease pencil, and more. Users can queue batch processing, use node tree presets, and model preview images. The addon enables users to input or replace 3D models in Blender and output controlnet images using composite. It provides a workflow showcase with presets for camera input, AI-generated mesh import, composite depth channel, character bone editing, and more.
RecAI
RecAI is a project that explores the integration of Large Language Models (LLMs) into recommender systems, addressing the challenges of interactivity, explainability, and controllability. It aims to bridge the gap between general-purpose LLMs and domain-specific recommender systems, providing a holistic perspective on the practical requirements of LLM4Rec. The project investigates various techniques, including Recommender AI agents, selective knowledge injection, fine-tuning language models, evaluation, and LLMs as model explainers, to create more sophisticated, interactive, and user-centric recommender systems.
kor
Kor is a prototype tool designed to help users extract structured data from text using Language Models (LLMs). It generates prompts, sends them to specified LLMs, and parses the output. The tool works with the parsing approach and is integrated with the LangChain framework. Kor is compatible with pydantic v2 and v1, and schema is typed checked using pydantic. It is primarily used for extracting information from text based on provided reference examples and schema documentation. Kor is designed to work with all good-enough LLMs regardless of their support for function/tool calling or JSON modes.
TalkWithGemini
Talk With Gemini is a web application that allows users to deploy their private Gemini application for free with one click. It supports Gemini Pro and Gemini Pro Vision models. The application features talk mode for direct communication with Gemini, visual recognition for understanding picture content, full Markdown support, automatic compression of chat records, privacy and security with local data storage, well-designed UI with responsive design, fast loading speed, and multi-language support. The tool is designed to be user-friendly and versatile for various deployment options and language preferences.
Open-Interface
Open Interface is a self-driving software that automates computer tasks by sending user requests to a language model backend (e.g., GPT-4V) and simulating keyboard and mouse inputs to execute the steps. It course-corrects by sending current screenshots to the language models. The tool supports MacOS, Linux, and Windows, and requires setting up the OpenAI API key for access to GPT-4V. It can automate tasks like creating meal plans, setting up custom language model backends, and more. Open Interface is currently not efficient in accurate spatial reasoning, tracking itself in tabular contexts, and navigating complex GUI-rich applications. Future improvements aim to enhance the tool's capabilities with better models trained on video walkthroughs. The tool is cost-effective, with user requests priced between $0.05 - $0.20, and offers features like interrupting the app and primary display visibility in multi-monitor setups.
OAD
OAD is a powerful open-source tool for analyzing and visualizing data. It provides a user-friendly interface for exploring datasets, generating insights, and creating interactive visualizations. With OAD, users can easily import data from various sources, clean and preprocess data, perform statistical analysis, and create customizable visualizations to communicate findings effectively. Whether you are a data scientist, analyst, or researcher, OAD can help you streamline your data analysis workflow and uncover valuable insights from your data.
quivr
Quivr is a personal assistant powered by Generative AI, designed to be a second brain for users. It offers fast and efficient access to data, ensuring security and compatibility with various file formats. Quivr is open source and free to use, allowing users to share their brains publicly or keep them private. The marketplace feature enables users to share and utilize brains created by others, boosting productivity. Quivr's offline mode provides anytime, anywhere access to data. Key features include speed, security, OS compatibility, file compatibility, open source nature, public/private sharing options, a marketplace, and offline mode.
DeepBI
DeepBI is an AI-native data analysis platform that leverages the power of large language models to explore, query, visualize, and share data from any data source. Users can use DeepBI to gain data insight and make data-driven decisions.
HuixiangDou
HuixiangDou is a **group chat** assistant based on LLM (Large Language Model). Advantages: 1. Design a two-stage pipeline of rejection and response to cope with group chat scenario, answer user questions without message flooding, see arxiv2401.08772 2. Low cost, requiring only 1.5GB memory and no need for training 3. Offers a complete suite of Web, Android, and pipeline source code, which is industrial-grade and commercially viable Check out the scenes in which HuixiangDou are running and join WeChat Group to try AI assistant inside. If this helps you, please give it a star ⭐
vector-vein
VectorVein is a no-code AI workflow software inspired by LangChain and langflow, aiming to combine the powerful capabilities of large language models and enable users to achieve intelligent and automated daily workflows through simple drag-and-drop actions. Users can create powerful workflows without the need for programming, automating all tasks with ease. The software allows users to define inputs, outputs, and processing methods to create customized workflow processes for various tasks such as translation, mind mapping, summarizing web articles, and automatic categorization of customer reviews.
HuggingFists
HuggingFists is a low-code data flow tool that enables convenient use of LLM and HuggingFace models. It provides functionalities similar to Langchain, allowing users to design, debug, and manage data processing workflows, create and schedule workflow jobs, manage resources environment, and handle various data artifact resources. The tool also offers account management for users, allowing centralized management of data source accounts and API accounts. Users can access Hugging Face models through the Inference API or locally deployed models, as well as datasets on Hugging Face. HuggingFists supports breakpoint debugging, branch selection, function calls, workflow variables, and more to assist users in developing complex data processing workflows.
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.
llm-analysis
llm-analysis is a tool designed for Latency and Memory Analysis of Transformer Models for Training and Inference. It automates the calculation of training or inference latency and memory usage for Large Language Models (LLMs) or Transformers based on specified model, GPU, data type, and parallelism configurations. The tool helps users to experiment with different setups theoretically, understand system performance, and optimize training/inference scenarios. It supports various parallelism schemes, communication methods, activation recomputation options, data types, and fine-tuning strategies. Users can integrate llm-analysis in their code using the `LLMAnalysis` class or use the provided entry point functions for command line interface. The tool provides lower-bound estimations of memory usage and latency, and aims to assist in achieving feasible and optimal setups for training or inference.
renpy-translator
Renpy Translator is a free and open-source tool designed for translating Ren'py games. It supports various translation services such as Google, Youdao, Deepl, OpenAI, and more. The tool can automatically translate game content, extract untranslated words, replace fonts, and add language preferences. It aims to assist in game translation work by providing a user-friendly interface and supporting multiple languages. The translated contents may not be accurate due to auto-translation, so users are encouraged to review and modify translations as needed.
ChatGPT-On-CS
ChatGPT-On-CS is an intelligent chatbot tool based on large models, supporting various platforms like WeChat, Taobao, Bilibili, Douyin, Weibo, and more. It can handle text, voice, and image inputs, access external resources through plugins, and customize enterprise AI applications based on proprietary knowledge bases. Users can set custom replies, utilize ChatGPT interface for intelligent responses, send images and binary files, and create personalized chatbots using knowledge base files. The tool also features platform-specific plugin systems for accessing external resources and supports enterprise AI applications customization.
20 - OpenAI Gpts
CorpSpeak Pro
Specializing in crafting concise, professional corporate emails, CorpSpeak Pro excels in translating emotions and intentions into formal language. This tool expertly navigates legal and corporate norms, ensuring clear, jargon-efficient communication tailored to specific user needs.
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.
VbaMaster!
Excel vba Assistant,Press ALT + F11 to paste the code onto the active sheet, and press the triangle play button.
Interview Pro
By combining the expertise of top career coaches with advanced AI, our GPT helps you excel in interviews across various job functions and levels. We've also compiled the most practical tips for you | We value your experience, please contact [email protected] if you need support ❤️!