Add-on for google sheets to 10x your productivity. Advance find duplicates, merge sheets, split data, text processing and many more.
Get started for freeNo need to write formulas. Complex data calculation with few clicks. Save hours.
SheetsIQ sidebar in Google Sheets
SheetsIQ Tools is an add-on for Google Sheets™ to help you become super productive. With 30+ smart tools you can supercharge your data manipulation and calculation without writing any formula or app script code.
Example: Remove Duplicate Rows
| Title | Genre | IMDB |
|---|---|---|
| Black panther Adventure | Action | 7.4 |
| Incredibles 2 | Action | 7.8 |
| Deadpool 2 | Comedy | 7.8 |
| A star is born | Music | 8.1 |
| Title | Genre | IMDB |
|---|---|---|
| Black panther Adventure | Action | 7.4 |
| Incredibles 2 | Action | 7.8 |
| Deadpool 2 | Comedy | 7.8 |
| A star is born | Music | 8.1 |
| A | B |
|---|---|
| Fruit | Price |
| Kiwi | 10 |
| Apple | 20 |
| Orange | 30 |
| Lime | 40 |
| Banana | 50 |
| A | B |
|---|---|
| Fruit | In stock |
| Kiwi | Yes |
| Apple | No |
| Orange | Yes |
| Lime | No |
| Banana | Yes |
| A | B | C |
|---|---|---|
| Fruit | Price | In stock |
| Kiwi | 10 | Yes |
| Apple | 20 | No |
| Orange | 30 | Yes |
| Lime | 40 | No |
| Banana | 50 | Yes |
Examples of text tools available in the sidebar: Add text by position, Remove character by position, Remove substring or characters.
Split names example:
| Dr. Woody Allen |
| Mr. Will |
| Peter McCoy, M.D. |
| Prof. Charles Francis Xavier |
| Title | First Name | Middle Name | Last Name | Suffix |
|---|---|---|---|---|
| Dr. | Woody | Allen | ||
| Mr. | Will | |||
| Peter | McCoy | M.D. | ||
| Prof. | Charles | Francis | Xavier |
Function by color
| Fruit | Quantity |
|---|---|
| Orange | 10 |
| Apple | 23 |
| Orange | 14 |
| Apple | 7 |
| Banana | 15 |
Auto formula by range — select range and apply SUM, etc.