Best AI tools for< Spreadsheet Automation >

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.

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.

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.

Axiom.ai is a no-code browser automation tool that allows users to automate website actions and repetitive tasks on any website or web app. It is a Chrome Extension that is simple to install and free to try. Once installed, users can pin Axiom to the Chrome Toolbar and click on the icon to open and close. Users can build custom bots or use templates to automate actions like clicking, typing, and scraping data from websites. Axiom.ai can be integrated with Zapier to trigger automations based on external events.

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.

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.

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.

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.

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.

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.

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.

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.

Bitscale is an AI tool designed to help growth teams build scalable AI workflows. It empowers growth teams to research prospects, personalize reachouts, and generate A+ content. The tool allows users to research prospects at scale in an intuitive spreadsheet UI, enrich data from 20+ sources, and build outreach campaigns in an Excel-like interface. With features like sales booster, personalized outreach, and utilizing powerful enrichment from Google News and landing pages, Bitscale aims to enhance lead profiles and provide unmatched speed and scalability for marketing challenges. Trusted by fast-growing companies worldwide, Bitscale offers marketing magic by finding topics, generating SEO-optimized content, and helping users rank on Google quickly.

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.

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.

Manaflow is an AI tool designed to help businesses automate repetitive internal workflows involving data, APIs, and actions. It allows users to program AI agents to operate internal tools using natural language. Manaflow aims to transform tedious manual spreadsheet and software tasks into automated workflows, enabling businesses to scale with AI technology. The platform offers a variety of templates for operations, sales, and research, making it easier for users to start automating tasks. With Manaflow, users can oversee AI agents managing technical workflows, update them as needed, and focus on higher-level automations.

Osher.ai is a personal AI for businesses that allows users to interact with websites, intranets, knowledge bases, process documents, spreadsheets, and procedures. It can be used to train custom AIs on internal knowledge bases, process documents, and files. Osher.ai also offers private and public AIs, and users can customize their AIs' personality, purpose, and welcome message.

Tomat.AI is an AI-powered tool designed to help users open and explore large CSV files effortlessly. With features like automated data profiling, merging multiple files, and building reports, Tomat.AI simplifies the process of analyzing and automating Excel and CSV files without the need for coding skills. The tool ensures data security by operating entirely on the user's local machine, offering a user-friendly interface for seamless data manipulation and analysis.

Scratchpad is an AI-powered workspace designed for sales teams to streamline their sales processes and enhance productivity. It offers a range of features such as AI Sales Assistant, Pipeline Management, Deal Rooms, Automations & Enablement, and Deal Inspection. With Scratchpad, sales teams can benefit from real-time notes, call summaries, and transcripts, as well as AI prompts for sales processes. The application aims to simplify sales execution, improve CRM hygiene, and provide better deal control through automation and in-line coaching.

Scratchpad is an AI-powered workspace designed for sales teams to streamline their sales processes and enhance productivity. It offers features such as AI Sales Assistant, Pipeline Management, Slack Deal Rooms, Automations & Enablement, Deal Inspection, and Sales Forecasting. With Scratchpad, sales teams can automate collaboration, improve Salesforce hygiene, track deal progress, and gain insights into deal movement and pipeline changes. The application aims to simplify sales workflows, provide real-time notes and call summaries, and enhance team collaboration for better performance and efficiency.

A curated list of Generative AI projects, tools, artworks, and models

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.

ai-collective-tools is an open-source community dedicated to creating a comprehensive collection of AI tools for developers, researchers, and enthusiasts. The repository provides a curated selection of AI tools and resources across various categories such as 3D, Agriculture, Art, Audio Editing, Avatars, Chatbots, Code Assistant, Cooking, Copywriting, Crypto, Customer Support, Dating, Design Assistant, Design Generator, Developer, E-Commerce, Education, Email Assistant, Experiments, Fashion, Finance, Fitness, Fun Tools, Gaming, General Writing, Gift Ideas, HealthCare, Human Resources, Image Classification, Image Editing, Image Generator, Interior Designing, Legal Assistant, Logo Generator, Low Code, Models, Music, Paraphraser, Personal Assistant, Presentations, Productivity, Prompt Generator, Psychology, Real Estate, Religion, Research, Resume, Sales, Search Engine, SEO, Shopping, Social Media, Spreadsheets, SQL, Startup Tools, Story Teller, Summarizer, Testing, Text to Speech, Text to Image, Transcriber, Travel, Video Editing, Video Generator, Weather, Writing Generator, and Other Resources.

Awesome-Segment-Anything is a powerful tool for segmenting and extracting information from various types of data. It provides a user-friendly interface to easily define segmentation rules and apply them to text, images, and other data formats. The tool supports both supervised and unsupervised segmentation methods, allowing users to customize the segmentation process based on their specific needs. With its versatile functionality and intuitive design, Awesome-Segment-Anything is ideal for data analysts, researchers, content creators, and anyone looking to efficiently extract valuable insights from complex datasets.

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.

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.

A comprehensive repository of resources for Chinese large language models (LLMs), including data processing tools, fine-tuning frameworks, inference libraries, evaluation platforms, RAG engines, agent frameworks, books, courses, tutorials, and tips. The repository covers a wide range of tools and resources for working with LLMs, from data labeling and processing to model fine-tuning, inference, evaluation, and application development. It also includes resources for learning about LLMs through books, courses, and tutorials, as well as insights and strategies from building with LLMs.

Mutahunter is an open-source language-agnostic mutation testing tool maintained by CodeIntegrity. It leverages LLM models to inject context-aware faults into codebase, ensuring comprehensive testing. The tool aims to empower companies and developers to enhance test suites and improve software quality by verifying the effectiveness of test cases through creating mutants in the code and checking if the test cases can catch these changes. Mutahunter provides detailed reports on mutation coverage, killed mutants, and survived mutants, enabling users to identify potential weaknesses in their test suites.

CB-Tumblebug (CB-TB) is a system for managing multi-cloud infrastructure consisting of resources from multiple cloud service providers. It provides an overview, features, and architecture. The tool supports various cloud providers and resource types, with ongoing development and localization efforts. Users can deploy a multi-cloud infra with GPUs, enjoy multiple LLMs in parallel, and utilize LLM-related scripts. The tool requires Linux, Docker, Docker Compose, and Golang for building the source. Users can run CB-TB with Docker Compose or from the Makefile, set up prerequisites, contribute to the project, and view a list of contributors. The tool is licensed under an open-source license.

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.

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.

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.

Automatically prompts for and merges spreadsheets.

Expert in Google Sheets, offering detailed assistance and modifications.

Google Sheets tutor with a knack for automation and tutorials.

Performs a task

Magically turning text from emails, lists and website content into spreadsheet tables

Freak in the Sheets!

Excel spreadsheet data analysis expert

Specialist in game dialogue translation with ID preservation and spreadsheet formatting.

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.

Generates text-based Excel sheets with 10 rows and 12 columns (A to L), executes formulas, and provides results without explanations.

Converts Excel screenshots into editable files.

私はExcelのショートカットキーのクイズを出題するボットです。私の出した問題に正しく回答してください。採点します。

Expert in Google Sheets, assisting with formulas, scripts, and more.

Friendly Excel and Google Sheets guide, making complex concepts easy.

Excel wizard for finance pros

こちらで用意したスプレッドシートのテンプレートにポケモンを記載していただき、それを基にパーティー構築を行います。

Upload your Excel files, then merge them!

I create pivot tables in Excel as per instructions.