Transform the way you do data transformations with Formula Columns

Express complex data transformations with 100+ supported Excel formulas.
No SQL knowledge required. Visitran translates your Formulas into warehouse-optimized SQL queries.

Explore the Possibilities

Browse through our comprehensive collection of formula categories to find the perfect transformation for your data needs.

icon related to Bitwise Operations

Bitwise Operations

BITAND · BITLSHIFT · BITOR · BITRSHIFT · BITXOR
icon related to Conditional Logic & Business Rules

Conditional Logic & Business Rules

AND · BETWEEN · CHOOSE · IF · IFNA · IFS · ISIN · NOT · NOTIN · OR · SWITCH · XOR
icon related to Data Cleaning & Formatting

Data Cleaning & Formatting

CLEAN · TRIM · UPPER · LOWER · PROPER · FIXED · REPT · SUBSTITUTE
icon related to Data Type Conversion

Data Type Conversion

CAST · NUMBERVALUE · N · INT
icon related to Data Validation & Quality Checks

Data Validation & Quality Checks

DUPLICATE · FALSE · ISBLANK · ISEVEN · ISNA · ISNUMBER · ISODD · ISTEXT · TRUE
icon related to Mathematical Transformations

Mathematical Transformations

ABS · CEILING · DELTA · EVEN · EXP · FLOOR · GESTEP · LN · LOG · LOG10 · MOD · ODD · PI · POWER · QUOTIENT · ROUND · ROUNDDOWN · ROUNDUP · SIGN · SQRT · SQRTPI
icon related to Date & Time Transformations

Date & Time Transformations

DATE · DAY · DAYS · EDATE · HOUR · MINUTE · MONTH · NOW · SECOND · TIME · TODAY · WEEKDAY · WEEKNUM · YEAR · ISOWEEKNUM
icon related to Statistical & Aggregations

Statistical & Aggregations

AVERAGE · COALESCE · MAX · MIN · PRODUCT · SUM · SUMSQ
icon related to String Operations & Parsing

String Operations & Parsing

CONCAT · CONCATENATE · LEFT · RIGHT · MID · LEN · FIND · SEARCH · EXACT · CODE · DIFFERENCE
icon related to Trigonometric & Scientific

Trigonometric & Scientific

ACOS · ASIN · ATAN · ATAN2 · COS · COT · DEGREES · RADIANS · SIN · TAN

Transform in a snap with Formula Columns

Define complex data transformations with standard Excel formulas. Let Visitran then convert them into powerful SQL queries.

Start for Free