Skip to content
SheetsIQ

SheetsIQ Tools – How to guide

SheetsIQ tools is an add-on for google sheets which is a combination of 30+ smart tools to supercharge your google sheets data calculations and analysis.

Here are the list of tools –

General Tools:

  • Auto formula by range
  • Function by color
  • Change case
  • Freeze & unfreeze panes
  • Remove blank rows & columns
  • Unpivot table
  • Flip cells
  • Unmerge cells

Dedupe Tools:

  • Remove duplicate rows
  • Remove duplicate cells
  • Compare column & sheets
  • Combine duplicate rows
  • Quick dedupe

Merge & Combine:

  • Merge values
  • Merge sheets
  • Combine sheets

Split Tools:

  • Split by character
  • Split names
  • Split date time

Text Tools:

  • Add text by position
  • Remove substring
  • Remove excess spaces
  • Remove character by position
  • Replace symbol
  • Polish text

Extract Tools:

  • Extract by string
  • Extract first/last N characters
  • Extract numbers
  • Extract by position
  • Extract links

Other Tools:

  • Fill blank cells
  • Clear data by type
  • Random generator
  • SheetsIQ Add-on Docs
  • Dedupe Tools
  • Merge Tools
  • Split & Text Tools
  • General Tools
  • Google Sheets Tutorials
  • Google Sheets Templates
  • Formulas Tutorial
  • Logical functions Tutorial
  • Format Data Tutorial
  • About
  • Contact
  • Privacy Policy
  • Add-on Terms of Use
  • Add-on Support
  • About
  • Contact
  • Privacy Policy
©2023 SheetsIQ