Sum, count, and report by criteria
Build SUMIFS and COUNTIFS formulas for month, region, status, category, or product summaries.
Open workflowSpreadsheet formula tools
Spreadsheet Formula Tools for Excel and Google Sheets
Build copyable formulas, clean spreadsheet-ready CSV headers, and start from lightweight templates. No upload, no account, no AI API.
Browser-local No spreadsheet upload No AI formula guessing Copyable formulas
Choose by task
Start with the spreadsheet job you need to finish
Each workflow points to builders, examples, templates, or utilities that produce something you can copy or download.
Look up values safely
Choose XLOOKUP, VLOOKUP, or INDEX MATCH based on your lookup table and compatibility needs.
Open workflowFilter and query rows
Return matching rows with FILTER or Google Sheets QUERY, including date-range patterns.
Open workflowClean imported CSV data
Clean headers, extract domains, count unique values, and flag duplicates before reporting.
Open workflowWork with dates and columns
Convert column letters, Excel serial dates, and date differences without uploading files.
Open workflowStart from a CSV template
Download simple inventory, budget, and content calendar templates, then add formulas after import.
Open workflowPopular spreadsheet tasks
Jump to a specific formula or cleanup problem
These links point to existing builder, example, utility, and template pages with copyable output or downloadable spreadsheet value.
Excel formula tasks
Google Sheets formula tasks
Cleanup and audit tasks
Spreadsheet template tasks
Core tools
Popular formula and cleanup tools
These are the first tools to use for common Excel, Google Sheets, reporting, lookup, and CSV cleanup workflows.
SUMIFS Formula Builder
Build a SUMIFS formula with one or two criteria, optional month matching, and copy the Excel or Google Sheets result.
Open toolXLOOKUP Formula Builder
Build a single-criterion or multiple-criteria XLOOKUP formula with not-found handling and match mode options.
Open toolGoogle Sheets Query Builder
Free online Google Sheets QUERY builder. Build SELECT, WHERE, ORDER BY, and date-filter formulas in your browser, copy working examples, and fix syntax errors — no download, upload, or sign-in.
Open toolGoogle Sheets FILTER Formula Builder
Free Google Sheets FILTER formula builder: add one or more conditions with AND/OR logic, date filters, text contains, and blank checks, then copy a working FILTER formula — no upload or sign-in.
Open toolCOUNTIFS Formula Builder
Build a COUNTIFS formula with multiple criteria range and value pairs for Excel or Google Sheets.
Open toolDuplicate Checker Formula Builder
Build a COUNTIF-based duplicate checker formula with blank-row protection for Excel or Google Sheets.
Open toolCSV Column Cleaner
Clean CSV header names into simple lowercase spreadsheet-friendly column names locally in the browser.
Open toolDate Difference Formula Builder
Build Excel and Google Sheets formulas to calculate days, completed months, or completed years between two dates.
Open toolCopyable examples
Start from a working formula pattern
SUMIFS by Month in Excel
Copy a SUMIFS by month formula with sample sales data and a month-cell criteria pattern.
Open exampleXLOOKUP with Multiple Criteria
Copy an XLOOKUP multiple-criteria formula that matches two columns at once.
Open exampleGoogle Sheets QUERY Date Range Formula
Copy a Google Sheets QUERY date range formula with fixed dates, start and end date cells, current month, extra conditions, and timestamp-safe boundaries.
Open exampleFind Duplicates in Excel
Copy an Excel formula that flags duplicate values in a column with COUNTIF.
Open exampleFormula pages
Ready-to-use formula tasks
Each page includes Excel and Google Sheets formulas, sample data, common errors, when not to use it, alternatives, and test cases.
VLOOKUP Exact Match Formula
Copy a VLOOKUP exact match formula with sample data, errors, alternatives, and test cases.
Open formulaSUMIFS Between Dates Formula
Copy a SUMIFS formula that totals rows between a start and end date.
Open formulaWorkdays Between Dates Formula
Copy a NETWORKDAYS formula that counts business days between two dates.
Open formulaSplit Text Formula
Copy Excel and Google Sheets formulas for splitting text by a delimiter.
Open formulaFlag Duplicate Values Formula
Copy a row-by-row formula that flags duplicate values while ignoring blanks.
Open formulaVLOOKUP Approximate Match Formula
Copy a VLOOKUP approximate match formula for sorted breakpoints such as tiers, grades, or rates.
Open formulaTemplates
Lightweight CSV templates for spreadsheet workflows
Download free CSV starters, import them into Excel or Google Sheets, then add the recommended formulas.
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.
Private by default
Formula tools without spreadsheet uploads
- You type ranges and criteria manually.
- The site does not upload spreadsheet files or save workbook data.
- Formula builders run in browser scripts from deterministic TypeScript logic.
- No account, subscription, database, or AI API is required.
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.