# =GPTTABLE() Formula Reference for Sheets

> Syntax, parameters, and examples for =GPTTABLE(prompt, input, model), the GPT Mate formula that generates a structured table across rows and columns.

- Source: https://www.8apps.co/docs/gpt-mate/using-gptmate/gpttable
- Markdown: https://www.8apps.co/docs/gpt-mate/using-gptmate/gpttable.md
- Language: en

---
# 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-5`, `gemini-2.5-flash`, or `claude-sonnet-4-6`. Defaults to your settings if not provided.

## Example(s)

### Create a 3-day meal plan

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

### Build a project timeline using input

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

### Generate a product comparison table with a specific model

```plaintext
=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.
:::
