Excel Formula GPT

Excel Formula GPT is an open-source AI-powered tool that converts natural language descriptions into precise Excel formulas. It is designed for spreadsheet users at any skill level who want to generate formulas without memorizing syntax or searching through documentation.

How It Works

• Users describe the desired calculation or operation in plain English directly on the web interface
• The AI model, accessed through OpenRouter, interprets the description and returns the corresponding Excel formula with correct syntax
• Generated formulas can be copied and pasted into Excel, Google Sheets, or LibreOffice Calc immediately
• Registered users can upload XLSX files so the AI reads column headers and data ranges for contextually accurate formula generation
• All generated formulas are saved to the user history for later reference and reuse

Key Capabilities

• Natural language to formula conversion: describe what you need in everyday words and receive the exact formula, from simple SUM and AVERAGE to nested IF statements, VLOOKUP, INDEX-MATCH, and array formulas
• Excel file context awareness: upload a spreadsheet so the AI understands your specific column names and data layout, producing formulas that reference the correct ranges
• Formula history and management: registered users can browse, search, and reuse previously generated formulas, reducing repetitive work
• Multi-language interface: the platform is fully translated into ten languages including English, Chinese, Spanish, French, German, Japanese, Korean, Russian, Italian, and Portuguese
• No sign-up required for basic use: first-time visitors can generate up to three formulas per day without creating an account
• Open-source and auditable: the complete codebase is published on GitHub under the GNU Affero General Public License v3.0, allowing community review and contribution

Use Cases

• Business reporting and analysis: generate lookup and aggregation formulas for sales dashboards, inventory tracking, and operational reporting
• Financial modeling: build conditional logic, date calculations, percentage growth, and forecasting formulas for budgets and financial plans
• Data cleaning and transformation: create text extraction, concatenation, conditional formatting, and data validation formulas to prepare datasets for analysis
• Learning and education: beginners and intermediate users can learn Excel syntax by observing how natural language descriptions translate into accurate formulas, bridging the gap between intent and technical implementation
• Cross-platform spreadsheet work: formulas generated on the platform work in Microsoft Excel, Google Sheets, and LibreOffice Calc, making the tool useful regardless of the user spreadsheet software

Pricing

• Free plan: five generation credits per month with Excel file upload and history saving
• Pro plan: $3.59 per month (or discounted yearly) for 1,000 generation credits per month
• Max plan: $6.38 per month (or discounted yearly) for 10,000 generation credits per month and early access to new features
• Payments are processed securely through LemonSqueezy

Technology

• Built with Next.js and TypeScript, styled with Tailwind CSS and Shadcn UI component library
• LLM inference routed through OpenRouter with Langfuse tracing for quality monitoring and debugging
• Authentication managed by NextAuth.js, session and data storage via Upstash Redis
• Deployed on Vercel with payments handled through LemonSqueezy

Privacy and Security

• Formula generation requests are processed through OpenRouter; tracing data is collected via Langfuse for service improvement
• The platform uses cookies for authentication and essential functionality
• As open-source software under AGPL-3.0, the codebase is publicly available for security review and community contribution on GitHub