# GPT\_TABLE formula

## Generate a full table of data with =GPT\_TABLE

You can generate a full table of data with GPT for Sheets, you can specify the number of columns too!

<figure><img src="https://1096151144-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGl9bWvDp1A2xWk189Yux%2Fuploads%2FZd4BI25TXSbvhFXn4IML%2Funnamed%20(5).gif?alt=media&#x26;token=3b001706-e8f6-4a32-b590-dd8301db456a" alt=""><figcaption></figcaption></figure>

To get started, select a cell and input then use the following formula

**`=GPT_TABLE(prompt, value, temperature, model, cache)`**

<table><thead><tr><th width="164">Parameter</th><th width="444">Description</th><th>Default</th></tr></thead><tbody><tr><td><code>prompt</code></td><td><p>the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand")</p><p><strong>required</strong></p></td><td>""</td></tr><tr><td><code>value</code></td><td>The cell you are referring to in your prompt (ex: A1)</td><td>null</td></tr><tr><td><code>temperature</code></td><td>Between 0 (not creative) and 2 (very creative)</td><td>0</td></tr><tr><td><code>model</code></td><td><code>standard</code> or <code>advanced</code> (gpt-4o-mini or gpt-4o)</td><td><code>standard</code></td></tr><tr><td><code>bypassCache</code></td><td>Bypass the cache and query openai again. The results will be differents than before.</td><td>false</td></tr></tbody></table>