Generative AI

Updated at:

Jun 4, 2024

Category:

AI

The Generative AI function is a feature that allows you to apply ChatGPT/Claude/Gemini to each cell in an Excel spreadsheet, generating text, insights, or suggestions based on the data in that cell.

See it in Action

Requirements

Data

  • Data Input: Drag and drop the files you want to merge.

  • Columns Included: Check this option if your selected range includes the first row as column headers. This ensures that the first row is recognized as column names and excluded from the processing.

  • Model(s) & API keys

    • ChatGPT/Claude/Gemini

  • Prompt

Fill empty cells with

  • Keep Empty: Leave cells that are empty as is, without adding any text.

  • Forward Fill: Copy the value from the nearest non-empty cell above into empty cells before adding the specified letters or text.

  • Backward Fill: Copy the value from the nearest non-empty cell below into empty cells before adding the specified letters or text.

  • -: Fill empty cells with a letter "-".

  • 0: Fill empty cells with a letter "0".

  • Custom: Allows for a custom value or text to be inserted into empty cells prior to adding the specified letters.

Result Destination

Specify the starting cell where the results will be placed.

Related Articles and Topics