Best AI tools for< Spreadsheet User >
Infographic
20 - AI tool Sites
Goodlookup
Goodlookup is a smart function for spreadsheet users that gets very close to semantic understanding. It’s a pre-trained model that has the intuition of GPT-3 and the join capabilities of fuzzy matching. Use it like vlookup or index match to speed up your topic clustering work in google sheets!
Tablesmith
Tablesmith is a free, privacy-first, and intuitive spreadsheet automation tool that allows users to build reusable data flows, effortlessly sort, filter, group, format, or split data across files/sheets based on cell values. It is designed to be easy to learn and use, with a focus on privacy and cross-platform compatibility. Tablesmith also offers an AI autofill feature that suggests and fills in information based on the user's prompt.
Array Assistant
Array Assistant is an AI-driven tool designed to supercharge spreadsheet productivity. It offers a wide range of features such as creating formulas, cleaning data, summarizing text, explaining problems, and designing automations. Whether you are a professional, student, or spreadsheet user, Array Assistant can help you enhance your workflow and save time. With a user-friendly interface and innovative AI technology, Array Assistant revolutionizes the way you work with spreadsheets.
Spreadsheet.com
Spreadsheet.com is an online spreadsheet that allows users to build no-code solutions for project management, CRM, and other tasks. It offers features such as sheet views, Gantt charts, Kanban boards, form views, calendar views, attachments, related rows, charts, reports, dashboards, automations, integrations, and Spreadsheet AI. Spreadsheet.com also provides a variety of templates for specific use cases, such as project management, sales and CRM, product development, finance and accounting, lists and checklists, HR and recruiting, small business, personal, team collaboration, marketing, IT and support, construction, education, real estate, startups, and nonprofits.
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.
Spreadsheet Daddy
Spreadsheet Daddy is an AI-powered add-on for Google Sheets that enables users to automate tasks, generate content, extract data, and perform various other functions using advanced AI models like GPT-4 and GPT-4-32k. It seamlessly integrates with Google Sheets, allowing users to leverage the power of AI within their spreadsheets. With its user-friendly interface and diverse range of features, Spreadsheet Daddy empowers businesses and individuals to enhance their productivity and efficiency.
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.
Mito
Mito is a low-code data app infrastructure that allows users to edit spreadsheets and automatically generate Python code. It is designed to help analysts automate their repetitive Excel work and take automation into their own hands. Mito is a Jupyter extension and Streamlit component, so users don't need to set up any new infrastructure. It is easy to get started with Mito, simply install it using pip and start using it in Jupyter or Streamlit.
SearchGPT
SearchGPT is an AI tool that offers a Spreadsheet Generator feature. Users can enter a prompt and generate a spreadsheet based on the given instructions. The tool can handle complicated spreadsheets, although they may take some time to generate. SearchGPT is designed to assist users in creating spreadsheets efficiently and accurately.
Deepsheet
Deepsheet is a cloud-based spreadsheet application that uses artificial intelligence to help users analyze and visualize data. It offers a variety of features, including the ability to import data from a variety of sources, create charts and graphs, and perform data analysis. Deepsheet is designed to be easy to use, even for users with no prior experience with spreadsheets.
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.
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.
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.
Quadratic
Quadratic is an infinite spreadsheet with Python, SQL, and AI. It combines the familiarity of a spreadsheet with the power of code, allowing users to analyze data, write code, and create visualizations in a single environment. With built-in Python library support, users can bring open source tools directly to their spreadsheets. Quadratic also features real-time collaboration, allowing multiple users to work on the same spreadsheet simultaneously. Additionally, Quadratic is built for speed and performance, utilizing Web Assembly and WebGL to deliver a smooth and responsive experience.
Charm
Charm is an AI-powered spreadsheet assistant that helps users clean messy data, create content, summarize feedback, classify sales leads, and generate dummy data. It is a Google Sheets add-on that automates tasks that are impossible to do with traditional formulas. Charm is used by hundreds of analysts, marketers, product managers, and more.
BuildShip
BuildShip is a batch processing tool for ChatGPT that allows users to process ChatGPT tasks in parallel on a spreadsheet UI with CSV/JSON import and export. It supports various OpenAI models, including GPT4, Claude 3, and Gemini. Users can start with readymade templates and customize them with their own logic and models. The data generated is stored securely on the user's own Google Cloud project, and team collaboration is supported with granular access control.
Prompting Sheets
Prompting Sheets is an AI-powered spreadsheet add-on for Google Sheets that revolutionizes project planning and task management. It offers customizable project plans and to-do lists tailored to individual business needs, streamlining workflows and boosting productivity. With features like AI Chatbot, customizable prompts, and prompt optimization, Prompting Sheets simplifies complex tasks, automates processes, and enhances user experience. The application leverages AI capabilities for data analysis and content creation, providing real-time data queries and dynamic solutions directly within Google Sheets.
Bricks
Bricks is an AI-first spreadsheet application that simplifies the process of creating and sharing reports, presentations, charts, and visuals using your data. It eliminates the need for advanced spreadsheet expertise, allowing users to effortlessly generate various types of content. Bricks offers a wide range of pre-built templates and tools to enhance productivity and creativity in data analysis and visualization.
Browse AI
Browse AI is an AI tool that offers the easiest way to extract and monitor data from any website without the need for coding. Users can train a robot in just 2 minutes to extract specific data in spreadsheet format or monitor data on a schedule. With over 7,000 integrations, Browse AI allows users to scrape structured data, run multiple robots simultaneously, emulate user interactions, handle pagination, and more. Trusted by over 370,000 individuals and teams, Browse AI is a powerful tool for data extraction and monitoring tasks.
Ultimaps
Ultimaps is an AI-powered map visualization tool designed for humans to create color-coded interactive maps in seconds. Users can import data from Excel, Google Spreadsheet, or Notion, or instruct the AI to build a map based on their requirements. The tool allows users to add drawings, change colors and fonts, and easily download, share, or embed the maps. Ultimaps offers features like automatic color-coding based on imported data, customization options, auto-saving of visualizations, and the ability to create interactive maps without any coding. It is a user-friendly platform suitable for various mapping needs.
20 - Open Source Tools
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.
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.
JamAIBase
JamAI Base is an open-source platform integrating SQLite and LanceDB databases with managed memory and RAG capabilities. It offers built-in LLM, vector embeddings, and reranker orchestration accessible through a spreadsheet-like UI and REST API. Users can transform static tables into dynamic entities, facilitate real-time interactions, manage structured data, and simplify chatbot development. The tool focuses on ease of use, scalability, flexibility, declarative paradigm, and innovative RAG techniques, making complex data operations accessible to users with varying technical expertise.
TableLLM
TableLLM is a large language model designed for efficient tabular data manipulation tasks in real office scenarios. It can generate code solutions or direct text answers for tasks like insert, delete, update, query, merge, and chart operations on tables embedded in spreadsheets or documents. The model has been fine-tuned based on CodeLlama-7B and 13B, offering two scales: TableLLM-7B and TableLLM-13B. Evaluation results show its performance on benchmarks like WikiSQL, Spider, and self-created table operation benchmark. Users can use TableLLM for code and text generation tasks on tabular data.
PromptChains
ChatGPT Queue Prompts is a collection of prompt chains designed to enhance interactions with large language models like ChatGPT. These prompt chains help build context for the AI before performing specific tasks, improving performance. Users can copy and paste prompt chains into the ChatGPT Queue extension to process prompts in sequence. The repository includes example prompt chains for tasks like conducting AI company research, building SEO optimized blog posts, creating courses, revising resumes, enriching leads for CRM, personal finance document creation, workout and nutrition plans, marketing plans, and more.
feedgen
FeedGen is an open-source tool that uses Google Cloud's state-of-the-art Large Language Models (LLMs) to improve product titles, generate more comprehensive descriptions, and fill missing attributes in product feeds. It helps merchants and advertisers surface and fix quality issues in their feeds using Generative AI in a simple and configurable way. The tool relies on GCP's Vertex AI API to provide both zero-shot and few-shot inference capabilities on GCP's foundational LLMs. With few-shot prompting, users can customize the model's responses towards their own data, achieving higher quality and more consistent output. FeedGen is an Apps Script based application that runs as an HTML sidebar in Google Sheets, allowing users to optimize their feeds with ease.
RAGHub
RAGHub is a community-driven project focused on cataloging new and emerging frameworks, projects, and resources in the Retrieval-Augmented Generation (RAG) ecosystem. It aims to help users stay ahead of changes in the field by providing a platform for the latest innovations in RAG. The repository includes information on RAG frameworks, evaluation frameworks, optimization frameworks, citation frameworks, engines, search reranker frameworks, projects, resources, and real-world use cases across industries and professions.
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).
promptfoo
Promptfoo is a tool for testing and evaluating LLM output quality. With promptfoo, you can build reliable prompts, models, and RAGs with benchmarks specific to your use-case, speed up evaluations with caching, concurrency, and live reloading, score outputs automatically by defining metrics, use as a CLI, library, or in CI/CD, and use OpenAI, Anthropic, Azure, Google, HuggingFace, open-source models like Llama, or integrate custom API providers for any LLM API.
jailbreak_llms
This is the official repository for the ACM CCS 2024 paper 'Do Anything Now': Characterizing and Evaluating In-The-Wild Jailbreak Prompts on Large Language Models. The project employs a new framework called JailbreakHub to conduct the first measurement study on jailbreak prompts in the wild, collecting 15,140 prompts from December 2022 to December 2023, including 1,405 jailbreak prompts. The dataset serves as the largest collection of in-the-wild jailbreak prompts. The repository contains examples of harmful language and is intended for research purposes only.
Awesome-Tabular-LLMs
This repository is a collection of papers on Tabular Large Language Models (LLMs) specialized for processing tabular data. It includes surveys, models, and applications related to table understanding tasks such as Table Question Answering, Table-to-Text, Text-to-SQL, and more. The repository categorizes the papers based on key ideas and provides insights into the advancements in using LLMs for processing diverse tables and fulfilling various tabular tasks based on natural language instructions.
thepipe
The Pipe is a multimodal-first tool for feeding files and web pages into vision-language models such as GPT-4V. It is best for LLM and RAG applications that require a deep understanding of tricky data sources. The Pipe is available as a hosted API at thepi.pe, or it can be set up locally.
awesome-generative-ai
A curated list of Generative AI projects, tools, artworks, and models
ChainForge
ChainForge is a visual programming environment for battle-testing prompts to LLMs. It is geared towards early-stage, quick-and-dirty exploration of prompts, chat responses, and response quality that goes beyond ad-hoc chatting with individual LLMs. With ChainForge, you can: * Query multiple LLMs at once to test prompt ideas and variations quickly and effectively. * Compare response quality across prompt permutations, across models, and across model settings to choose the best prompt and model for your use case. * Setup evaluation metrics (scoring function) and immediately visualize results across prompts, prompt parameters, models, and model settings. * Hold multiple conversations at once across template parameters and chat models. Template not just prompts, but follow-up chat messages, and inspect and evaluate outputs at each turn of a chat conversation. ChainForge comes with a number of example evaluation flows to give you a sense of what's possible, including 188 example flows generated from benchmarks in OpenAI evals. This is an open beta of Chainforge. We support model providers OpenAI, HuggingFace, Anthropic, Google PaLM2, Azure OpenAI endpoints, and Dalai-hosted models Alpaca and Llama. You can change the exact model and individual model settings. Visualization nodes support numeric and boolean evaluation metrics. ChainForge is built on ReactFlow and Flask.
swarms
Swarms provides simple, reliable, and agile tools to create your own Swarm tailored to your specific needs. Currently, Swarms is being used in production by RBC, John Deere, and many AI startups.
nonebot_plugin_naturel_gpt
NoneBotPluginNaturelGPT is a plugin for NoneBot that enhances the GPT chat AI with more human-like characteristics. It supports multiple customizable personalities, preset sharing, and various features to improve chat interactions. Users can create personalized chat experiences, enable context-aware conversations, and benefit from features like long-term memory, user-specific impressions, and data persistence. The plugin also allows for personality switching, custom trigger words, content blocking, and more. It offers extensive capabilities for enhancing chat interactions and enabling AI to actively participate in conversations.
20 - OpenAI Gpts
Spreadsheet Composer
Magically turning text from emails, lists and website content into spreadsheet tables
Game Translator Pro
Specialist in game dialogue translation with ID preservation and spreadsheet formatting.
LabGPT
The main objective of a personalized ChatGPT for reading laboratory tests is to evaluate laboratory test results and create a spreadsheet with the evaluation results and possible solutions.
Excel Sheet
Generates text-based Excel sheets with 10 rows and 12 columns (A to L), executes formulas, and provides results without explanations.
Excelのショートカットキー答えられるかな?クイズジェネレーター
私はExcelのショートカットキーのクイズを出題するボットです。私の出した問題に正しく回答してください。採点します。
Sheets Savvy - FinShift
Expert in Google Sheets, assisting with formulas, scripts, and more.