Convert a Google Sheets range to JSON with TABLE_TO_JSON
Convert a range to a JSON object with multiple items.
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.
Clean to Type
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.
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.