AiExtract Function

AIEXTRACT() Description

The AIEXTRACT() function is designed to extract data from cells using AI directly in the Excel (Calc) worksheet.

To extract data from cells, 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.

Main Characteristics of the AIEXTRACT Function

Syntax:

=AIEXTRACT(Prompt; Context)

Parameters:

• Prompt: Text containing instructions for data extraction.
• Context: A reference to cells containing text with data.

Example Usage

Suppose you need to extract specific data from each cell. You just need to enter the AIEXTRACT() formula and specify the prompt with instructions, and Excel (Calc) will automatically extract the data using AI:

=AIEXTRACT(Prompt; {Context})

We will get the following result:

In this example, the following values are used:

• Prompt: B1 - Cell with text for the prompt ("Phone numbers").
• Context: B5:B14 - Range of cells containing data ({Context}).

How It Works?

Simply enter the AIEXTRACT() function into any cell, specifying the prompt text and the range of cells from which you want to extract data. After that, press Ctrl+Shift+Enter to enter the array formula, and Excel (Calc) will automatically extract the data.

To select all cells associated with the array formula, simply 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 choose Formula to Value.

Download extension

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

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