Loading page
About this tool
Build Excel Copilot prompts that name the exact sheet, A1 range and column headers, with grid limits validated before you paste.
Excel Copilot Prompt Builder assembles a spreadsheet-assistant prompt that names the exact worksheet, the A1 range, the header row and every column letter, so Copilot works on the cells you meant rather than guessing. The range you type is validated against the .xlsx worksheet grid — 1,048,576 rows and 16,384 columns ending at XFD — and the tool counts rows, data rows and total cells before it writes the prompt. It is for anyone whose Copilot answers keep referencing columns that do not exist or silently skipping part of the data.
Open Excel Copilot Prompt Builder on AltFTool — it loads instantly in your browser.
Add your input to the workspace.
Adjust the options until the result looks right.
Copy or download the output and put it to work.
Rejects ranges past column XFD or row 1,048,576 before you waste a Copilot turn on them.
Pairs each header you list with the column letter it sits in, so references cannot drift.
The prompt is assembled locally; no cell values are typed in or sent anywhere.
Name the worksheet, give the range in A1 notation, say which row holds the headers, list the column names, and state one specific outcome. Copilot has no reliable way to infer which of several tables on a sheet you mean, so an unnamed range is the single most common cause of an answer that looks right but reads the wrong cells.
Several Copilot analysis features in Excel require the data to be formatted as an Excel table, which you create by selecting the range and pressing Ctrl+T. A table gives the range a name and stable structured references such as SalesData[Revenue], so formulas keep pointing at the right column when rows are added.
A worksheet in the .xlsx format holds 1,048,576 rows and 16,384 columns, the last column being XFD, and a single formula is capped at 8,192 characters. Worksheet names are limited to 31 characters and cannot contain : \ / ? * [ or ].
No. You type a sheet name, a range and your column headers — never the cell values — and the prompt is built entirely in your browser. Copy the result and paste it into Copilot yourself, which also means you can review the wording before anything touches your workbook.