Skip to main content

Product capabilities for spreadsheets

Below, you'll find links to example use cases that demonstrate how to use the different features of GPT for Excel. To try out the examples, make a copy of our demo spreadsheet and install GPT for Excel.

Content generation​

Generate​

Create new text from scratch based on a prompt or set of instructions.

Watch our demo!
Try it out!

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.

Watch our demo!
Try it out!

Match​

Find the most similar or relevant items in a dataset based on a given input.

Watch our demo!

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.

Try it out!

Data analysis​

Analyze​

Examine a text or dataset to extract insights, answer questions, or interpret meaning.

Watch our demo!

Classify / Categorize​

Classify a piece of text into a single category selected from a predefined list of categories.

Watch our demo!
Try it out!

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.

Try it out!

Translation and localization​

Translate​

Translate text from one language to another.

Watch our demo!
Try it out!

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.

Retrieve information from the web in response to a query.

Watch our demo!
Try it out!

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.

On this page