Project Info
Inspiration
Spreadsheets are powerful but often frustrating tools. They require users to memorize complex formulas and spend time on tedious formatting, leading to a slow and efficient process. We wanted to create a solution that enhances productivity, reduces errors, and makes spreadsheets smarter and more intuitive.
What it does
LeXcel is an AI-powered add-on that enhances traditional spreadsheets by: Simplifying complexity – Enables users to generate complex formulas using natural language prompts Eliminating tedious formatting – Structures and formats new data given user requests Iterating With Verification – Learn from previous mistakes to produce consistent and robust solutions
How we built it
We developed LeXcel as a seamless add-on in Google Sheets that is easy to download and run for anyone: no coding experience required. Our main tech stack is javascript, google script, sheetAPI, OpenAI, and Gemini.
Challenges we ran into
Ensuring AI suggestions are accurate and context-aware for different spreadsheet use cases Building a UI/UX that integrates seamlessly without disrupting existing workflows
Accomplishments we're proud of
Built a user-friendly AI-powered assistant that significantly reduces the time needed for spreadsheet tasks Successfully implemented real-time error detection and reasoning to fix its own errors
What we learned
There is a tradeoff between AI automatically inputting all formulas which may feel like magic, versus prompting the user for confirmation which could lead to more consistent results
What's next
Allow LeXcel to manipulate delete/insert rows, move data around, etc. Give LeXcel the ability to generate and execute multi-step computations Tackle more complex puzzles and Excel World Championship tasks Integrating with more spreadsheet platforms beyond Google Sheets such as Paradigm and Excel
📊 LeXcel - Natural Language Formula Assistant for Google Sheets 🤖
LeXcel is a Google Sheets add-on that transforms the way you work with spreadsheet formulas. Instead of memorizing complex formula syntax, simply describe what you want to do in plain English, and LeXcel will generate and insert the appropriate formula for you! ✨
⭐ Features
- 💬 Natural Language Input: Describe your formula needs in plain English
- 🔮 Smart Formula Generation: Automatically converts your description into proper Google Sheets formulas
- 🧠 Context-Aware: Takes into account your selected cells and surrounding data
- 📐 Range Support: Works with both single cells and ranges
- ✨ Auto-Fill: Automatically extends formulas across selected ranges
- 🎯 Interactive UI: Clean, modern interface with real-time feedback
- 🎨 Range Selection: Easy cell range insertion with visual selector
🚀 How to Use
- Open LeXcel from the Add-ons menu
- Select the cell or range where you want to insert a formula and click the 📌 button to insert the selected range
- Type your request in natural language (e.g., "calculate the average of the numbers to the left")
- Click Send or press Enter
- LeXcel will generate and insert the appropriate formula ✅
💡 Example Requests
- "Sum all numbers in column A"
- "Find the highest value in the selected range"
- "Calculate the percentage change between these two columns"
- "Count how many times 'Completed' appears in status column"
- "Create a VLOOKUP to match these employee IDs with their names"
⚙️ Installation
- Open Google Sheets
- Go to Extensions → App Scripts
- Add the Chatbot.gs and ChatbotUI.html files
- Grant the necessary permissions
💪 Tips for Best Results
- ✍️ Be specific in your descriptions
- 📝 Include relevant context about your data
- 🎯 Use the range selector (📌) to specify exact cell ranges you want to input
- ✅ Review the generated formula before proceeding with other operations
📋 Requirements
- 👥 A Google Workspace account
- 📊 Google Sheets access
- 🌐 Internet connection
🔒 Privacy & Security
- 🛡️ LeXcel processes all requests securely
- 🗑️ No data is stored permanently
- 🔐 Operates within Google's security framework
- ⚡ Requires minimal permissions to function
Made with ❤️ for spreadsheet users who prefer plain English to formula syntax.
Analysis
View
Metric
- 15
Figures cover GitHub contributors during the hackathon window. A co-authored commit counts in full for each author, so per-member totals add up to more than the whole-team figures.
Technology
- HTMLIn code
- JavaScriptClaimed
- OpenAIClaimed
1 of 3 appear in the indexed code. 2 claimed on Devpost could not be matched to code, which may simply mean the tool leaves no trace in the repository.
AI coding agents
No AI coding agent signals were found in this repository.
Detected from committed agent config files and commit authorship. Absence of a signal is not proof an agent was unused.
Codebase size
Source size
29 KB
Source files
2
Counts recognized source files only; vendored directories, binaries and lockfiles are excluded, so this is smaller than the repository on disk.
Repository
liunicholas/LeXcel
3 files · 52 KB · @ effc1c7
Structure
Interface
1 file · 33%Screens, components and styles rendered to the user.
Application logic
1 file · 33%Domain rules, services and shared utilities.
Supporting
Layers are inferred from where files sit in the tree, not from reading the code. A project that names its directories unconventionally will read oddly here — open the file browser to check anything the diagram implies.
Languages
- HTML92%
- Markdown8%
Share of indexed source by file size. Binary and vendored files are excluded.
This project’s features have not been analysed yet.
Export this project's context (description, README, evidence, key source files) to chat with an AI agent elsewhere.