Skip to main content

GPTTABLE

The =GPTTABLE()formula generates a structured table across multiple rows and columns. It’s ideal for creating schedules, comparisons, planning grids, or any tabular content.

Formula Syntax​

=GPTTABLE(prompt, [input], [model])

  • prompt (required): Instruction for generating the table. (e.g., "Create a weekly workout schedule" or "Build a product feature comparison.")
  • input (optional): Cell or range providing additional context or supporting data.
  • model (optional): AI model like gpt-4o, gpt-3.5-turbo, or gemini-1.5-pro. Defaults to your settings if not provided.

Example(s)​

Create a 3-day meal plan​

=GPTTABLE("Create a 3-day meal plan including breakfast, lunch, and dinner.")

Build a project timeline using input​

=GPTTABLE("Build a project timeline based on the tasks listed below.", A2:A10)

Generate a product comparison table with a specific model​

=GPTTABLE("Generate a comparison table for these products.", B2:B6, "gpt-4o-mini")
tip

Results are automatically arranged across rows and columns starting from the formula cell. Make sure the area is clear to prevent overwriting.