Your personal
Data Analyst

Unlock the power of AI to analyze, summarize, and transform data – without scripts or code.

Analyze data faster

Your personal data analyst, full of new tricks.

Add Tables

Extracts trends, generate pivot tables, and slice the data.

Get Answers

Get answers to your business questions, fast.

Enrich Data

Extend your dataset with rich columns that work for you.

Add Columns

Add calculated columns that give you the full picture.

Format Cells

Apply formats & styles that clean up your datasets.

Create Charts

Turn numbers into visual stories just by asking.

The power of ChatGPT inside a spreadsheet. Without scripts, add-ons or code.

Classify and Tag text

Bring clarity to unstructured data. Tag and classify any type of text automatically.
Social media posts
Categorize social sentiment and get a real-time pulse of your online presence.
Support tickets
Transform tickets into insights for faster resolutions and happier customers.
Feedback surveys
Turn feedback into action. Know what your customers love and what you still need to work on.
Product reviews
Classify product reviews by topic and pinpoint key improvement areas for your roadmap.

Clean up data

Prep your data for action. Use logic to scrub strings and clean messy data.
Non-ASCII characters
Remove all extended symbols from cells and get your report ready in seconds.
CSV files
Trim inconsistent spacing and punctuation and turn messy CSV exports into clean datasets.
Customer datasets
Rearrange first/last names, standardize phone numbers patterns without tedious manual work.
Lead lists
Remove legal jargon from company names and automate nagging tasks to close deals faster.

Summarize and transform text

Summarize text into different styles, and extract portions or concepts from any string.
Product feedback
Digest customer feedback quickly and extract the feature requests to focus on.
Addresses
Need to analyze location data? Use AI to extract zip codes, street names, zip codes and more.
NPS surveys
Make sense of NPS comments with confidence. Translated from any language, summarized to any style.
User logs
Extract timestamps, user IDs, and action types from unstructured log files to analyze user behavior.

Ask Anything

Merge the versatility of a spreadsheet with the potential of AI to augment your work.
One formula
Use ASK_OPENAI to send custom prompts and use specific AI models from OpenAI.
Cell references
Use cells references inside the prompt to make it dynamic.
Flexible formulas
Add any formula inside the prompt. Concatenate text, perform calculations, and more.

Questions & answers

  • The AI Analyst is available to all users. You can access it by clicking the ✨ icon in the top right corner of any table.
  • The OpenAI integration is available in the Integrations gallery. You can also switch it on by browsing it in the Data Actions menu on every spreadsheet.