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 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 Bitwise Operations

Bitwise Operations

BITAND · BITLSHIFT · BITOR · BITRSHIFT · BITXOR
icon related to Data Validation & Quality Checks

Data Validation & Quality Checks

DUPLICATE · FALSE · ISBLANK · ISEVEN · ISNA · ISNUMBER · ISODD · ISTEXT · TRUE
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 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 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