Create and edit tables with AI in Excel

Artificial intelligence (AI) can support different work steps in Excel, whether creating a table or analyzing it. Using AI tools for Excel, or functions based on artificial intelligence, helps minimize errors and automate tedious work steps.

What is AI for Excel?

An AI for Excel is a function or tool that uses the possibilities of artificial intelligence to make working with Excel easier and better. Different solutions also take different approaches to helping users with their work. While some AI tools generate Excel formulas or help create large tables, others automate data analysis of already created tables. Whichever option you choose, the main aim is to simplify daily work with tables and reduce errors.

What AI exists for Excel?

Although there are several AI tools for Excel, some are still in development and may be unreliable for large spreadsheet tasks. The following Excel AIs are however recommended and cover a wide range of different functions.

Formula Bot

As its name suggests, Formula Bot is an AI for formulas in Excel, Google Sheets and other apps. The tool is very simple to use: users enter requests in English and the tool transforms these requests into formulas in the sometimes complex language of spreadsheets. As the formulas can differ from one spreadsheet to another, the use of this tool considerably reduces the learning effort and the risk of error. Even if you don't understand the formulas used, Formula Bot fixes it by explaining them to you. Another important feature of the tool is the instruction generation option. The program guides you step by step through a task.

This AI tool for Excel is free for up to 10 requests per month. For more frequent use, a subscription is required from €17 per month. For a one-time payment, there is also a ready-to-use extension that allows you to integrate the bot directly in Excel.

Data Analysis in Microsoft Excel

Microsoft Excel also uses AI for different functions. A very useful option of the program is thedata analysis (formerly called “Ideas”). All you have to do is select the desired areas in your table and let Excel's AI analyze them. It is thus possible not only to quickly have an overview of certain models and particularities, but also to visualize them in the form of diagrams, graphs, etc. In this way, the understanding and sharing of data can be significantly improved.

The basis of this Excel AI function is Microsoft 365 Copilot. This AI-powered assistant understands natural language and is based on advanced language models such as OpenAI's GPT-4. This is why it is able to process large amounts of data, recognize patterns and present them in an understandable form.

Rows AI

Rows AI enables extensive data analysis with a simple question-and-answer approach. This uses AI on Excel toanalyze and summarize data from different aspectsunder the principle of questions and answers. Its use is intuitive and requires little prior knowledge. The program can also be used for data transformation and corresponding inputs. Another central aspect of Rows AI is the data cleaning. Using AI, unstructured or erroneous data can be automatically corrected and standardized, significantly improving the quality of analytics.

GPT Excel

GPT Excel uses AI to generate formulas and create complex tablesbased on a GPT model optimized for Excel. This tool also uses simple questions, in English, and transforms them into search code. GPT Excel is already able to meet a large number of requests and continues to grow. This AI tool for Excel, which is also compatible with Google Sheets, supports a large number of queries and is constantly evolving.

THE benefits creating tables with AI:

• Save time : Even complex tables are created in minutes.
• Flexibility : AI adapts to your specific needs.
• Easy to use : in-depth technical knowledge is not necessary. As long as the AI ​​knows the appropriate formula or function, it will provide the corresponding result.

Create an Excel table with AI

It is already possible to create an Excel table with AI. Tools like ChatGPT can analyze texts or datasets And generate statements or tables easy to use in Excel. For this, only a few steps are necessary. These are similar for most programs. In our example, we use ChatGPT.

1. Go to the ChatGPT website.
2. Log in with your account ChatGPT. If you don't have an account yet, simply create one.
3. Give the tool the desired instruction. To do this, you can use wording such as “ Create a table for me with… « . Then indicate the number of columns and rows desired as well as the corresponding categories.
4. You can also ask ChatGPT to transform a specific text or record into a table. Generally speaking, the more specific your instructions are, the closer the end result will be to your expectations.
5. When the table has been created as you want, copy and stick it in the Excel document of your choice. For a better presentation, you can then make adjustments directly in Excel.