As of 13 August 2026, AI can create a pivot table from your data.
Most people should do this themselves; the prompt is on this page.
Can you do it?
5 minutesto a draft.
15 minutesto something you’d act on.
Cost, all in£0
Skill neededchat-fluent
Who has to check ityou
What the alternative costsA spreadsheet application is the non-AI alternative; no price is stated here.
If this goes wrong: the pivot groups or sums the data incorrectly, so you find the error by reconciling its totals with the source sheet and rebuild it.
What to actually do
Do it yourself
The route this page recommends
A chat interface, chat-fluent skill, and roughly 15 minutes until you can act on the result.
How to actually do it
- Open the Excel or Google Sheets file containing the data and confirm that the first row has one clear heading for each column.
- Write down the business question the pivot must answer, such as sales by region and month, and identify the relevant date, category and numeric columns.
- Remove no records, but note blank cells, duplicate rows and numbers stored as text, then copy the table including its headings into the prompt.
- Paste the prompt and data into a chatbot, adding the business question in the marked slot, and ask it to produce the pivot layout and exact spreadsheet steps.
- Create the pivot table in Excel or Google Sheets using the proposed row, column, value, aggregation and filter fields.
- Compare the pivot grand total with a direct total of the relevant source column, then check a sample of row and column totals against filtered source data.
- Rename the pivot title and fields so a colleague can understand the report, and save the source data and finished pivot together.
Prompt
Create a pivot table from the data below. First identify the columns and state any assumptions about dates, categories, blank cells, duplicates or numbers stored as text. Then recommend the row field, column field, value field and aggregation method that best answer this question: [state the business question]. If a filter is useful, include it. Produce the result as a clear pivot-table layout with totals, and give exact Excel or Google Sheets steps to recreate it. Do not invent, delete or alter source records. Flag any rows that cannot be classified or summarised reliably. After creating the pivot, reconcile its grand total against the relevant source-data total and show the calculation. Data: [paste CSV or tab-separated data here]
Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.
Use a tool built for this
Second choiceHand it to a person
The distant thirdA person who owns the outcome does this end to end, worth it when the failure is dear.
What it gets wrong
- AI cannot know which grouping answers your business question when the request is vague, so it may choose calendar months, categories or totals that are technically valid but unhelpful.
- AI cannot detect every business meaning hidden in codes, renamed columns or inconsistent entries without an explanation from you.
- AI can misread dates and numbers stored as text, producing a plausible pivot with missing or misplaced records.
- AI cannot take responsibility for a report used in a financial, staffing or operational decision; you must reconcile the totals and approve the interpretation.
Even on a YES, the friction has a name: context depth and judgement under ambiguity.
How we scored this
Five axes, each scored nought to two by hand: ten means AI carries the task cleanly, and the thresholds that turn a total into YES, PARTLY or NO are published in the methodology. Each axis name links to its definition.
| Axis | Score (0–2) |
|---|---|
| Output | 2 |
| Inputs | 2 |
| Verification | 2 |
| Liability | 2 |
| Effort delta | 2 |
| Total | 10 / 10 |
The methodology and its thresholds are published in full.
FAQ
- Can ChatGPT make a pivot table from an Excel file?
- Yes. Give it the spreadsheet or a pasted table, state the question the report must answer, and ask for the row, column, value and filter fields plus steps to recreate the result in Excel. Check the grand total against the source data before using it.
- Can AI create a pivot table in Google Sheets?
- Yes, AI can propose the layout and provide Google Sheets steps, and some spreadsheet tools can work directly with uploaded or connected data. You still need to create or confirm the pivot in the sheet and check its totals.
- What data do I need for a pivot table?
- You need a table with clear column headings and rows representing records, plus the category, date or other grouping fields and a numeric field if you want sums or averages. Tell the AI what question the pivot should answer and explain unusual codes, blanks or duplicate rows.
- Can AI make a pivot table without knowing Excel?
- Yes. It can explain which fields to place in Rows, Columns, Values and Filters and give you click-by-click instructions. You should still compare the result with a direct total from the source data, because a simple spreadsheet error can produce a convincing report.
Nearby answers
Assessed by gpt-5.6-luna (gpt-5.6-luna) on 2026-08-13, second-checked by an independent model. Wrong somewhere? Email [email protected] and it gets re-checked.
The newsletter
AI news, new answers and product picks, straight to your inbox.