Chat With Excel
Transform your spreadsheet interactions and analysis by conversing as if you were a friend.
Transform your spreadsheet interactions and analysis by conversing as if you were a friend. With Chat With Excel plugin, you can perform analysis on databases and spreadsheets effortlessly. Say goodbye to complicated commands and hello to a friendly conversation. Whether you need to retrieve data, calculate formulas, or visualize information, this plugin has got you covered. It's like having a knowledgeable friend who knows Excel inside out. Plus, you'll save time and effort with its intuitive interface. Let Chat With Excel be your virtual Excel expert and make your spreadsheet tasks a breeze!
How to
Comments (0)
API docs
Learn how to use Chat With Excel effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
-
Prompt 1: "Find the latest research on quantum computing advancements."
-
Prompt 2: "What are the recent developments in AI for climate change?"
-
Prompt 3: "Find research on the use of machine learning in healthcare after 2020."
-
Prompt 4: "Perform analysis on databases and spreadsheets."
-
Prompt 5: "Can you help me link a Google Sheet to my conversation?"
Features and commands
| Feature/Command | Description |
|---|---|
searchPapers | This command allows the AI to generate precise ArXiv paper matches via semantic search of a hypothetical title and abstract. |
get_available_sources | This command provides the sources available for querying data. It lists the data types, descriptions, IDs, and names of the available sources. |
get_chatExcel_instructions | This command provides instructions for how to use the plugin. It is useful for troubleshooting and understanding how to interact with the plugin. |
linkDB | This command adds a database connection to the conversation. It requires a formatted database string, name, and purpose. The database string should be in the format dbtype://user:password@host:port/dbname. |
linkSheet | This command links a Google Sheet to the conversation. It requires the name, purpose, and URL of the Google Sheet. |
manipulateSheet | This command allows you to inspect, edit, manipulate, and transform data in spreadsheets. It can also install pip packages using !pip install package_name. You need to specify various parameters such as files to load, files to retrieve, whether it's the first cell to execute, query plan, and the Python pandas code to run in the notebook. |
queryDB | This command allows you to run a read-only query on a database. It requires the columns to use in the query, data source ID, query explanation, and the SQL query to run. It also provides the option to generate a plot of the query results. |
useFile | This command ensures a file is usable for an operation before using it in /manipulate_sheet. It requires the filename of the file to use. |
whoAmI | This command provides the email that the user is logged in as for managing their data. |