Introduce Sheet Chat

The Sheet Chat Add-on is your AI co-pilot, streamlining your Sheet experience, boosting work efficiency, and unlocking profound data insights.

Our plugin simplifies core tasks like table creation, formatting, charting, and translation. Plus, harness the power of ChatGPT for dynamic Sheet conversations, enabling data analysis that goes beyond the surface. Unleash the potential of your data to create real value.

Create Sheet

To activate this feature, simply type @ and send the @create command. Specify the sheet name, and the assistant will guide you through column suggestions, expediting the sheet creation process.

Choose from pre-built forms presented in quick replies. Select your desired form, receive prompts for form creation, and customize the style—all in one seamless experience.

Edit Sheet

Activate this feature by typing @ and sending the @edit command. Share your specifications on how to edit the current Sheet data. We'll upload all or part of the Sheet data to GPT, where it will assist in data editing or generate functions tailored to your local data.

Write Function

Unlock this feature by typing @ and sending the @function command. Outline your function requirements, and GPT will propose the function expression, seamlessly integrating it into the designated cell.

Create Chart

Activate this function with the @ and @chart command. Input the type of chart you desire—whether it's a line chart, bar chart, or pie chart. Select your preferred chart from the quick replies, and it will be generated instantly.

For advanced capabilities with GPT3.5, input your specific chart requirements. We'll upload your Sheet data to GPT, and GPT will assist in creating a customized chart. Once complete, it will seamlessly integrate into your current Sheet.

Translate Sheet

Activate this feature by typing @ and sending the @translate command. Translate either the entire Sheet or a selected range effortlessly.

Choose between two translation engines: Google and GPT3.5. Opt for GPT3.5, and we'll upload your sheet, allowing GPT3.5 to provide a tailored translation. The choice is yours!

Calculator

Enable this feature with the @ and @calculator command. The calculator is your go-to tool for data calculations based on the current Sheet data—no need to write complex functions. Simplify your calculations effortlessly!

Filter Sheet

Activate this feature by typing @ and sending the @filter command. Whether it's the entire Sheet or a selected range, input your filter requirements, and we'll handle the rest. Watch as the data is filtered, and the results are highlighted for easy identification. Streamline your data filtering effortlessly!

Format

Enable this feature with the @ and @format command. Transform chaotic data into well-organized tables effortlessly. Append the formatted data to sheets based on the existing columns. Say goodbye to messy data, and hello to structured and organized information!

Chat with Sheet

Activate this feature by typing @ and sending the @chatsheet command. Prior to interaction, provide some introductory information about the application scenarios of the sheet. This helps ChatGPT better understand the context. Afterward, we'll upload all or part of your Sheet data to OpenAI or Azure OpenAI. Once connected, feel free to ask any questions and let the sheet do the talking! You can ask questions like the following:

  1. what are 3 insights from this dataset?
  2. When was the highest revenue increase? How high was it?
  3. Can you summarize this dataset?
  4. What trends do you see in this data?

Flow

Activate this feature by typing @ and sending the @flow command. Input your requirements, and the flow will craft a task plan for you. It will then efficiently coordinate other agents to complete the tasks seamlessly.

Note: The flow is task-focused and doesn't have knowledge of the sheet data. To execute tasks related to the current sheet, provide the flow with the sheet data structure and background information. The flow will then tailor a plan specifically for your needs.

Data Analyst

Activate this feature by typing @ and sending the @analyst command. The analyst is here to assist with data analysis. Provide the analyst with the sheet data structure, and share relevant background information. The analyst will create a comprehensive analysis plan, coordinate other agents to execute tasks, and finally, deliver an insightful analysis report tailored to your needs. Let the analyst take the lead in unraveling the story behind your data!

Summary

Sheet Chat is an AI plugin crafted to simplify spreadsheet tasks, boost productivity, and offer valuable data insights. Its versatile features include table creation, formatting, chart generation, and translations. With the support of ChatGPT, it extends capabilities to data analysis and seamless integration with external systems, facilitating workflow automation. Experience a more efficient and insightful approach to managing your spreadsheets!

Here is all fetrues of Sheet Chat:

  • @start Chat with introduce of Sheet Chat.
  • @create Facilitates the creation of new sheets with sheet name.
  • @edit Facilitates easy editing of current Sheet data.
  • @function Allows the creation of functions without manual coding.
  • @chart Enables quick and easy chart creation.
  • @translate Translates either the entire Sheet or a selected range.
  • @calculator Performs data calculations based on the current Sheet data without the need for manual function writing.
  • @filter Effortlessly filters either the entire Sheet or a selected range based on user input.
  • @format Transforms messy data into neatly organized tables and appends the formatted data to sheets based on columns.
  • @chatsheet chat with sheet for data insights.
  • @flow Crafts task plans and coordinates agents to complete tasks efficiently.
  • @analyst Conducts comprehensive data analysis, creates analysis plans, coordinates task execution, and delivers insightful analysis reports.