spreadcheats, making sheets work for you

Share your #spreadcheats

Copy & paste verified solutions for Google Sheets

View Latest Cheats

Featured Cheats

Data Generation

Convert a Google Sheets range to JSON with TABLE_TO_JSON

Convert a range to a JSON object with multiple items.

Type Validation

Validate an inbound email list in Google Sheets with VALIDATE_EMAIL

Validate text is valid email format, top-level domain, and not from a spam domain.

Most Recent

Data Generation

Convert a Google Sheets range into URL key & value parameters with TABLE_TO_KV

Convert a table of data into properly encoded key and value strings for passing parameters on a URL or elsewhere.

Add leading "0" other characters before a number or string in Google Sheets with PAD

Create fixed length strings from a number or text input with configurable leading characters.

Data Generation

Transform dates to financial half year in Google Sheets with SEMIANNUAL

Convert a range of dates to financial half-year in four different output formats.

Sum a range by row in Google Sheets with SUMROWS

Output the sum by row of several rows in a table without depending on filling down.

Lucas A. Browne Dias

Data Generation

Get all combinations from sets in multiple lists in Google Sheets with COMBINE

Output all the different combinations of a sets of text in three formats.

Lucas A. Browne Dias