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 services.
Runs in your browser 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 help
Google Sheets formula help
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 XLOOKUP formulas for Excel and Google Sheets with exact match, multiple criteria, not-found handling, left lookup examples, and #N/A fixes.
Open toolGoogle Sheets Query Builder
Build Google Sheets QUERY formulas for selected columns, WHERE rules, ORDER BY, and date filters in your browser.
Open toolGoogle Sheets FILTER Formula Builder
Build Google Sheets FILTER formulas with AND/OR conditions, text contains, dates, blank checks, and optional sorting. Copy the result without uploading a sheet.
Open toolCOUNTIFS Formula Builder
Build a COUNTIFS formula for Excel or Google Sheets with up to three criteria pairs, date examples, sample task data, and #VALUE! fixes.
Open toolDuplicate Checker Formula Builder
Build Excel and Google Sheets duplicate checker formulas with COUNTIF, blank-row protection, all-duplicate or after-first modes, sample flags, and cleanup tips.
Open toolCSV Column Cleaner
Clean CSV header names into lowercase spreadsheet-friendly column names locally in the browser, with previewed output and no uploads.
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 Formula Example
Copy a SUMIFS by month formula example for Excel and Google Sheets with sample sales data, returned totals, current-month criteria, and error fixes.
Open exampleXLOOKUP Multiple Criteria Formula Example
Copy XLOOKUP multiple criteria formulas for Excel and Google Sheets with sample data, returned price, not-found handling, duplicate notes, and alternatives.
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 Formula Example
Copy Excel and Google Sheets formulas that find duplicate values with sample flags, blank-row handling, second-duplicate logic, and cleanup tips.
Open exampleFormula pages
Ready-to-use formula examples
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 for Excel and Google Sheets with FALSE, sample data, column-index guidance, #N/A fixes, and safer lookup alternatives.
Open formulaSUMIF / SUMIFS Between Dates Formula
Copy SUMIFS between dates formulas for Excel and Google Sheets, with SUMIF notes, fixed dates, cell boundaries, timestamp-safe ranges, and returned totals.
Open formulaWorkdays Between Dates Formula
Copy NETWORKDAYS formulas for Excel and Google Sheets to count business days between dates, exclude weekends and holidays, and verify results with sample data.
Open formulaSplit Text Formula | TEXTSPLIT and SPLIT
Copy Excel TEXTSPLIT and Google Sheets SPLIT formulas for commas, dashes, spaces, multiple delimiters, and split text into columns examples.
Open formulaFlag Duplicate Values Formula
Copy row-by-row formulas that flag duplicate values while ignoring blanks, with Excel and Google Sheets examples, sample flags, and cleanup tips.
Open formulaVLOOKUP Approximate Match Formula
Copy VLOOKUP approximate match formulas for sorted breakpoints such as tiers, grades, or rates, with sample data, match rules, and error checks.
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 with income, expense, category, account, note fields, and Excel or Google Sheets setup guidance.
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 your browser and return results immediately.
- No account, subscription, database, or AI service is required.
- See how formula examples are checked.
FAQ
Are the formula builders free?
Yes. The formula builders, examples, utilities, and free 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 runs in your browser from the fields and options you choose.
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.