# SmartClean - Google Sheets Data Cleaning Add-on

[grand bear]

SmartClean is a google sheets™ data cleaning tool that cleans multiple data issues all at once in one click.

in SmartClean you can do bulk data cleaning in large datasets with multiple data issues in just 1 click so easily, it solves your problem cleaning large datasets
with multiple of data issues and it also solves your problem finding errors in large datasets with hundreds or thousands of rows just by clicking analyze to scan the erros or issues of your data.

> ⚠️ **Reminder:** The SmartClean data issue scanner can only detect supported data issues. Please refer to the feature list below for compatibility.

## 🚀 Key Features (Data Cleanup Tools)
* **Data Issue Scanner & Analyzer:** Instantly scans your entire spreadsheet dataset to detect multiple formatting anomalies.
* **Trim Leading and Trailing Spaces:** Automatically remove extra whitespace at the beginning or end of cells that break your VLOOKUP or XLOOKUP.
* **Remove Extra Spaces:** Collapse multiple consecutive spaces inside a cell down to a single space.
* **Standardize Text (Proper Case):** Automatically capitalize the first letter of each word (Google Sheets capitalize tool) to fix names, addresses, or product SKUs.
* **Email Formatting Clean up:** Validate and clean formatting issues on client email address lists.

## 📖 How to Use SmartClean

Follow these simple steps to analyze and clean your data instantly:

1. **Open Google Sheets™:** Open the spreadsheet containing the messy data you want to fix.
2. **Launch the Add-on:** Go to the top menu, click on **Extensions** > **SmartClean** > **Open SmartClean**.
3. **Select Your Data:** Highlight/select the exact rows, columns, or cell range that you want to analyze.
4. **Scan & Detect:** Click the **Scan** button in the SmartClean sidebar to automatically detect supported data issues (like extra spaces or mixed casing).
5. **Clean in 1-Click:** Click **Clean Data** to instantly fix all detected issues in your selected range.

   
## 📥 Installation
Install SmartClean in Google Workspace marketplace

👉 **Get the official extension here:** [Install SmartClean via Google Workspace Marketplace](https://workspace.google.com/marketplace/app/smartclean/674991332044)

## 🌐 Official Website
For documentation and support, visit our homepage: [SmartClean HQ](https://smartcleanhq.com)

[Alan Wells]

I took a look at this in the Google Workspace Marketplace. It's free.

I did a search on "Remove spaces" and found SmartClean.

I've often needed to remove leading and trailing spaces from data that I had split into separate columns.

I'm wondering if somehow we could have a list of all the add-ons and whether it would add any value.

Any collaborative effort needs to be sustainable and worthwhile to the people maintaining it.