Logo and icon for Chat With Excel, a ChatGPT plugin with description: Transform your spreadsheet interactions and analysis by conversing as if you were a friend.. Find out more on Plugin Surf, the best plugin database.

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!

Learn how to use Chat With Excel effectively! Here are a few example prompts, tips, and the documentation of available commands.

Example prompts

  1. Prompt 1: "Find the latest research on quantum computing advancements."

  2. Prompt 2: "What are the recent developments in AI for climate change?"

  3. Prompt 3: "Find research on the use of machine learning in healthcare after 2020."

  4. Prompt 4: "Perform analysis on databases and spreadsheets."

  5. Prompt 5: "Can you help me link a Google Sheet to my conversation?"

Features and commands

searchPapersThis command allows the AI to generate precise ArXiv paper matches via semantic search of a hypothetical title and abstract.
get_available_sourcesThis command provides the sources available for querying data. It lists the data types, descriptions, IDs, and names of the available sources.
get_chatExcel_instructionsThis command provides instructions for how to use the plugin. It is useful for troubleshooting and understanding how to interact with the plugin.
linkDBThis 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.
linkSheetThis command links a Google Sheet to the conversation. It requires the name, purpose, and URL of the Google Sheet.
manipulateSheetThis 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.
queryDBThis 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.
useFileThis command ensures a file is usable for an operation before using it in /manipulate_sheet. It requires the filename of the file to use.
whoAmIThis command provides the email that the user is logged in as for managing their data.


User authenticationOAuth2
API documentation

For AI

DescriptionPerform analysis on databases and spreadsheets.


First added24 July 2023

Similar plugins