Product capabilities for spreadsheets
You can use GPT for Excel and GPT for Sheets for:
Content generation (generate and rewrite)
Data preparation (extract, reformat, and more)
Data analysis (classify, categorize, summarize, and more)
Below, you'll find links to example use cases that demonstrate how to use the different features. To try out the examples, make a copy of the relevant spreadsheet and install GPT for Work.
Content generation
Generate
Create new text from scratch based on a prompt or set of instructions.
Rewrite
Modify existing text by changing its wording or phrasing without necessarily altering its meaning. Distinct from Reformat, which preserves the original wording and phrasing.
Data preparation
Extract
Identify and isolate specific elements from text or images, such as names, dates, email addresses, URLs, or product attributes.
Match
Find the most similar or relevant items in a dataset based on a given input.
The function is now called GPT_MATCH and includes an additional optional top_k parameter but otherwise works as shown in the video.
Merge
Combine two or more pieces of text into a single piece based on a specific rule.
Split
Separate a single piece of text into multiple parts based on a specific rule.
Reformat
Change the layout or formatting of text without modifying the underlying content. For example, convert Markdown to HTML, or split a paragraph into bullet points. Distinct from Rewrite, which modifies the content but preserves the layout and formatting.
Data analysis
Analyze
Examine a text or dataset to extract insights, answer questions, or interpret meaning.
Classify / Categorize
Classify a piece of text into a single category selected from a predefined list of categories.
Score
Evaluate text and assign a score or grade based on specific criteria. The score or grade can be numerical or letter-based.
Summarize
Generate a concise summary that captures the main points of a longer text.
Tag
Assign one or more tags to text based on its content, selected from a predefined list of tags.
Translation and localization
Translate
Translate text from one language to another.
Localize
Adapt text to align with the linguistic, cultural, and contextual norms of a specific country or region.
Review translations
Assess translation quality by identifying and explaining potential errors or inconsistencies.
Web search
Retrieve information from the web in response to a query.
Spreadsheet assistance
Generate formulas
Generate a spreadsheet formula based on plain-language descriptions of the desired outcome.
Explain formulas
Provide a clear explanation of what a spreadsheet formula does.