Calculations and formulas
Sums, averages, percentages, text and basic formulas.
Sum a column
Calculate a sum and add the result to a report or new column.
Average a column
Calculate the average of valid numeric values.
Median of a column
Calculate the median without uploading data.
Minimum and maximum
Find the smallest and largest values.
Count values
Count non-empty values in a column.
Count unique values
Count distinct values in a selected column.
Column percentage
Calculate each value share or a percentage between columns.
Round a column
Round numbers to a selected number of decimal places.
Combine columns
Combine text from several columns using a separator.
Split a column
Split text by a delimiter into new columns.
Extract email domain
Create a column containing the email domain.
Extract URL domain
Create a column containing the URL host.
Add row numbers
Add sequential record numbers.
Generate row IDs
Create identifiers with a prefix and leading zeros.
Generate row UUIDs
Add cryptographically random UUIDs to all records.
Excel formula generator
Build a common formula using a form and copy the result.
Explain an Excel formula
Recognize supported functions and show their structure.