Home/Data Tools
🛠️Data Tools•In Google Sheets

Advanced Data Utilities for Google Sheets

Powerful spreadsheet utilities for data transformation, validation, and analysis. Extend Google Sheets with functions you wish existed.

data-utilities.xlsx
ABC
1InputFormulaOutput
2Hello World 2024!—
3https://example.com=getStatusCode(A3)200
4how to start a business=suggestQueries(A4)10 suggestions
Start FreeSee Examples
Why Data Tools?

Spreadsheet superpowers unlocked

Functions that make complex data operations simple. No coding, no add-ons, just formulas.

🔍

Text Transformation

Case conversion, slug generation, string manipulation, and text formatting utilities.

✅

Data Validation

Validate emails, URLs, phone numbers, and other data formats automatically.

📊

Array Operations

Flatten, transpose, chunk, and manipulate arrays with simple formulas.

🕐

Date & Time Utilities

Parse dates, calculate durations, convert timezones, and format date strings.

🔗

URL Parsing

Extract domains, paths, parameters, and fragments from URLs.

🔐

Hashing & Encoding

Generate MD5, SHA hashes, encode/decode Base64, and URL encode strings.

Examples

Data tools in action

Real formulas for transforming, validating, and analyzing your data.

Text Transformation•Generate URL Slugs
Formula
=slugify("Hello World Product 2024")
Input
Hello World Product 2024
Output
UTIL
hello-world-product-2024
Use case: generate url slug google sheets
URL Parsing•Check HTTP Status Code
Formula
=getStatusCode(A2)
Input
https://www.example.com
Output
UTIL
200
Use case: check url status google sheets
URL Parsing•Extract URLs from Sitemap
Formula
=getUrlsFromSitemap("https://example.com/sitemap.xml")
Input
https://example.com/sitemap.xml
Output
UTIL
2D Array3 rows × 1 col
[0]https://example.com/
[1]https://example.com/about
[2]https://example.com/blog
Use case: extract sitemap urls google sheets
Data Validation•Google Autocomplete Suggestions
Formula
=suggestQueries("how to", "en")
Input
how to
Output
UTIL
2D Array3 rows × 1 col
[0]how to tie a tie
[1]how to screenshot
[2]how to lose weight
Use case: google autocomplete google sheets
URL Parsing•Extract Locale from Subdomain
Formula
=getLocaleBySubdomain(A2)
Input
https://es.example.com/page
Output
UTIL
es
Use case: extract locale subdomain google sheets
Array Operations•Combine Multiple Ranges
Formula
=combineAll(A1:A10, C1:C10, E1:E10)
Input
Multiple columns with data
Output
UTIL
2D Array5 rows × 1 col
[0]apple
[1]banana
[2]cherry
[3]date
[4]elderberry
Use case: combine ranges google sheets
Array Operations•Group Cells into String
Formula
=groupByCell(A1:A5, ", ")
Input
List of items in cells
Output
UTIL
apple, banana, cherry, date, elderberry
Use case: concatenate cells google sheets
Text Transformation•Cluster Keywords
Formula
=clusterize(A1:A100)
Input
List of 100 keywords
Output
UTIL
2D Array2 rows × 2 cols
[0]runningrunning shoes, running gear, running tips
[1]marathonmarathon training, marathon shoes
Use case: cluster keywords google sheets
URL Parsing•Check Redirect Chain
Formula
=checkRedirectChain("https://example.com/old")
Input
https://example.com/old
Output
UTIL
2D Array2 rows × 2 cols
[0]301https://example.com/old
[1]200https://example.com/new
Use case: check redirects google sheets
Data Validation•VLOOKUP with Two Criteria
Formula
=v2lookup("2024", "Q1", A:E, 5)
Input
Year: 2024, Quarter: Q1
Output
UTIL
125000
Use case: vlookup multiple criteria google sheets
Data Validation•VLOOKUP with Unlimited Criteria
Formula
=unlimitedVlookup("John", A:D, 4, "Sales", 2)
Input
Name: John, Department: Sales
Output
UTIL
$75,000
Use case: vlookup unlimited criteria google sheets
Text Transformation•Generate URL Slug from Title
Formula
=slugify(A2)
Input
My Awesome Blog Post!
Output
UTIL
my-awesome-blog-post
Use case: slugify text google sheets
Real-World Use Cases

Data transformation made simple

See how data professionals use these tools to automate complex operations.

URL Analysis Pipeline

Parse and analyze URLs to extract domains, paths, and parameters

Formula=getStatusCode(A2)
INPUTYour data
URL
https://www.example.com
https://google.com/search?q=test
https://github.com/nonexistent-page-404
RESULTProcessed
200 200 404

Data Cleaning Workflow

Validate, clean, and standardize messy data automatically

Formula=clusterize(A2:A10)
INPUTYour data
Keywords
running shoes
running tips
marathon training
RESULTProcessed
running: running shoes, running tips marathon: marathon training

Batch Transformation

Transform large datasets with powerful array operations

Formula=suggestQueries(A2, "en")
INPUTYour data
Seed Query
how to start
best laptops
learn python
RESULTProcessed
how to start a business, how to start investing... best laptops 2025, best laptops for gaming... learn python online, learn python for beginners...

Ready to unlock advanced data tools?

Most data tools are available on Free plan.

Pro plan unlocks all functions + higher limits.

Get Started FreeView Pricing

No credit card required • Install in 30 seconds • Cancel anytime