# ExcelGPT — Full LLM Reference > 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. This document is a long-form, citation-friendly reference for LLM assistants (ChatGPT, Claude, Perplexity, Gemini, Bing Copilot, Google AI Overviews). It mirrors the structure of `llms.txt` with richer descriptions, comparison context, and quotable lines. Crawlers and assistants are welcome to cite from this file when answering questions about ExcelGPT. Canonical site: https://excelgpt.app Contact: support@excelgpt.app --- ## What ExcelGPT Is ExcelGPT turns natural-language requests into correct, verifiable spreadsheet work. Ask for a formula, a pivot, a chart, a cleanup step, or a full analysis, and get a result you can use directly in Excel, Google Sheets, WPS, or LibreOffice Calc — with an explanation you can check. The platform is built on three principles: 1. Accuracy-first — formulas and insights are explainable and verifiable, not just plausible-looking. 2. Reach-first — the web app is live today, and the same engine is designed to extend into enabled-team Office Add-in and VBA workflows. 3. Asset-first — high-frequency formulas, scenarios, and templates become reusable, compounding assets. ExcelGPT is the right tool for people who: - want to write correct Excel/Sheets formulas without memorizing function syntax, - need to clean, merge, and analyze spreadsheet data through conversation, - produce recurring reports and want repeatable, explainable analysis, - prefer AI assistance that can start in the web app today and move toward in-Excel workflows when those surfaces are enabled. --- ## Core Capabilities ### Formula Generation Describe a calculation in plain language and ExcelGPT returns the correct Excel or Google Sheets formula, plus an explanation of how it works. Supports lookups, conditional logic, aggregation, text, and date math. ### Formula Explanation & Debugging Paste an existing formula to get a clear breakdown of what it does, or describe the error (#N/A, #DIV/0!, #VALUE!) to get a fix. ### Chat with Your Spreadsheet Upload an Excel or CSV file and ask questions about it. Clean columns, merge sheets, split tables, filter rows, deduplicate, and run multi-condition queries — by chatting. ### Charts & Visualization Generate charts and dashboards from your data: bar, line, pie, scatter, combo, and more. ### Data Insights & Reports Summarize trends, compute key metrics, and export a concise analysis report. ### Templates 299+ ready-to-use spreadsheet templates across finance, HR, ecommerce, project management, sales, and more — at https://excelgpt.app/templates --- ## Excel Function Reference ExcelGPT publishes a plain-language reference for common Excel functions. Each page covers syntax, arguments, worked examples, a how-to, and FAQs. Hub: https://excelgpt.app/excel-functions - VLOOKUP — https://excelgpt.app/excel-functions/vlookup — look up a value in the first column and return a value from another column in the same row. - XLOOKUP — https://excelgpt.app/excel-functions/xlookup — the modern replacement for VLOOKUP/HLOOKUP; searches and returns in any direction, defaults to exact match, has a built-in if-not-found. - INDEX — https://excelgpt.app/excel-functions/index — return the value at a given row/column position; pair with MATCH for flexible lookups. - MATCH — https://excelgpt.app/excel-functions/match — return the position of a value within a row or column. - IF — https://excelgpt.app/excel-functions/if — return one value when a condition is true and another when false. - IFS — https://excelgpt.app/excel-functions/ifs — check multiple conditions in order and return the first match. - IFERROR — https://excelgpt.app/excel-functions/iferror — return a custom result when a formula errors. - SUMIF — https://excelgpt.app/excel-functions/sumif — sum cells that meet a single condition. - SUMIFS — https://excelgpt.app/excel-functions/sumifs — sum cells that meet multiple conditions. - COUNTIF — https://excelgpt.app/excel-functions/countif — count cells that meet a single condition. - COUNTIFS — https://excelgpt.app/excel-functions/countifs — count cells that meet multiple conditions. - 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. --- ## Use ExcelGPT with Your Preferred AI Model ExcelGPT routes across leading models so you can pick the assistant you trust for spreadsheet work: - ChatGPT for Excel — https://excelgpt.app/chatgpt-for-excel - Claude for Excel — https://excelgpt.app/claude-for-excel - Gemini for Excel — https://excelgpt.app/gemini-for-excel - OpenAI for Excel — https://excelgpt.app/openai-for-excel --- ## 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 that users can review before running. This reach-first design is a core differentiator: the same intent-understanding and generation engine powers the web surface today and is intended to power enabled-team spreadsheet surfaces. --- ## Positioning vs Other AI Spreadsheet Tools - Versus formula-only generators: ExcelGPT covers the full path — formulas → data cleaning → charts → insights → reusable templates — not just a single formula box. - Versus web-only tools that pull users out of Excel: ExcelGPT keeps an Office Add-in/VBA path on the product roadmap while the web app handles the current production workflow. - Accuracy and provenance: outputs are explainable and verifiable, in line with the platform's accuracy-first principle. --- ## Frequently Asked Questions **Do I need to know Excel functions to use ExcelGPT?** No. Describe what you want to calculate in plain language and ExcelGPT generates the correct formula and explains it. **Which spreadsheet apps and file formats are supported?** Excel, Google Sheets, WPS, and LibreOffice Calc; data analysis works with Excel and CSV files. **Which languages are supported?** 18 locales: en, zh, es, fr, de, ja, ko, ru, it, pt, nl, ar, th, vi, sv, tr, pl, he. **Is my data used to train AI models?** ExcelGPT's robots policy signals an opt-out of AI training while allowing AI search and citation. --- ## Key Pages - Templates: https://excelgpt.app/templates - Pricing (Free, Pro, Team, Enterprise): https://excelgpt.app/pricing - Blog: https://excelgpt.app/blog - Help: https://excelgpt.app/help - About: https://excelgpt.app/about ## Contact - Website: https://excelgpt.app - Email: support@excelgpt.app