Stop Cleaning Google Sheets Manually!

Introducing **Sheet Sparkle ✨** – The Ultimate Data Cleaning Toolkit right inside your Google Sheets. Reclaim your time and ensure data accuracy with 13 powerful, easy-to-use functions.

Get Sheet Sparkle Now

One-time purchase for lifetime access.

Tired of Tedious Data Prep?

Save Hours Weekly

Automate repetitive tasks like trimming spaces, changing case, and removing duplicates in seconds, not hours.

Improve Accuracy

Eliminate manual errors caused by typos or inconsistent formatting. Ensure reliable data for your analysis.

Standardize Data

Easily enforce consistent casing, spacing, and formats across your entire dataset for professional results.

Simple & Integrated

Access all tools from a convenient sidebar directly within Google Sheets. No complex formulas needed!

13 Powerful Cleaning Functions Included

Clean, format, and transform your data effortlessly. Select your cells and click Run!

Trim Whitespace

Removes empty spaces from the beginning and end of text in selected cells.

BEFORE: "  John Doe  "
AFTER:  "John Doe"
Remove Duplicate Rows

Deletes entire rows within selection that are identical. Keeps the first instance found.

BEFORE:
Row1: A | B
Row2: C | D
Row3: A | B
AFTER (if Row1-3 selected):
Row1: A | B
Row2: C | D
Convert to Proper Case

Changes text to 'Proper Case', capitalizing the first letter of each word.

BEFORE: "john f. doe"
AFTER:  "John F. Doe"
Convert to UPPERCASE

Changes all text in the selected cells to capital letters.

BEFORE: "Warning Message"
AFTER:  "WARNING MESSAGE"
Convert to lowercase

Changes all text in the selected cells to small letters.

BEFORE: "[email protected]"
AFTER:  "[email protected]"
Remove Excess Spaces

Removes extra spaces between words (leaving only single spaces) and trims ends.

BEFORE: "Multiple   Spaces  Here "
AFTER:  "Multiple Spaces Here"
Remove Non-Printing Chars

Deletes hidden non-printing/control characters often pasted from external sources.

BEFORE: "Text with hidden<0x0B>char"
AFTER:  "Text with hiddenchar"
Text Numbers to Numbers

Converts cells containing numbers formatted as text (e.g., '500') into actual numbers.

BEFORE: Cell A1='123' (Text)
AFTER:  Cell A1=123 (Number)
Clear Formatting

Removes all formatting (bold, colors, font styles, etc.) from the selected cells.

BEFORE: Cell A1 = Important
AFTER:  Cell A1 = Important
Remove Blank Rows

Deletes entire rows within your selection that are completely empty.

BEFORE (Selection):
Row1: A | B
Row2:   |
Row3: C | D
AFTER:
Row1: A | B
Row2: C | D
Formulas to Values

Replaces formulas in the selection with their calculated static results (like Paste Values).

BEFORE: Cell C1 = =SUM(A1:B1) = 15
AFTER:  Cell C1 = 15 (Static Value)
Round Numbers (2 Decimals)

Rounds numerical values in the selection to 2 decimal places.

BEFORE: 123.4567
AFTER:  123.46
Fill Blanks With Value Above

Fills empty cells in selection using the value from the first non-empty cell directly above.

BEFORE:
A
[blank]
[blank]
B
AFTER:
A
A
A
B

Get Started in Minutes

Easy Setup & Activation

  1. Purchase License: Get your unique license key instantly from our secure Gumroad checkout. Get License
  2. Install Add-on:
    Option A (Recommended): Install from the Google Workspace Marketplace (Link coming soon!).
    Option B (Manual): Copy the provided script code into your Sheet's Apps Script editor (`Extensions > Apps Script`). Create `Code.gs` and `Sidebar.html` files and paste the code. Save the project.
  3. Open Sidebar: Refresh your Google Sheet. A new menu **"Data Cleaning Toolkit"** will appear. Click it, then **"Open Data Cleaning Toolkit"**. (You may need to grant authorization the first time).
  4. Activate: The sidebar will prompt for activation if needed. Paste your license key from Gumroad into the input field and click "Activate". This links the license to *this specific document*.
  5. Clean Your Data: Select the cells or range you want to clean. Find the desired function in the sidebar (use search!) and click **"Run"**. See the magic happen!

Perfect For...

Cleaning Survey Results

Standardize free-text answers, fix capitalization, remove extra spaces.

Standardizing CRM Exports

Ensure consistent formatting for names, addresses, and statuses before import/analysis.

Preparing Data for Charts

Convert text numbers, remove duplicates, and clear formatting for accurate visualizations.

Tidying Pasted Data

Quickly remove non-printing characters, trim whitespace, and fix casing from copied web data.

Frequently Asked Questions

Yes! Your purchase grants you a lifetime license key for the current version and all future updates of Sheet Sparkle. No subscriptions needed.

The license key you purchase is activated **per Google Sheet document**. Once you activate it within a specific sheet using the sidebar, anyone who has edit access to that sheet can use the Sheet Sparkle toolkit within that document. You can use your key on multiple different documents.

Yes. The script runs entirely within your Google account's secured environment. It requires permission to modify the *current document* (`@OnlyCurrentDoc`) solely to perform the cleaning actions you request on the data you select. It does *not* read data from other sheets or send your sheet data anywhere externally, except for the license key verification with Gumroad's secure API. We prioritize your data privacy.

Currently, Google Apps Script sidebars (like the one used by Sheet Sparkle) are primarily designed for the desktop web version of Google Sheets and are not supported in the mobile apps.

We're happy to help! Please reach out to support [at] macondolabs [dot] com. We're always looking for ways to improve Sheet Sparkle based on user feedback.

Ready to Make Your Sheets Sparkle? ✨

Get instant access to the Sheet Sparkle Data Cleaning Toolkit and start saving time today.
One-time payment, lifetime updates.

Get Your License Key Now