AiFill Function

AIFILL() Description

The AIFILL() function is designed to fill cells with data using AI directly in the spreadsheet of Excel (Calc).

To fill with data, this function uses the large language model Google "Gemini" and can be used in any formulas either independently or in conjunction with other standard functions.

Main Features of the AIFILL Function

Syntax:

=AIFILL(Prompt; Context)

Parameters:

• Prompt: Text containing instructions for data generation.
• Context: Reference to cells containing additional data.

Usage Example

Suppose you need to fill cells with specific data. You just need to enter the AIFILL() formula and specify the prompt with instructions, and Excel (Calc) will automatically generate the data using AI:

=AIFILL(Prompt; {Context})

We will get the following result:

This example uses the following values:

• Prompt: B1 - Cell with the text for the prompt ("Fill capital city for each country").
• Context: B5:B11 - Range of cells containing additional data ({Context}).

How It Works?

Simply enter the AIFILL() function into any cell, specifying the prompt text and the range of cells containing additional data. After that, press Ctrl+Shift+Enter to enter the array formula, and Excel (Calc) will automatically generate the data.

To select all cells related to the array formula, just select any cell in 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 AIFILL() function by installing the YLC Utilities extension.

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