SickSheet • sicksheet.com

Find LocationSelects the location of rows and columns in a spreadsheet.
Locate First N Row ColumnGives the first N rows or columns.
{type}
Locate Last N Row ColumnGives the last N rows or columns.
{type}
Locate Between Row ColumnSelects the range between two rows or columns.
{type}
Locate Even Row ColumnGives the even-numbered rows or columns.
{type}
Locate Odd Row ColumnGives the odd-numbered rows or columns.
{type}
Locate Nth Row ColumnGives the Nth row or column.
{type}
Locate Except Nth Row ColumnGives all rows or columns except the Nth ones.
{type}
Find ValueSearches or filters cells depending on the cell's own value.
Find TextFilter any specific text you want.
{type}
Find NumberFilter numerals like 1, 2, 3.
{type}
Find DateFilter values like yyyy-mm-dd or dd-mm-yyyy.
{type}
Find Lower CaseFilter small letters like abc.
{type}
Find Upper CaseFilter capital letters like ABC.
{type}
Find Proper CaseFilter text that are written like "Next Object".
{type}
Find Camel CaseFilter text that are written like "nextObject".
{type}
Find Snake CaseFilter text that are written like "next_object".
{type}
Find Pascal CaseFilter text that are written like "NextObject".
{type}
Find Hyphen CaseFilter text that are written like "hext-object".
{type}
Find Larger Than NumberFilter numbers like x < 2.
{type}
Find Smaller Than NumberFilter numbers like 2 < x.
{type}
Find Between NumbersFilter numbers like 2 < x < 7.
{type}
Find Negative NumberFilter numbers like x < 0.
{type}
Find Positive NumberFilter numbers like 0 < x.
{type}
Find ZeroFilter 0 in your table.
{type}
Find Leading SpaceFilter values with leading white spaces like " cat".
{type}
Find Trailing SpaceFilter values with ending white spaces "cat ".
{type}
Find Leading Trailing SpaceFilter values with leading or trailing spaces like " cat ".
{type}
Find PrefixFilter values with a specific starting word like "co-".
{type}
Find SuffixFilter values with a specific ending word like "tion".
{type}
Find BlankFilter empty cells.
{type}
Find Non BlankFilter non-empty cells.
{type}
Find ErrorFilter error values like "#REF!".
{type}
Find Non Breaking SpaceFilters an invisible space that prevents text wraping.
{type}
Find AccentFilter accent characters like äüö.
{type}
Find Repeating TextFilter consecutive occurrences of specific text.
{type}
Find Text Of LengthFilter values of a specific length.
{type}
Find AlphabetFilter values with a-z and A-Z.
{type}
Find Special CharFilter special characters like %^&@.
{type}
Find HyperlinkFilter links like "https://" or "www".
{type}
Find Decimal NumberFilter decimal numbers like 2.7.
{type}
Find Odd NumberFilter numbers not divisible by 2.
{type}
Find Even NumberFilter numbers divisible by 2.
{type}
Find Divisible NumberFilter numbers divisible by your specified value.
{type}
Find Fibonacci NumberFilter numbers appearing in the fibonacci sequence.
{type}
Find Prime NumberFilter numbers divisible only by 1 and itself.
{type}
Discover ValueSearches or filters cells depending on relative values of other cells.
Discover DuplicateFinds values that appear at least twice in your data.
{type}
Discover UniqueFinds values that appear exactly once.
{type}
Discover N Most OccurredFinds the n most occurred value.
{type}
Discover N Least OccurredFinds the n least occurred value.
{type}
Discover N Largest NumberFinds the biggest n numbers.
{type}
Discover N Smallest NumberFinds the smallest n numbers.
{type}
Discover Longest TextFinds the longest text.
{type}
Discover Shortest TextFinds the shortest text.
{type}
Discover Above AverageFinds values above the arithmetic average.
{type}
Discover Under AverageFinds values below the arithmetic average.
{type}
Discover Above Geometric MeanFinds values above the geometric mean.
{type}
Discover Under Geometric MeanFinds values below the geometric mean.
{type}
Discover Above Harmonic MeanFinds values above the harmonic mean.
{type}
Discover Under Harmonic MeanFinds values below the harmonic mean.
{type}
Discover Above MedianFinds values above the median.
{type}
Discover Under MedianFinds values below the median.
{type}
Discover Exclusive ValuesFinds values existing in one column but not the other.
{type}
Discover Inclusive ValuesFinds values existing in both comparing columns.
{type}
Discover QuantileFinds data's specific quantile value.
{type}
Discover PercentileFinds data's specific percentile value.
{type}
Discover DecileFinds data's specific decile value.
{type}
Discover OutlierFinds values that deviate significantly from others.
{type}

Modify TableChanges the structure of the entire table without editing the values.
Pivot TableCreates a pivot table for your data.
{type}
Join TablesJoin multiple tables based on the values in the first column.
{type}
Reverse TableInverse the order of the table horizontally or vertically.
{type}
Rotate TableClockwise rotate the entire table.
{type}
Shift TableMove the rows or columns forward by a defined amount.
{type}
Shuffle TableRandomize the rows or columns of a table.
{type}
Transpose TableMirror the table along its diagonal axis.
{type}
Append TablesCombines two tables horizontally or vertically.
{type}
Swap Row ColumnExchanges the positions of two rows or columns in a table.
{type}
Sample Row ColumnSample a random subset of rows or columns from a table.
{type}
Add Row ColumnAdds a new row or column to a table.
{type}
Move Row ColumnRelocates a row or column to a different position in a table.
{type}
Remove Row ColumnDeletes a row or column from a table.
{type}
Rank TableRank the column values in your column like "Rank 1", "Rank 2".
{type}
Rank Table In PercentRank the column values in your column like "Rank 25%", "Rank 50%".
{type}
Sort TableSort the table based on relative strength of the data.
{type}
Sort Table By LengthSort the table based on the length of the data.
{type}
Sort Table By OccurrenceSort the table based on how often the data appear in the table.
{type}
Remove Empty Row ColumnDelete empty rows or columns from a table.
{type}
Aggregate TablesOperate multiple tables together.
Add Two TablesAdd values element-wise for each cell.
{type}
Subtract Two TablesSubtract values element-wise for each cell.
{type}
Multiply Two TablesMultiply values element-wise for each cell.
{type}
Divide Two TablesDivide values element-wise for each cell.
{type}
Concatenate Two TablesConcatenate two tables cell-wise into a single table.
{type}
Compare Two TablesFind rows or columns that exists in one table but not the other.
{type}
Logarithm Two TablesCalculate the logarithm element-wise for each cell.
{type}
Modulo Two TablesCalculate the modulo operation element-wise for each cell.
{type}
Exponent Two TablesCalculate the exponent element-wise for each cell.
{type}
Add Two ColumnsAdd values element-wise for each column.
{type}
Subtract Two ColumnsSubtract values element-wise for each column.
{type}
Multiply Two ColumnsMultiply values element-wise for each column.
{type}
Dot Product Two TablesCalculate the dot product of two tables and create a new table with the result.
{type}
Divide Two ColumnsDivide values element-wise for each column.
{type}
Concatenate Two ColumnsConcatenate two columns' text or numbers together.
{type}
Dot Product Two ColumnsComputes dot product of two columns.
{type}
Vector Product Two ColumnsCalculates vector/cross product of two columns.
{type}
Modulo Two ColumnsComputes remainder when one column's value divides another's.
{type}
Exponent Two ColumnsRaises one column's values to the power of another's.
{type}
Logarithm Two ColumnsCalculates logarithm of one column using another as the base.
{type}
Subtract Two DatesCalculates the difference in days between two dates.
{type}
Add ValueAdds data to the table.
Add SuffixAdd a ending word to cells like "10 -th".
{type}
Add PrefixAdd a starting word to cells like "1. Section".
{type}
Add Leading ZeroAdd a starting zero to your data like "0057".
{type}
Add Trailing ZeroAdd a ending zero to your data like "5700".
{type}
Add Hyphen After SpaceAdd a hyphen after a space like "Cute - Animal".
{type}
Add Space After DotAdd a dot after space like "A aat. A dog.".
{type}
Add Space After CommaAdd a comma after space like "A cat, a dog.".
{type}
Add Bullet Point Before New LineAdds a bullet point in front of each new line.
{type}
Add IndentAdds indentation to the start of cells like " cat".
{type}
Add PunctuationAppends punctuation to the end of sentence like "cat.".
{type}
Add Thousand SignAdds a thousand separators in numerical values like "5,000".
{type}
Remove ValueRemoves data rom the table.
Remove DuplicatesDelete values that appear more than once.
{type}
Remove Leading ZeroDelete starting zeros from value like 0020.
{type}
Remove Trailing ZeroDelete ending zeros from value like 4600.
{type}
Remove Leading Trailing SpaceDelete starting and ending spaces from values.
{type}
Remove Starting CharactersDelete a specified number of letters from the beginning of a cell value.
{type}
Remove Trailing CharactersDelete a specified number of letters from the end of a cell value.
{type}
Remove Repeating SpaceDelete consecutive spaces within a cell like "A and b.".
{type}
Remove IndentDeletes indentation from cell beginnings.
{type}
Remove New Line From SentenceStrips newline characters from sentences.
{type}
Remove AccentDelete accented characters from text like "äöü".
{type}
Remove PunctuationDeletes "." from data.
{type}
Remove Exclamation MarkDeletes '!' from data.
{type}
Remove Question MarkDeletes '?' from data.
{type}
Remove CommaDeletes ',' from data.
{type}
Remove Special CharacterDeletes values like %^&@.
{type}
Remove Thousand SignDelete thousand separators from numbers like "7,000".
{type}
Remove DateDelete dates in yyyy-mm-dd or other formats.
{type}
Replace ValueReplaces existing data with a new data.
Replace By Lower CaseConvert cell value to be all lower case.
{type}
Replace By Proper CaseConvert cell value to proper case.
{type}
Replace By Upper CaseConvert cell value to upper case.
{type}
Replace By Camel CaseConverts text into camelCase format.
{type}
Replace By Snake CaseConverts text into snake_case format.
{type}
Replace By Pascal CaseTransforms text into PascalCase format.
{type}
Replace By Hyphen CaseConverts text into hyphen-case format.
{type}
Replace SymbolReplace letters in a cell with another letter.
{type}
Replace SpaceReplace space a cell value with specified letters.
{type}
Replace AccentReplace accent letters like "äüö".
{type}
Replace CommaReplace comma a cell value with specified letters.
{type}
Map ValueApplies a widely known function to the data to modify it.
Apply AdditionAdd a specified number to the entre table.
{type}
Apply SubtractionSubtract a specified number from the entire table.
{type}
Apply MultiplicationMultiple a specified number with the entire table.
{type}
Apply DivisionDivide a specified number from the entire table.
{type}
Apply Absolute FunctionReturning the positive value of each number.
{type}
Apply Sign FunctionMap all positives to 1 and negatives to -1.
{type}
Apply NegationInvert the numbers in a table.
{type}
Apply ModuloFinding the remainder after division by a specified value.
{type}
Apply Logarithmic FunctionCalculating the logarithm value for each number.
{type}
Apply Exponential FunctionRaising each number to the power of any number.
{type}
Apply Power FunctionApply the power function using each number of the table.
{type}
Apply Root FunctionFinding the square root or nth root of each number.
{type}
Apply Sine FunctionApply the sine function to numbers in a table.
{type}
Apply Tangent FunctionApply the tangent function to numbers in a table.
{type}
Apply Cosine FunctionCalculating the cosine value for each number.
{type}
Apply Factorial FunctionCalculating the factorial result for each number.
{type}
Apply NormalizationScaling numbers to a common range or format like 0 and 1.
{type}
Limit Maximum NumberClip the maximum value of a table to a specified threshold.
{type}
Limit Minimum NumberClip the minimum value of a table to a specified threshold.
{type}
Map Text To LengthConverts each value to their text length.
{type}
Map Text To Word CountCounts the amount of words in every cell.
{type}
Map To PercentConvert absolute numbers to their percent numbers.
{type}
Truncate CellShortens cell content to a set length like "A sentence...".
{type}
Map To ReversedReverse the order of letter in a text.
{type}
Map To Shuffled CharacterRandomizes character order within cells.
{type}
Map To Shuffled WordRandomizes word order within cells.
{type}
Map To Shuffled SentenceRandomizes sentence order within cells.
{type}
Add New Line To SentenceAppends a newline at the start of sentences.
{type}
Compute Days Until DateCounts days from today until the specified date.
{type}
Compute Days Since DateCounts days since the given date up to today.
{type}
Round NumberRound numbers in a table to the nearest number.
{type}
Round Up NumberRound up numbers in a table to the nearest number.
{type}
Round Down NumberRound down numbers in a table to the nearest number.
{type}
Reformat DateChanges date entries to a different format like yyyy-mm-dd.
{type}
Split ValueDivides data into multiple rows or columns.
Split TextSplits text in one column into multiple columns.
{type}
Split DateBreaks date into day, month, and year columns.
{type}
Extract ValueCreate a subset of the original data based on certain aspects.
Extract AlphabetsExtracts alphabets from cell like "Abc".
{type}
Extract Lower CaseExtracts lower case letters from cell like "abc".
{type}
Extract Upper CaseExtracts capital letters from cell like "ABC".
{type}
Extract NumbersExtracts numbers from a cell like "123".
{type}
Extract AccentExtracts accent from values like "äöü".
{type}
Extract DateExtracts dates from cell like "2024-05-25".
{type}
Extract Year From DateExtracts year from date like "2024".
{type}
Extract Month From DateExtracts month from date like "05".
{type}
Extract Day From DateExtracts day from date like "25".
{type}
Extract Special CharactersExtracts special letters from cell like "%^&@".
{type}
Convert MetricConverts one metric format into another equivalent format.
Convert Text To NumberConvert text strings representing numbers in a column of a table into numeric values.
{type}
Convert Number To TextConvert numeric values in a column of a table into text strings.
{type}
Convert Text To Arabic NumeralsConvert numeric words "one" to Arabic numerals "1".
{type}
Convert Arabic Numerals To TextConvert Arabic numerals "1" to text words like "one".
{type}
Convert Arabic Numerals To RomanConvert Arabic numerals like "1" to Roman numeral "I".
{type}
Convert Roman Numerals To ArabicConvert Roman numeral "I" to Arabic numeral "1".
{type}
Convert Date To WeekdayConvert one date unit to week of year like "Monday".
{type}
Convert Date To Quarter Of YearConvert one date unit to quarter of year like "Q1".
{type}
Convert Date To Week Of YearConvert one date unit to week of year like "2026 CW45".
{type}
Convert Date To Day Of YearConvert one date unit to day of year like "Day 141".
{type}
Convert Date To Business Day Of YearConvert one date unit to business day of year like "Business Day 211".
{type}
Convert Date To Day Of MonthConvert one date unit to day of month like "25".
{type}
Convert Date To Natural LanguageConvert one date unit to natrual language like "3rd November 1891".
{type}
Convert Area UnitConvert one area unit to another (like square meter).
{type}
Convert Length UnitConvert one length unit to another (like meter).
{type}
Convert Temperature UnitConvert one temperature unit to another (like celsius).
{type}
Convert Volume UnitConvert one volume unit to another (like liter).
{type}
Convert Weight UnitConvert one weight unit to another (like gram).
{type}
Convert Speed UnitConvert one speed unit to another (like kmh).
{type}
Convert Angle UnitConvert one angle unit to another (like degree).
{type}
Convert Information UnitConvert one information unit to another (like mega byte).
{type}
Convert Density UnitConvert one density unit to another (like grams/liter).
{type}
Convert Electric Current UnitConvert one electric current unit to another (like ampere).
{type}
Convert Energy UnitConvert one energy current unit to another (like calories).
{type}
Convert Force UnitConvert one force unit to another (like newton).
{type}
Convert Mass UnitConvert one mass unit to another (like tonnes).
{type}
Convert Pressure UnitConvert one pressure unit to another (like hector bars).
{type}
Convert Time UnitConvert one time unit to another (like mili seconds).
{type}
Convert Frequency UnitConvert one frequency unit to another (like mega herz).
{type}

Calculate ValueGenerate new values from the table without editing the existing values.
Calculate SumComputes the total sum in each row and column.
{type}
Calculate DifferenceComputes the total difference in each row and column.
{type}
Calculate ProductComputes the total product in each row and column.
{type}
Calculate QuotientComputes the quotient in each row and column.
{type}
Calculate ModeComputes the most frequent value in each row and column.
{type}
Calculate Duplicate Cell CountCount the number of duplicated cells in each row and column.
{type}
Calculate Unique Cell CountCount the number of unique cells in each row and column.
{type}
Calculate MaximumComputes the maximum value in each row and column.
{type}
Calculate MinimumComputes the minimum value in each row and column.
{type}
Calculate RangeComputes the range between minimum and maximum in each row and column.
{type}
Calculate Blank CountCount the number of empty cells in each row and column.
{type}
Calculate Non Blank CountCount the number of non empty cells in each row and column.
{type}
Calculate Geometric MeanComputes the geometric mean in each row and column.
{type}
Calculate Harmonic MeanComputes the harmonic mean in each row and column.
{type}
Calculate MeanComputes the arithmetic mean in each row and column.
{type}
Calculate MedianComputes the median value in each row and column.
{type}
Calculate ConcatenationConcatenate the values for each row and column.
{type}
Calculate Maximum DateComputes the maximum date in each row and column.
{type}
Calculate Minimum DateComputes the minimum date in each row and column.
{type}
Calculate Range Of DatesComputes the date range in each row and column.
{type}
Calculate QuantileComputes the 2nd, 3rd quantile value in each row and column.
{type}
Calculate CovarianceComputes the covariance of all columns against other columns.
{type}
Calculate Kendrall CorrelationComputes two column's or row's ordinal association.
{type}
Calculate KurtosisComputes the tailedness or peakedness in each row and column.
{type}
Calculate Pearson CorrelationComputes two column's or row's linear relationship.
{type}
Calculate SkewnessComputes the asymmetry of the data distribution in each row and column.
{type}
Calculate Spearman CorrelationComputes two column's or row's monotonic relationship.
{type}
Calculate Standard DeviationComputes the standard deviation in each row and column.
{type}
Calculate VarianceComputes the variance in each row and column.
{type}
Calculate Rolling ValueGenerate new values from the table without editing the existing values using Rolling windows.
Rolling SumComputes the rolling sum of a specified window size for a dataset.
{type}
Rolling QuotientComputes the rolling quotient of a specified window size for a dataset.
{type}
Rolling ProductComputes the rolling product of a specified window size for a dataset.
{type}
Rolling DifferenceComputes the rolling difference of a specified window size for a dataset.
{type}
Rolling Duplicate Cell CountCount duplicate cells within a specified window size for a dataset.
{type}
Rolling ModeComputes the rolling mode of a specified window size for a dataset.
{type}
Rolling Unique Cell CountCount distinct cells within a specified window size for a dataset.
{type}
Rolling MaximumComputes the rolling maximum of a specified window size for a dataset.
{type}
Rolling MinimumComputes the rolling minimum of a specified window size for a dataset.
{type}
Rolling RangeComputes the rolling range of a specified window size for a dataset.
{type}
Rolling Blank CountCount empty cells within a specified window size for a dataset.
{type}
Rolling Non Blank CountCount non-empty cells within a specified window size for a dataset.
{type}
Rolling Geometric MeanComputes the rolling geometric mean of a specified window size for a dataset.
{type}
Rolling Harmonic MeanComputes the rolling harmonic mean of a specified window size for a dataset.
{type}
Rolling MeanComputes the rolling mean (average) of a specified window size for a dataset.
{type}
Rolling MedianComputes the rolling median of a specified window size for a dataset.
{type}
Rolling ConcatenationConcatenate the values within a specified window size for a dataset to form a single string.
{type}
Rolling Percent DifferenceComputes the rolling percentage difference of a specified window size for a dataset.
{type}
Rolling QuantileComputes the rolling quantile of a specified window size for a dataset.
{type}
Rolling KurtosisComputes the rolling kurtosis of a specified window size for a dataset.
{type}
Rolling SkewnessComputes the rolling skewness of a specified window size for a dataset.
{type}
Rolling Standard DeviationComputes the rolling standard deviation of a specified window size for a dataset.
{type}
Rolling VarianceComputes the rolling variance of a specified window size for a dataset.
{type}
Calculate Cumulative ValueGenerate new values from the table without editing the existing values using Cumulative Windows.
Cumulative SumComputes the cumulative sum in a dataset up to each row or column.
{type}
Cumulative QuotientComputes the cumulative quotient in a dataset up to each row or column.
{type}
Cumulative ProductComputes the cumulative product in a dataset up to each row or column.
{type}
Cumulative DifferenceComputes the cumulative difference in a dataset up to each row or column.
{type}
Cumulative Duplicate Cell CountCount duplicate cells in a dataset up to each row or column.
{type}
Cumulative ModeComputes the cumulative mode in a dataset up to each row or column.
{type}
Cumulative Unique Cell CountCount distinct cells in a dataset up to each row or column.
{type}
Cumulative MaximumComputes the cumulative maximum in a dataset up to each row or column.
{type}
Cumulative MinimumComputes the cumulative minimum in a dataset up to each row or column.
{type}
Cumulative RangeComputes the cumulative range in a dataset up to each row or column.
{type}
Cumulative Blank CountCount empty cells in a dataset up to each row or column.
{type}
Cumulative Non Blank CountCount non-empty cells in a dataset up to each row or column.
{type}
Cumulative Geometric MeanComputes the cumulative geometric mean in a dataset up to each row or column.
{type}
Cumulative Harmonic MeanComputes the cumulative harmonic mean in a dataset up to each row or column.
{type}
Cumulative MeanComputes the cumulative arithmetic mean in a dataset up to each row or column.
{type}
Cumulative MedianComputes the cumulative median in a dataset up to each row or column.
{type}
Cumulative ConcatenationConcatenate the values in a dataset up to each row or column to form a single string.
{type}
Cumulative QuantileComputes the cumulative quantile in a dataset up to each row or column.
{type}
Cumulative KurtosisComputes the cumulative kurtosis in a dataset up to each row or column.
{type}
Cumulative SkewnessComputes the cumulative skewness in a dataset up to each row or column.
{type}
Cumulative Standard DeviationComputes the cumulative standard deviation in a dataset up to each row or column.
{type}
Cumulative VarianceComputes the cumulative variance in a dataset up to each row or column.
{type}
Calculate Group ValueGenerate new values from the table without editing the existing values using SQL-like Groupby.
Groupby SumComputes the sum of values in a dataset grouped by a specified column.
{type}
Groupby QuotientComputes the quotient of values in a dataset grouped by a specified column.
{type}
Groupby ProductComputes the product of values in a dataset grouped by a specified column.
{type}
Groupby DifferenceComputes the difference in a dataset grouped by a specified column.
{type}
Groupby Duplicate Cell CountCount duplicate cells in a dataset grouped by a specified column.
{type}
Groupby ModeComputes the mode of values in a dataset grouped by a specified column.
{type}
Groupby Unique Cell CountCount distinct values in a dataset grouped by a specified column.
{type}
Groupby FirstPerforms a SQL grouby and returns the first element of each item.
{type}
Groupby LastPerforms a SQL grouby and returns the last element of each item.
{type}
Groupby MaximumComputes the maximum value in a dataset grouped by a specified column.
{type}
Groupby MinimumComputes the minimum value in a dataset grouped by a specified column.
{type}
Groupby RangeComputes the range of values in a dataset grouped by a specified column.
{type}
Groupby Blank CountCount empty cells in a dataset grouped by a specified column.
{type}
Groupby Non Blank CountCount non-empty cells in a dataset grouped by a specified column.
{type}
Groupby Geometric MeanComputes the geometric mean of values in a dataset grouped by a specified column.
{type}
Groupby Harmonic MeanComputes the harmonic mean of values in a dataset grouped by a specified column.
{type}
Groupby MeanComputes the mean (average) of values in a dataset grouped by a specified column.
{type}
Groupby MedianComputes the median of values in a dataset grouped by a specified column.
{type}
Groupby ConcatenationConcatenate the values in a dataset grouped by a specified column.
{type}
Groupby Percent DifferenceComputes the percentage difference in a dataset grouped by a specified column.
{type}
Groupby QuantileComputes the quantile of values in a dataset grouped by a specified column.
{type}
Groupby KurtosisComputes the kurtosis of values in a dataset grouped by a specified column.
{type}
Groupby SkewnessComputes the skewness of values in a dataset grouped by a specified column.
{type}
Groupby Standard DeviationComputes the standard deviation of values in a dataset grouped by a specified column.
{type}
Groupby VarianceComputes the variance of values in a dataset grouped by a specified column.
{type}

Table.Structure

Tools about restructuring the entire table.

Sample Row Column

Sample a random subset of rows or columns from a table.

Reverse Table

Inverse the order of the table horizontally or vertically.

Rotate Table

Clockwise rotate the entire table.

Shift Table

Move the rows or columns forward by a defined amount.

Shuffle Table

Randomize the rows or columns of a table.

Join Tables

Join multiple tables based on the values in the first column.

Pivot Table

Creates a pivot table for your data.

Transpose Table

Mirror the table along its diagonal axis.

Column.Structure

Tools about restructuring columns or rows.

Sort Table

Sort the table based on relative strength of the data.

Move Row Column

Relocates a row or column to a different position in a table.

Remove Row Column

Deletes a row or column from a table.

Rank Table

Rank the column values in your column like "Rank 1", "Rank 2".

Rank Table In Percent

Rank the column values in your column like "Rank 25%", "Rank 50%".

Sort Table By Length

Sort the table based on the length of the data.

Swap Row Column

Exchanges the positions of two rows or columns in a table.

Add Row Column

Adds a new row or column to a table.

Sort Table By Occurrence

Sort the table based on how often the data appear in the table.

Column.Location

Tools about finding specific locations in a table.

Locate First N Row Column

Gives the first N rows or columns.

Locate Last N Row Column

Gives the last N rows or columns.

Locate Between Row Column

Selects the range between two rows or columns.

Locate Even Row Column

Gives the even-numbered rows or columns.

Locate Odd Row Column

Gives the odd-numbered rows or columns.

Locate Except Nth Row Column

Gives all rows or columns except the Nth ones.

Locate Nth Row Column

Gives the Nth row or column.

Cell.Occurence

Tools about how frequent a value appear.

Calculate Unique Cell Count

Count the number of unique cells in each row and column.

Remove Duplicates

Delete values that appear more than once.

Calculate Mode

Computes the most frequent value in each row and column.

Discover N Most Occurred

Finds the n most occurred value.

Discover N Least Occurred

Finds the n least occurred value.

Calculate Duplicate Cell Count

Count the number of duplicated cells in each row and column.

Cumulative Mode

Computes the cumulative mode in a dataset up to each row or column.

Rolling Mode

Computes the rolling mode of a specified window size for a dataset.

Rolling Unique Cell Count

Count distinct cells within a specified window size for a dataset.

Cumulative Duplicate Cell Count

Count duplicate cells in a dataset up to each row or column.

Discover Unique

Finds values that appear exactly once.

Cumulative Unique Cell Count

Count distinct cells in a dataset up to each row or column.

Groupby Duplicate Cell Count

Count duplicate cells in a dataset grouped by a specified column.

Groupby Mode

Computes the mode of values in a dataset grouped by a specified column.

Groupby Unique Cell Count

Count distinct values in a dataset grouped by a specified column.

Groupby First

Performs a SQL grouby and returns the first element of each item.

Groupby Last

Performs a SQL grouby and returns the last element of each item.

Rolling Duplicate Cell Count

Count duplicate cells within a specified window size for a dataset.

Discover Duplicate

Finds values that appear at least twice in your data.

Cell.Length

Tools about length of a value.

Remove Empty Row Column

Delete empty rows or columns from a table.

Cumulative Blank Count

Count empty cells in a dataset up to each row or column.

Cumulative Non Blank Count

Count non-empty cells in a dataset up to each row or column.

Calculate Blank Count

Count the number of empty cells in each row and column.

Find Non Blank

Filter non-empty cells.

Find Text Of Length

Filter values of a specific length.

Rolling Non Blank Count

Count non-empty cells within a specified window size for a dataset.

Rolling Blank Count

Count empty cells within a specified window size for a dataset.

Find Blank

Filter empty cells.

Calculate Non Blank Count

Count the number of non empty cells in each row and column.

Groupby Non Blank Count

Count non-empty cells in a dataset grouped by a specified column.

Find Text

Filter any specific text you want.

Discover Longest Text

Finds the longest text.

Discover Shortest Text

Finds the shortest text.

Map Text To Word Count

Counts the amount of words in every cell.

Map Text To Length

Converts each value to their text length.

Groupby Blank Count

Count empty cells in a dataset grouped by a specified column.

Replace Symbol

Replace letters in a cell with another letter.

Cell.Exclusivity

Tools about duplications and uniqueness

Discover Inclusive Values

Finds values existing in both comparing columns.

Discover Exclusive Values

Finds values existing in one column but not the other.

Cell.Similarity

Tools to compare cells with matching or closely related content.

Compare Two Tables

Find rows or columns that exists in one table but not the other.

Text.Case

Tools about upper case and lower case texts.

Replace By Upper Case

Convert cell value to upper case.

Replace By Proper Case

Convert cell value to proper case.

Replace By Lower Case

Convert cell value to be all lower case.

Find Hyphen Case

Filter text that are written like "hext-object".

Replace By Camel Case

Converts text into camelCase format.

Replace By Hyphen Case

Converts text into hyphen-case format.

Replace By Pascal Case

Transforms text into PascalCase format.

Replace By Snake Case

Converts text into snake_case format.

Find Lower Case

Filter small letters like abc.

Extract Upper Case

Extracts capital letters from cell like "ABC".

Find Upper Case

Filter capital letters like ABC.

Find Proper Case

Filter text that are written like "Next Object".

Extract Lower Case

Extracts lower case letters from cell like "abc".

Find Snake Case

Filter text that are written like "next_object".

Find Pascal Case

Filter text that are written like "NextObject".

Find Camel Case

Filter text that are written like "nextObject".

Text.Affix

Tools about starting and leading letters.

Remove Leading Zero

Delete starting zeros from value like 0020.

Remove Trailing Characters

Delete a specified number of letters from the end of a cell value.

Add Trailing Zero

Add a ending zero to your data like "5700".

Find Trailing Space

Filter values with ending white spaces "cat ".

Add Prefix

Add a starting word to cells like "1. Section".

Remove Leading Trailing Space

Delete starting and ending spaces from values.

Remove Starting Characters

Delete a specified number of letters from the beginning of a cell value.

Find Leading Space

Filter values with leading white spaces like " cat".

Truncate Cell

Shortens cell content to a set length like "A sentence...".

Add Leading Zero

Add a starting zero to your data like "0057".

Add Suffix

Add a ending word to cells like "10 -th".

Find Prefix

Filter values with a specific starting word like "co-".

Find Suffix

Filter values with a specific ending word like "tion".

Remove Trailing Zero

Delete ending zeros from value like 4600.

Find Leading Trailing Space

Filter values with leading or trailing spaces like " cat ".

Text.Concat

Tools about text concatenation and splitting

Groupby Concatenation

Concatenate the values in a dataset grouped by a specified column.

Concatenate Two Columns

Concatenate two columns' text or numbers together.

Rolling Concatenation

Concatenate the values within a specified window size for a dataset to form a single string.

Cumulative Concatenation

Concatenate the values in a dataset up to each row or column to form a single string.

Split Text

Splits text in one column into multiple columns.

Calculate Concatenation

Concatenate the values for each row and column.

Concatenate Two Tables

Concatenate two tables cell-wise into a single table.

Append Tables

Combines two tables horizontally or vertically.

Text.Order

Tools about sorting and arranging text in specific sequences.

Map To Shuffled Word

Randomizes word order within cells.

Map To Shuffled Sentence

Randomizes sentence order within cells.

Map To Reversed

Reverse the order of letter in a text.

Map To Shuffled Character

Randomizes character order within cells.

Text.Space Sign

Tools related to manage spaces, tabs, and other whitespace characters.

Add Space After Dot

Add a dot after space like "A aat. A dog.".

Replace Space

Replace space a cell value with specified letters.

Add Space After Comma

Add a comma after space like "A cat, a dog.".

Find Non Breaking Space

Filters an invisible space that prevents text wraping.

Remove Repeating Space

Delete consecutive spaces within a cell like "A and b.".

Remove Indent

Deletes indentation from cell beginnings.

Remove New Line From Sentence

Strips newline characters from sentences.

Add Bullet Point Before New Line

Adds a bullet point in front of each new line.

Add New Line To Sentence

Appends a newline at the start of sentences.

Add Indent

Adds indentation to the start of cells like " cat".

Add Hyphen After Space

Add a hyphen after a space like "Cute - Animal".

Text.Special Sign

Tools about custom character operations.

Convert Number To Text

Convert numeric values in a column of a table into text strings.

Convert Text To Number

Convert text strings representing numbers in a column of a table into numeric values.

Convert Text To Arabic Numerals

Convert numeric words "one" to Arabic numerals "1".

Find Accent

Filter accent characters like äüö.

Convert Arabic Numerals To Roman

Convert Arabic numerals like "1" to Roman numeral "I".

Convert Roman Numerals To Arabic

Convert Roman numeral "I" to Arabic numeral "1".

Replace Accent

Replace accent letters like "äüö".

Remove Accent

Delete accented characters from text like "äöü".

Extract Accent

Extracts accent from values like "äöü".

Convert Arabic Numerals To Text

Convert Arabic numerals "1" to text words like "one".

Text.Other Sign

Tools about common character operations.

Extract Alphabets

Extracts alphabets from cell like "Abc".

Find Error

Filter error values like "#REF!".

Extract Special Characters

Extracts special letters from cell like "%^&@".

Remove Thousand Sign

Delete thousand separators from numbers like "7,000".

Remove Special Character

Deletes values like %^&@.

Remove Comma

Deletes ',' from data.

Remove Question Mark

Deletes '?' from data.

Remove Exclamation Mark

Deletes '!' from data.

Remove Punctuation

Deletes "." from data.

Find Special Char

Filter special characters like %^&@.

Replace Comma

Replace comma a cell value with specified letters.

Find Hyperlink

Filter links like "https://" or "www".

Find Repeating Text

Filter consecutive occurrences of specific text.

Add Thousand Sign

Adds a thousand separators in numerical values like "5,000".

Add Punctuation

Appends punctuation to the end of sentence like "cat.".

Find Alphabet

Filter values with a-z and A-Z.

Number.Basic

Tools about sum, addition and subtractions.

Divide Two Columns

Divide values element-wise for each column.

Add Two Tables

Add values element-wise for each cell.

Rolling Sum

Computes the rolling sum of a specified window size for a dataset.

Multiply Two Tables

Multiply values element-wise for each cell.

Calculate Quotient

Computes the quotient in each row and column.

Calculate Product

Computes the total product in each row and column.

Calculate Difference

Computes the total difference in each row and column.

Subtract Two Tables

Subtract values element-wise for each cell.

Multiply Two Columns

Multiply values element-wise for each column.

Rolling Product

Computes the rolling product of a specified window size for a dataset.

Apply Addition

Add a specified number to the entre table.

Apply Subtraction

Subtract a specified number from the entire table.

Apply Multiplication

Multiple a specified number with the entire table.

Apply Division

Divide a specified number from the entire table.

Calculate Sum

Computes the total sum in each row and column.

Rolling Difference

Computes the rolling difference of a specified window size for a dataset.

Rolling Quotient

Computes the rolling quotient of a specified window size for a dataset.

Cumulative Product

Computes the cumulative product in a dataset up to each row or column.

Cumulative Difference

Computes the cumulative difference in a dataset up to each row or column.

Groupby Quotient

Computes the quotient of values in a dataset grouped by a specified column.

Cumulative Quotient

Computes the cumulative quotient in a dataset up to each row or column.

Divide Two Tables

Divide values element-wise for each cell.

Cumulative Sum

Computes the cumulative sum in a dataset up to each row or column.

Groupby Sum

Computes the sum of values in a dataset grouped by a specified column.

Groupby Product

Computes the product of values in a dataset grouped by a specified column.

Groupby Difference

Computes the difference in a dataset grouped by a specified column.

Add Two Columns

Add values element-wise for each column.

Subtract Two Columns

Subtract values element-wise for each column.

Number.Size

Tools about relative strength of the numbers.

Calculate Range

Computes the range between minimum and maximum in each row and column.

Calculate Minimum

Computes the minimum value in each row and column.

Rolling Maximum

Computes the rolling maximum of a specified window size for a dataset.

Rolling Minimum

Computes the rolling minimum of a specified window size for a dataset.

Calculate Maximum

Computes the maximum value in each row and column.

Find Zero

Filter 0 in your table.

Find Positive Number

Filter numbers like 0 < x.

Rolling Range

Computes the rolling range of a specified window size for a dataset.

Extract Numbers

Extracts numbers from a cell like "123".

Find Between Numbers

Filter numbers like 2 < x < 7.

Find Number

Filter numerals like 1, 2, 3.

Limit Maximum Number

Clip the maximum value of a table to a specified threshold.

Limit Minimum Number

Clip the minimum value of a table to a specified threshold.

Groupby Range

Computes the range of values in a dataset grouped by a specified column.

Groupby Minimum

Computes the minimum value in a dataset grouped by a specified column.

Groupby Maximum

Computes the maximum value in a dataset grouped by a specified column.

Find Negative Number

Filter numbers like x < 0.

Find Larger Than Number

Filter numbers like x < 2.

Cumulative Minimum

Computes the cumulative minimum in a dataset up to each row or column.

Discover N Smallest Number

Finds the smallest n numbers.

Discover N Largest Number

Finds the biggest n numbers.

Cumulative Maximum

Computes the cumulative maximum in a dataset up to each row or column.

Find Smaller Than Number

Filter numbers like 2 < x.

Cumulative Range

Computes the cumulative range in a dataset up to each row or column.

Number.Mean

Tools about average values.

Discover Under Harmonic Mean

Finds values below the harmonic mean.

Discover Above Harmonic Mean

Finds values above the harmonic mean.

Discover Under Geometric Mean

Finds values below the geometric mean.

Cumulative Harmonic Mean

Computes the cumulative harmonic mean in a dataset up to each row or column.

Discover Above Geometric Mean

Finds values above the geometric mean.

Calculate Median

Computes the median value in each row and column.

Discover Under Average

Finds values below the arithmetic average.

Discover Above Average

Finds values above the arithmetic average.

Rolling Geometric Mean

Computes the rolling geometric mean of a specified window size for a dataset.

Rolling Harmonic Mean

Computes the rolling harmonic mean of a specified window size for a dataset.

Rolling Mean

Computes the rolling mean (average) of a specified window size for a dataset.

Discover Above Median

Finds values above the median.

Cumulative Geometric Mean

Computes the cumulative geometric mean in a dataset up to each row or column.

Discover Under Median

Finds values below the median.

Cumulative Mean

Computes the cumulative arithmetic mean in a dataset up to each row or column.

Groupby Median

Computes the median of values in a dataset grouped by a specified column.

Groupby Mean

Computes the mean (average) of values in a dataset grouped by a specified column.

Groupby Harmonic Mean

Computes the harmonic mean of values in a dataset grouped by a specified column.

Groupby Geometric Mean

Computes the geometric mean of values in a dataset grouped by a specified column.

Rolling Median

Computes the rolling median of a specified window size for a dataset.

Calculate Geometric Mean

Computes the geometric mean in each row and column.

Calculate Harmonic Mean

Computes the harmonic mean in each row and column.

Calculate Mean

Computes the arithmetic mean in each row and column.

Cumulative Median

Computes the cumulative median in a dataset up to each row or column.

Number.Percent

Tools focusing on percentage and absolute values.

Rolling Percent Difference

Computes the rolling percentage difference of a specified window size for a dataset.

Apply Absolute Function

Returning the positive value of each number.

Groupby Percent Difference

Computes the percentage difference in a dataset grouped by a specified column.

Map To Percent

Convert absolute numbers to their percent numbers.

Number.Distribution

Tools about statistical distribution.

Discover Quantile

Finds data's specific quantile value.

Groupby Quantile

Computes the quantile of values in a dataset grouped by a specified column.

Rolling Quantile

Computes the rolling quantile of a specified window size for a dataset.

Cumulative Quantile

Computes the cumulative quantile in a dataset up to each row or column.

Discover Outlier

Finds values that deviate significantly from others.

Calculate Quantile

Computes the 2nd, 3rd quantile value in each row and column.

Discover Decile

Finds data's specific decile value.

Discover Percentile

Finds data's specific percentile value.

Number.Correlation

Tools about statistical correlation.

Calculate Kendrall Correlation

Computes two column's or row's ordinal association.

Calculate Covariance

Computes the covariance of all columns against other columns.

Calculate Spearman Correlation

Computes two column's or row's monotonic relationship.

Calculate Pearson Correlation

Computes two column's or row's linear relationship.

Number.Deviation

Tools about statistical variance.

Groupby Kurtosis

Computes the kurtosis of values in a dataset grouped by a specified column.

Groupby Skewness

Computes the skewness of values in a dataset grouped by a specified column.

Cumulative Variance

Computes the cumulative variance in a dataset up to each row or column.

Rolling Skewness

Computes the rolling skewness of a specified window size for a dataset.

Cumulative Skewness

Computes the cumulative skewness in a dataset up to each row or column.

Cumulative Kurtosis

Computes the cumulative kurtosis in a dataset up to each row or column.

Rolling Kurtosis

Computes the rolling kurtosis of a specified window size for a dataset.

Calculate Kurtosis

Computes the tailedness or peakedness in each row and column.

Calculate Skewness

Computes the asymmetry of the data distribution in each row and column.

Calculate Standard Deviation

Computes the standard deviation in each row and column.

Calculate Variance

Computes the variance in each row and column.

Rolling Variance

Computes the rolling variance of a specified window size for a dataset.

Rolling Standard Deviation

Computes the rolling standard deviation of a specified window size for a dataset.

Cumulative Standard Deviation

Computes the cumulative standard deviation in a dataset up to each row or column.

Groupby Standard Deviation

Computes the standard deviation of values in a dataset grouped by a specified column.

Groupby Variance

Computes the variance of values in a dataset grouped by a specified column.

Number.Attribute

Tools about special numbers in science.

Find Prime Number

Filter numbers divisible only by 1 and itself.

Find Fibonacci Number

Filter numbers appearing in the fibonacci sequence.

Find Divisible Number

Filter numbers divisible by your specified value.

Find Even Number

Filter numbers divisible by 2.

Find Odd Number

Filter numbers not divisible by 2.

Find Decimal Number

Filter decimal numbers like 2.7.

Number.Advanced

Tools about advanced mathematical operations.

Vector Product Two Columns

Calculates vector/cross product of two columns.

Modulo Two Columns

Computes remainder when one column's value divides another's.

Exponent Two Columns

Raises one column's values to the power of another's.

Logarithm Two Columns

Calculates logarithm of one column using another as the base.

Dot Product Two Columns

Computes dot product of two columns.

Apply Sign Function

Map all positives to 1 and negatives to -1.

Apply Root Function

Finding the square root or nth root of each number.

Round Down Number

Round down numbers in a table to the nearest number.

Round Up Number

Round up numbers in a table to the nearest number.

Round Number

Round numbers in a table to the nearest number.

Apply Normalization

Scaling numbers to a common range or format like 0 and 1.

Apply Factorial Function

Calculating the factorial result for each number.

Apply Negation

Invert the numbers in a table.

Apply Cosine Function

Calculating the cosine value for each number.

Apply Modulo

Finding the remainder after division by a specified value.

Apply Logarithmic Function

Calculating the logarithm value for each number.

Apply Exponential Function

Raising each number to the power of any number.

Apply Power Function

Apply the power function using each number of the table.

Apply Sine Function

Apply the sine function to numbers in a table.

Dot Product Two Tables

Calculate the dot product of two tables and create a new table with the result.

Apply Tangent Function

Apply the tangent function to numbers in a table.

Exponent Two Tables

Calculate the exponent element-wise for each cell.

Modulo Two Tables

Calculate the modulo operation element-wise for each cell.

Logarithm Two Tables

Calculate the logarithm element-wise for each cell.

Number.Unit

Tools for converting measurement units.

Convert Time Unit

Convert one time unit to another (like mili seconds).

Convert Frequency Unit

Convert one frequency unit to another (like mega herz).

Convert Pressure Unit

Convert one pressure unit to another (like hector bars).

Convert Volume Unit

Convert one volume unit to another (like liter).

Convert Force Unit

Convert one force unit to another (like newton).

Convert Weight Unit

Convert one weight unit to another (like gram).

Convert Speed Unit

Convert one speed unit to another (like kmh).

Convert Area Unit

Convert one area unit to another (like square meter).

Convert Mass Unit

Convert one mass unit to another (like tonnes).

Convert Angle Unit

Convert one angle unit to another (like degree).

Convert Information Unit

Convert one information unit to another (like mega byte).

Convert Density Unit

Convert one density unit to another (like grams/liter).

Convert Length Unit

Convert one length unit to another (like meter).

Convert Temperature Unit

Convert one temperature unit to another (like celsius).

Convert Electric Current Unit

Convert one electric current unit to another (like ampere).

Convert Energy Unit

Convert one energy current unit to another (like calories).

Date.General

Tools that address a broad spectrum of date-related tasks.

Remove Date

Delete dates in yyyy-mm-dd or other formats.

Extract Day From Date

Extracts day from date like "25".

Extract Date

Extracts dates from cell like "2024-05-25".

Find Date

Filter values like yyyy-mm-dd or dd-mm-yyyy.

Extract Month From Date

Extracts month from date like "05".

Split Date

Breaks date into day, month, and year columns.

Extract Year From Date

Extracts year from date like "2024".

Date.Format

Tools to adjust, convert, and manage the way dates are displayed.

Convert Date To Day Of Year

Convert one date unit to day of year like "Day 141".

Reformat Date

Changes date entries to a different format like yyyy-mm-dd.

Convert Date To Natural Language

Convert one date unit to natrual language like "3rd November 1891".

Convert Date To Day Of Month

Convert one date unit to day of month like "25".

Convert Date To Business Day Of Year

Convert one date unit to business day of year like "Business Day 211".

Convert Date To Weekday

Convert one date unit to week of year like "Monday".

Convert Date To Quarter Of Year

Convert one date unit to quarter of year like "Q1".

Convert Date To Week Of Year

Convert one date unit to week of year like "2026 CW45".

Date.Size

Tools to determine the span or range of dates.

Calculate Range Of Dates

Computes the date range in each row and column.

Calculate Minimum Date

Computes the minimum date in each row and column.

Calculate Maximum Date

Computes the maximum date in each row and column.

Date.Duration

Tools to calculate and represent the length of time intervals.

Subtract Two Dates

Calculates the difference in days between two dates.

Compute Days Since Date

Counts days since the given date up to today.

Compute Days Until Date

Counts days from today until the specified date.