← All guides

Analyze Excel with ChatGPT and download a checked workbook

Practice uploading, summarizing, checking and downloading Excel with three sample rows.

Updated

Start here

Check the file and columns, specify the summary, then request an XLSX attachment. Verify totals and formulas after downloading.

On this page

1. Create a sample workbook

  1. Paste the sample into Excel starting at A1 and save it as demo-sales.xlsx.
  2. Upload the workbook. Use a copy when analyzing your real data.
Date	Product	Quantity	Unit price
2026-11-01	Product A	2	50
2026-11-01	Product B	1	80
2026-11-02	Product A	3	50

2. Check the imported data

  1. Use the prompt below and check for four columns and three records.
  2. For multiple sheets or special calculations, identify the sheets and columns to use.
List the worksheet names, columns, row count and first 3 rows.
Flag missing values and formatting problems. Wait for my confirmation before summarizing.

3. Request an Excel attachment

  1. After checking the data, send the task below.
  2. Specify how refunds, discounts or tax should be treated if applicable.
Create a downloadable XLSX workbook:
1. Keep the source data and add a sales column using quantity × unit price formulas.
2. Summarize quantity and sales by product.
3. Summarize sales by date.
4. Check totals and formulas, then provide the file attachment.

4. Verify the expected results

  1. Row sales are 100, 80 and 150. Total quantity is 6 and sales total 330. Product A: quantity 5, sales 250. Product B: quantity 1, sales 80.
  2. Sales are 180 on November 1 and 150 on November 2. Open the downloaded workbook in Excel and check formulas and totals.

5. Correct a specific result

  1. Name the worksheet and cell, then request a check of the source rows and formula before generating a corrected file.
  2. Contact support if calculation, file reading or downloading still fails.
In the product summary, Product A should have quantity 5 and sales 250.
Check the referenced source rows and formulas, regenerate the XLSX and verify a grand total of 330.

Download help →

Contact support →

Useful links