Function AiTable

AITABLE() Description

The AITABLE() function is designed for generating tables using AI directly in the worksheet Excel (Calc).

For generating tables, this function uses a large language model Google "Gemini" and can be used in any formulas both independently and in conjunction with other standard functions.

Key Features of the AITABLE Function

Syntax:

=AITABLE(Prompt; [Header])

Parameters:

• Prompt: The text containing instructions for generating the table.
• [Header]: A reference to the cells that contain the column names.

Example of Use

Suppose you need to create a table with specific data. You just need to enter the AITABLE() formula and specify the prompt with data for the columns, and Excel (Calc) will automatically generate a table using AI:

=AITABLE(Prompt; {Header})

We will get the following result:

In this example, the following values are used:

• Prompt: B1 - Cell with text for the prompt ("Create table with 10 random countries").
• Header: A4:D4 - Range of cells containing headers for columns ("Country", "Capital", "Area", "Population").

How It Works?

Simply enter the AITABLE() function into any cell, specifying the prompt text and the names of the columns you want to create. Then you need to press Ctrl+Shift+Enter to enter the array formula, and Excel (Calc) will automatically generate a table with data.

To select all cells associated with the array formula, simply select any cell of the array and press Ctrl+/.

If you need to convert an array formula to values - select the entire array and in the menu Data > Calculate select Formula to Value.

Download extension

You can use the function AITABLE() by installing the extension YLC Utilities.

After that, this function will be available in all files opened in Excel (LibreOffice Calc).