Excel Formula Builders
SUMIFS, XLOOKUP, VLOOKUP, INDEX MATCH, COUNTIFS, and date difference builders.
ExcelCopyable formulas
Spreadsheet formula tools
Spreadsheet Formula Tools for Excel and Google Sheets
Build deterministic formulas, copy working examples, inspect sample data, and download lightweight CSV templates for spreadsheet workflows.
Tool categories
Google Sheets Formula Builders
QUERY, FILTER, and REGEXEXTRACT builders with syntax notes and examples.
Google SheetsLocal logic
Formula Examples
Copyable formulas with sample data, explanations, common errors, and related builders.
ExamplesTroubleshooting
Spreadsheet Utilities
Column letter conversion, date serial conversion, and CSV column cleaning.
UtilitiesNo upload
Templates
Free CSV templates for inventory, budgets, and content calendars.
CSVFree
Core tools
SUMIFS Formula Builder
Build a SUMIFS formula with one or two criteria, optional month matching, and copy the Excel or Google Sheets result.
Excel formula builder Copy button
XLOOKUP Formula Builder
Build an XLOOKUP formula with lookup value, lookup array, return array, optional not-found text, and match mode.
Excel formula builder Copy button
VLOOKUP Formula Builder
Build a VLOOKUP formula from lookup value, table range, column index, and exact or approximate match.
Excel formula builder Copy button
INDEX MATCH Formula Builder
Build an INDEX MATCH formula from lookup value, lookup range, and return range for flexible lookups.
Excel formula builder Copy button
COUNTIFS Formula Builder
Build a COUNTIFS formula with multiple criteria range and value pairs for Excel or Google Sheets.
Excel formula builder Copy button
Date Difference Formula Builder
Build Excel and Google Sheets formulas to calculate days, completed months, or completed years between two dates.
Excel formula builder Copy button
Google Sheets QUERY Formula Builder
Build a Google Sheets QUERY formula with SELECT, WHERE, date filter, ORDER BY, and header row options.
Google Sheets formula builder Copy button
FILTER Formula Builder
Build Excel dynamic array and Google Sheets FILTER formulas with one or two conditions.
Google Sheets formula builder Copy button
REGEXEXTRACT Formula Builder
Build a Google Sheets REGEXEXTRACT formula for domains, email domains, first numbers, text in parentheses, or custom patterns.
Google Sheets formula builder Copy button
Excel Column Letter Converter
Convert Excel or Google Sheets column numbers to letters and column letters back to numbers locally in your browser.
Spreadsheet utility Copy button
Excel Date Serial Converter
Convert ISO dates to Excel serial numbers and Excel serial numbers back to dates with local browser logic.
Spreadsheet utility Copy button
CSV Column Cleaner
Clean CSV header names into simple lowercase spreadsheet-friendly column names locally in the browser.
Spreadsheet utility Copy button
Formula examples
SUMIFS by Month in Excel
Copy a SUMIFS by month formula with sample sales data and a month-cell criteria pattern.
Sample data FAQ
SUMIFS with Multiple Criteria
Copy a SUMIFS formula that totals values by region and product with sample data.
Sample data FAQ
XLOOKUP with Multiple Criteria
Copy an XLOOKUP multiple-criteria formula that matches two columns at once.
Sample data FAQ
Google Sheets QUERY Date Range
Copy a Google Sheets QUERY formula that filters rows between two dates.
Sample data FAQ
Google Sheets QUERY Another Sheet
Copy a QUERY formula that reads data from another sheet tab in Google Sheets.
Sample data FAQ
FILTER Rows by Date
Copy Excel and Google Sheets FILTER formulas that return rows on or after a selected date.
Sample data FAQ
Extract Domain from URL in Google Sheets
Copy a REGEXEXTRACT formula that returns the domain from a URL in Google Sheets.
Sample data FAQ
Count Unique Values in Google Sheets
Copy a Google Sheets formula that counts unique nonblank values in a range.
Sample data FAQ
Find Duplicates in Excel
Copy an Excel formula that flags duplicate values in a column with COUNTIF.
Sample data FAQ
Calculate Days Between Dates
Copy a simple Excel and Google Sheets formula for calculating days between two date cells.
Sample data FAQ
Templates
Inventory Tracker Spreadsheet Template
Download a free inventory tracker CSV template for Excel or Google Sheets with reorder levels and supplier fields.
Budget Tracker Spreadsheet Template
Download a free budget tracker CSV template for income, expenses, categories, accounts, and notes.
Content Calendar Spreadsheet Template
Download a free content calendar CSV template for publishing dates, channels, statuses, owners, keywords, and URLs.
FAQ
Are the formula builders free?
Yes. The formula builders, examples, utilities, and MVP CSV templates are free to use.
Do I need to upload my spreadsheet?
No. The tools use manually entered ranges and values. Your spreadsheet files are not uploaded.
Do these tools use AI?
No. Formula generation is deterministic and runs in the browser from typed fields and selected options.
Do the formulas work in both Excel and Google Sheets?
Many formulas work in both. When support differs, the page shows separate outputs or a compatibility note.
Can I copy the example formulas?
Yes. Builder and example pages include copy buttons for formula outputs.