Spreadsheet / Data
CSV Formula Generator
Build spreadsheet formulas from a plain-English recipe.
Your data never reaches us
Nifty Utilities has no backend server, database, user accounts, or endpoint capable of receiving your tool inputs. Files and entries are processed inside your browser. We cannot view, capture, or store them.
How do you build spreadsheet formulas without memorizing syntax?
Spreadsheet formulas like XLOOKUP and IFERROR have unfamiliar argument orders that are easy to get wrong. This tool generates ready-to-paste formulas from plain-English inputs: you choose the formula type, enter your cell references, and the tool produces the correct syntax you can copy directly into Excel or Google Sheets.
How to use it
Select the formula type from the dropdown: Sum a range, If/then, XLOOKUP, Join text, or Percent change. Enter your primary cell reference or range in the first field, a second value or range in the second field, and a condition if the formula type uses one. Click Generate formula and the result appears below, ready to copy. Everything happens in your browser; nothing you enter is sent to or stored by this site.
Tips
Use standard spreadsheet range notation in the fields, such as A2:A100 for a column range or B2 for a single cell. The generator produces a formula using those references literally, so double-check that your column and row references match your actual spreadsheet layout before pasting. For the XLOOKUP formula, the tool uses a third column C as the return range by default; edit the generated formula in your spreadsheet if your return values are in a different column.
Frequently asked questions
Which spreadsheet applications will these formulas work in?
SUM, IF, and TEXTJOIN work in both Excel and Google Sheets. XLOOKUP requires Excel 2019 or later, Microsoft 365, or a modern version of Google Sheets. The percent change formula uses IFERROR, which works in both applications.
Can I add custom formulas not in the list?
The tool supports the five formula types in the dropdown. For other formula types, the generated output for a similar formula type may give you a useful starting point to edit manually in your spreadsheet.
Important
This tool provides estimates and general-purpose documents, not financial, tax, legal, or professional advice. Verify important results before relying on them.
Support
Problem with this tool or suggestions for improvement? Please email support@niftyutilities.com.