Excel Formula to JavaScript Converter

Why convert Excel formulas to JavaScript?

Business logic often starts life in a spreadsheet: a pricing model, a commission table, an eligibility check. When that logic moves into a web app, a Node.js API or a Google Apps Script, every formula has to be rewritten by hand — and subtle differences between Excel and JavaScript cause bugs that only show up with real data. This converter parses the formula exactly as Excel does and writes equivalent JavaScript.

=IF(AND(B2>=18, C2="yes"), "Eligible", "Not eligible")

function calculate(B2, C2) {
  return B2 >= 18 && C2 === 'yes' ? 'Eligible' : 'Not eligible';
}

How Excel functions map to JavaScript

Differences that cause bugs

• Operator precedence. In Excel =-2^2 is 4 because negation binds tighter than ^. JavaScript does not even allow -2 ** 2. The converter always adds the parentheses Excel implies: (-2) ** 2.
• Rounding. Excel rounds halves away from zero; Math.round(-2.5) returns −2 and (1.005).toFixed(2) gives "1.00". The generated round() helper matches Excel.
• Remainders. MOD(-7, 3) is 2 in Excel but -7 % 3 is −1 in JavaScript, so a mod() helper is used.
• Text comparison. Excel's = ignores case for text; === does not. Lookups and criteria helpers compare case-insensitively like Excel.
• Concatenation. & always produces text, while + adds numbers. The converter wraps the first operand in String() so A1 & B1 never turns into a sum.
• Errors. Division by zero returns Infinity instead of throwing, so ifError() checks for non-finite results as well as exceptions.

Ranges, lookups and criteria

A single-column or single-row range such as A2:A100 becomes an array parameter; a multi-column range such as A2:C500 becomes an array of rows, which is the shape vlookup() expects. Criteria strings work like in Excel: ">=1000", "<>closed" and wildcards such as "*@example.com".

Supported functions: IF, IFS, SWITCH, AND, OR, NOT, XOR, IFERROR, IFNA, ISBLANK, ISNUMBER, ISTEXT, SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, PRODUCT, MEDIAN, ROUND, ROUNDUP, ROUNDDOWN, INT, TRUNC, ABS, SIGN, MOD, POWER, SQRT, EXP, LN, LOG, LOG10, PI, CEILING, FLOOR, RAND, RANDBETWEEN, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, SUMPRODUCT, VLOOKUP, XLOOKUP, MATCH, INDEX, CONCAT, CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, LEN, UPPER, LOWER, PROPER, TRIM, SUBSTITUTE, REPLACE, FIND, SEARCH, REPT, VALUE, EXACT, TEXT (number formats), TODAY, NOW, DATE, YEAR, MONTH, DAY. Anything else is kept as a call and listed so you can implement it. Need the data too? Turn the sheet into an array with Excel to JavaScript array.

También se busca como: excel to javascript, excel formula to js, google sheets formula to javascript, convert excel formula to code, excel formula to node, spreadsheet formula to javascript, excel formula converter.

Herramientas que combinan con: Excel Formula to JavaScript

• Excel Formula to Python — Paste an Excel or Google Sheets formula and get a Python function with clean variable names, the right imports and helpers for SUMIFS, VLOOKUP and Excel-style rounding.
• Excel Formula to PHP — Paste a spreadsheet formula and get a PHP 8 function: parenthesized ternaries, mb_* string functions, and helpers for lookups, conditional sums and Excel-style MOD.
• Excel Formula to SQL — Paste an Excel formula and get the equivalent SQL expression or SELECT query — IF and IFS as CASE WHEN, SUMIFS and COUNTIFS as conditional aggregates, and the right string and date functions for your database.
• JavaScript Formatter — Unminify and pretty-print JavaScript, JSON or JSX with your preferred indentation and brace style — or strip whitespace and comments with a verified minifier.