AiTable Function

AITABLE() Description

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

To generate tables, this function uses the 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 cells containing column names.

Usage Example

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:

The following values are used in this example:

• Prompt: B1 - Cell with text for the prompt ("Create table with 10 random countries").
• Header: A4:D4 - Range of cells containing headers for the 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. After that, 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 an array formula, simply select any array cell 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).