QuantaDev Labs builds practical software utilities, AI tools, and game infrastructure systems.

From Google Sheets automation to on-device AI and deployment tooling, QuantaDev Labs focuses on useful tools that solve real workflow problems.

Clean messy Google Sheets customer data without sending it to a third-party API.

SheetClean Pro is a Google Sheets Apps Script utility that helps standardize common customer/contact/business data, including names, emails, phone numbers, addresses, states, amounts, notes, duplicate records, and validation issues.

Name, email, and phone cleanup
Address, city, state, and zip standardization
Duplicate merge support
Validation issue highlighting
Demo sheet generator
Headerless and messy-row routing
Formula preservation
No third-party API required
Before: Messy Data
johN DOE | 555-1234 | j.doe@ email.com | 123 Main st john d. | 555-1234 | | 123 main street mary smith | (555) 987-6543 | mary@test.com | tx MARY SMITH | 5559876543 | mary@test.com | texas * Messy customer data * Inconsistent casing * Scattered fields * Bad emails * Duplicate rows
After: SheetClean Pro
John Doe | (555) 555-1234 | j.doe@email.com | 123 Main St Mary Smith | (555) 987-6543 | mary@test.com | TX * Clean standard table * Formatted names * Normalized contact fields * Validation issues highlighted * Duplicates merged

Requirements

  • Requires Google Sheets
  • Requires copying Code.gs into Extensions → Apps Script
  • Requires Google Apps Script authorization
  • Not Excel/VBA
  • Digital download only
  • Best for US-style customer/contact/business data
  • Use on a copied spreadsheet first

What's Included

  • Code.gs
  • README_FIRST.md
  • INSTALL_GUIDE.md
  • TESTING_GUIDE.md
  • LICENSE.txt
  • SUPPORT_INFO.txt
  • VERSION.txt
  • CHANGELOG.txt
  • BUYER_README_SHORT.txt

Current Projects

SheetClean Pro

Google Sheets Apps Script data-cleaning utility.

EchoBooks

On-device ONNX-powered TTS engine for Android.

VectorHost

Automated UE5 dedicated server deployment protocols.

Frequently Asked Questions

Q: Is this an Excel add-in?

A: No. SheetClean Pro is for Google Sheets Apps Script, not Excel/VBA.

Q: Does it send spreadsheet data to an outside API?

A: No third-party API is required by this script.

Q: Will Google ask me to authorize the script?

A: Yes. Google shows an authorization prompt because the script edits your spreadsheet.

Q: Should I run it on my live sheet first?

A: No. Test on a copied spreadsheet first.

Q: Does it guarantee perfect cleanup?

A: No. It helps clean common messy customer/contact/business data, but users should review the results.

Support