Simple Google Sheets help

AI Tools for Google Sheets Help Center

AI Tools for Google Sheets is a Google Sheets AI add-on built for users who want practical AI directly inside their spreadsheets. It helps you clean data in Google Sheets, fix errors, find duplicates in Google Sheets, remove duplicates, generate formulas, and explain formulas using simple language.

It works for any google spreadsheet, google worksheet, google excel-style workflows, and spreadsheets of all sizes.

Install Add-on Get started Contact support
  • Works inside Google Sheets
  • 30-day free trial
  • Preview before applying changes

Get started

  1. Open Google Sheets.
  2. Click Extensions → Add-ons → Get add-ons.
  3. Search for AI Tools for Google Sheets or Everest Web Deals.
  4. Click Install and accept permissions.
  5. After installing, go to Extensions → AI Tools for Google Sheets → Open.
  6. The sidebar will open and you can start using the tools.
Tip: The add-on works in any google spreadsheet connected to your Google account.

Feature pages

You can open detailed feature pages below for more examples and instructions.

Smart Formatter

Clean and standardize messy spreadsheet data.

Duplicate Removal

Find duplicates in Google Sheets and remove duplicate values.

Fix Errors with AI

Detect formula issues and review AI-powered fixes.

Generate Formula

Create Google Sheets formulas from plain language.

Explain Formula

Understand what a formula does step-by-step.

Free trial and plans

AI Tools for Google Sheets is free to install and includes a 30-day free trial.

After the trial:

Plan What is included
Free Explain Formula, Generate Formula
Pro Smart Formatter, duplicate detection, preview before apply, Fix Errors with AI, priority support

Smart Formatter

Clean and standardize messy data in your google spreadsheet automatically.

What it fixes

  • numbers stored as text
  • inconsistent formatting
  • extra spaces
  • incorrect decimal separators
  • inconsistent capitalization
  • messy phone numbers and emails

How to use it

  1. Open Smart Formatter
  2. Choose Whole Spreadsheet or By Selection
  3. Click Find & Format Values
  4. Review detected issues and preview changes
  5. Choose formatting strategy
  6. Click Apply Changes

Format strategies

  • Most Common — uses the most frequent format
  • AI Suggested — recommended by AI
  • From Settings — your saved rules

Duplicate Removal

Easily find duplicates in Google Sheets and remove them safely.

This feature helps you

  • google sheets remove duplicates
  • delete duplicate google sheets rows
  • detect similar or near duplicates

How duplicate matching works

Duplicates are checked by row combination, not just one column. For example, if columns A and B are selected, the tool compares full rows.

How to use it

  1. Open Duplicate Removal
  2. Choose Entire sheet or Selected range
  3. Click Find Duplicates
  4. Review grouped results and preview
  5. Click Delete Now

Delete modes

Mode Description
Delete rows Removes full duplicate rows
Clear values Keeps rows but removes duplicate values

Fix Errors with AI

Scan your spreadsheet and fix formula issues automatically.

What it detects

  • #DIV/0! — division errors
  • #VALUE! — wrong data types
  • #REF! — broken references
  • #NAME? — unknown functions
  • #N/A — missing values
  • #NUM! — invalid numbers

How to use it

  1. Open Fix Errors with AI
  2. Click Find Errors
  3. Review grouped issues
  4. Read explanation
  5. Click Apply Fix

Generate Formula

Create formulas using simple words. Works like chatgpt for google sheet.

How to use it

  1. Open Generate Formula
  2. Describe what you want
  3. Choose Active Cell or Selection
  4. Insert formula

Example

“If A1 is greater than 100, return Approved, otherwise Review”

Explain Formula

Understand formulas instantly.

What you see

  • original formula
  • purpose
  • step-by-step explanation

How to use it

  1. Open Explain Formula
  2. Select cell or range
  3. Click Explain

Troubleshooting

Common issues

  • Refresh the spreadsheet
  • Reopen the file
  • Check Google account used for install
  • Disable conflicting add-ons

FAQ

Does it work inside Google Sheets?

Yes. It runs directly inside your spreadsheet.

Contact support

If you need help:

Recommended: Include

  • screenshot
  • browser (Chrome, etc.)
  • error message
  • feature used

Summary

AI Tools for Google Sheets helps you:

  • find duplicates in google sheets
  • google sheets remove duplicates
  • clean and organize data
  • fix spreadsheet errors
  • generate formulas with AI

All directly inside your google spreadsheet, google worksheet, or spreadsheets.

Help Center page for AI Tools for Google Sheets
Hi, I am your personal AI assistant