Skip to content

liunicholas/LeXcel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

15 Commits
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

๐Ÿ“Š 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

  1. Open LeXcel from the Add-ons menu
  2. Select the cell or range where you want to insert a formula and click the ๐Ÿ“Œ button to insert the selected range
  3. Type your request in natural language (e.g., "calculate the average of the numbers to the left")
  4. Click Send or press Enter
  5. 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

  1. Open Google Sheets
  2. Go to Extensions โ†’ App Scripts
  3. Add the Chatbot.gs and ChatbotUI.html files
  4. 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.

About

cursor for spreadsheets

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors