AI Data Analyst for Excel

full, production-ready Excel VBA script that reads raw data, analyzes numeric KPIs, creates a dashboard, and calls the OpenAI API to generate an executive summary. This uses the OpenAI text-davinci-003 completion endpoint via VBA XMLHTTP.

You will need an OpenAI API key. Make sure you replace "YOUR_OPENAI_API_KEY" with your key.

How It Works

1. Reads numeric columns from your RawData sheet.
2. Calculates total and average for each numeric column.
3. Builds a clustered column chart automatically.
4. Sends the first 10 rows of data to OpenAI API.
5. Receives an executive-level summary and writes it to the Dashboard sheet.