# ExcelGPT

> ExcelGPT is an AI data analysis platform for Excel, CSV, and spreadsheet data. Describe what you need in plain language and ExcelGPT generates formulas, cleans and analyzes data, builds charts, and surfaces insights in the web app, with Office Add-in and VBA workflows planned for enabled teams. No functions or coding required.

ExcelGPT turns natural-language requests into correct spreadsheet work. Ask for a formula, a pivot, a chart, or an analysis, and get a verifiable result you can use in Excel, Google Sheets, WPS, or LibreOffice Calc. The current product surface is the web app, with Office Add-in and VBA workflows tracked as team-enabled/roadmap surfaces.

## Core Capabilities

- Formula generation: turn a plain-language description into the correct Excel/Sheets formula, with an explanation
- Formula explanation & debugging: paste a formula to understand or fix it
- Chat with your spreadsheet: upload Excel/CSV and ask questions — clean, merge, split, filter, and query data
- Charts & visualization: generate charts and dashboards from your data
- Data insights & reports: summarize trends and export an analysis report
- Templates: 299+ ready-to-use spreadsheet templates across finance, HR, ecommerce, project management, and more

## Excel Function Reference

- [Excel Functions Hub](https://excelgpt.app/excel-functions): Plain-language reference for every function — syntax, arguments, examples, FAQs
- [VLOOKUP](https://excelgpt.app/excel-functions/vlookup): Look up a value in the first column and return a value from another column
- [XLOOKUP](https://excelgpt.app/excel-functions/xlookup): The modern replacement for VLOOKUP/HLOOKUP — search and return in any direction
- [INDEX](https://excelgpt.app/excel-functions/index) & [MATCH](https://excelgpt.app/excel-functions/match): The flexible alternative to VLOOKUP
- [IF](https://excelgpt.app/excel-functions/if), [IFS](https://excelgpt.app/excel-functions/ifs), [IFERROR](https://excelgpt.app/excel-functions/iferror): Conditional logic and error handling
- [SUMIF](https://excelgpt.app/excel-functions/sumif) & [SUMIFS](https://excelgpt.app/excel-functions/sumifs): Conditional sums
- [COUNTIF](https://excelgpt.app/excel-functions/countif) & [COUNTIFS](https://excelgpt.app/excel-functions/countifs): Conditional counts
- [TEXTJOIN](https://excelgpt.app/excel-functions/textjoin): Combine text from a range with a delimiter
- [DATEDIF](https://excelgpt.app/excel-functions/datedif): Difference between two dates in years, months, or days

## Google Sheets Functions

- [Google Sheets Functions Hub](https://excelgpt.app/google-sheets-functions): Syntax, examples and FAQs for every Google Sheets function, including Sheets-only ones
- [QUERY](https://excelgpt.app/google-sheets-functions/query): SQL-like queries over a range — the most powerful Sheets-only function
- [ARRAYFORMULA](https://excelgpt.app/google-sheets-functions/arrayformula): Apply a formula across an entire column at once
- [IMPORTRANGE](https://excelgpt.app/google-sheets-functions/importrange): Pull a live range from another Google Sheets file
- [GOOGLEFINANCE](https://excelgpt.app/google-sheets-functions/googlefinance): Fetch live or historical market data

## Excel Errors & Terminology

- [Excel Errors Reference](https://excelgpt.app/excel-errors): What every Excel error (#REF!, #N/A, #DIV/0!, #VALUE!, #SPILL! and more) means, why it happens, and how to fix it
- [Excel Glossary](https://excelgpt.app/excel-glossary): Plain-language definitions of core spreadsheet concepts — pivot tables, VLOOKUP, dynamic arrays, Power Query, named ranges and more
- [How-To Guides](https://excelgpt.app/how-to): Step-by-step tutorials for common Excel tasks — remove duplicates, use VLOOKUP, create pivot tables, drop-down lists, split text and more
- [Calculators](https://excelgpt.app/calculators): Free interactive calculators (percentage, loan, compound interest, discount, margin, tip), each with the equivalent Excel formula

## Use ExcelGPT with Your AI Model

- [ChatGPT for Excel](https://excelgpt.app/chatgpt-for-excel): Use ChatGPT to generate formulas and analyze spreadsheet data
- [Claude for Excel](https://excelgpt.app/claude-for-excel): Use Claude for formulas, analysis, and explanations in Excel
- [Gemini for Excel](https://excelgpt.app/gemini-for-excel): Use Gemini for spreadsheet formulas and data analysis
- [OpenAI for Excel](https://excelgpt.app/openai-for-excel): Use OpenAI models for Excel formula generation and analysis

## Reach (Where ExcelGPT Works)

- Web app: the full chat-based data-analysis workspace
- Office Add-in: planned/team-enabled workflow for in-Excel assistance
- VBA workflows: generated macros and automation guidance you can review before running

## Key Pages

- [Templates](https://excelgpt.app/templates): 299+ spreadsheet templates by category
- [Pricing](https://excelgpt.app/pricing): Free, Pro, Team, and Enterprise plans
- [Blog](https://excelgpt.app/blog): Guides on Excel formulas, data analysis, and AI spreadsheet workflows
- [Help](https://excelgpt.app/help): Getting-started guides and onboarding
- [About](https://excelgpt.app/about): Company, mission, and platform charter

## Documentation

- [Docs Hub](https://excelgpt.app/docs): Product documentation and capability guides
- [Getting Started](https://excelgpt.app/docs/getting-started): Create an account, upload a spreadsheet, run your first AI analysis
- [How ExcelGPT Works](https://excelgpt.app/docs/how-it-works): The parser + language-model engine that turns plain language into verifiable results
- [Generating Excel Formulas with AI](https://excelgpt.app/docs/formula-generator): Plain language to formula, with explanation and debugging
- [Chatting with Your Spreadsheet](https://excelgpt.app/docs/chat-with-excel): Upload and ask questions — clean, merge, filter, summarize, analyze
- [Converting PDF & Images to Excel](https://excelgpt.app/docs/pdf-image-to-excel): Extract tables from PDFs, screenshots, and photos into editable Excel
- [Creating Charts with AI](https://excelgpt.app/docs/ai-charts): Chart recommendation and generation from your data
- [Cleaning Data with AI](https://excelgpt.app/docs/data-cleaning): Dedupe, standardize, split/merge, and fix messy data
- [VBA, SQL, Regex & Apps Script Generators](https://excelgpt.app/docs/code-generators): Generate and explain spreadsheet automation code
- [Data Privacy & Security](https://excelgpt.app/docs/data-privacy): How ExcelGPT handles your spreadsheets and data
- [Generating VBA Macros with AI](https://excelgpt.app/docs/vba-generator-guide): Plain language to a reviewable VBA macro
- [Generating SQL Queries with AI](https://excelgpt.app/docs/sql-generator-guide): Natural language to SQL for your dialect
- [Generating Regular Expressions with AI](https://excelgpt.app/docs/regex-generator-guide): Describe a pattern, get a regex with a breakdown
- [Generating Google Apps Script with AI](https://excelgpt.app/docs/apps-script-generator-guide): Automate Google Sheets with generated Apps Script
- [Writing Effective Prompts](https://excelgpt.app/docs/writing-effective-prompts): Get better formulas and analysis with specific requests
- [Working with Large Spreadsheets](https://excelgpt.app/docs/working-with-large-files): Analyze big Excel/CSV files efficiently
- [Exporting and Sharing Results](https://excelgpt.app/docs/exporting-results): Copy formulas, download cleaned data, reuse code
- [Excel vs Google Sheets in ExcelGPT](https://excelgpt.app/docs/excel-vs-google-sheets): How formulas and features differ across the two

## Positioning vs Other AI Spreadsheet Tools

- ExcelGPT is reach-first: the web app is live today, while Office Add-in and VBA workflows are positioned as enabled-team/roadmap surfaces rather than separate claims users can install from this repository today.
- Versus formula-only generators, ExcelGPT covers the full path: formulas → data cleaning → charts → insights → reusable templates.
- Accuracy-first: formulas and insights are explainable and verifiable, not just plausible-looking.

## Supported Languages

en, zh, es, fr, de, ja, ko, ru, it, pt, nl, ar, th, vi, sv, tr, pl, he (18 locales)

## Further Reading

- [llms-full.txt](https://excelgpt.app/llms-full.txt): Long-form, citation-friendly reference for LLM assistants (full capability detail, function coverage, workflow recipes, FAQ)

## Contact

- Website: https://excelgpt.app
- Email: support@excelgpt.app