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! โจ
- ๐ฌ 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
- 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 โ
- "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"
- Open Google Sheets
- Go to Extensions โ App Scripts
- Add the Chatbot.gs and ChatbotUI.html files
- Grant the necessary permissions
- โ๏ธ 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
- ๐ฅ A Google Workspace account
- ๐ Google Sheets access
- ๐ Internet connection
- ๐ก๏ธ 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.